mysql 查询复选框_如何检索从MySQL数组中检查复选框？

尝试这个：

$a = mysql_query("

SELECT g.galleryname FROM gallery AS g, multigalleries AS m

WHERE g.galleryname = 'gallery1' AND FIND_IN_SET(g.galleryname, m.galleries)

");

$b = mysql_fetch_assoc($a);

echo '

if($b['galleryname'])

{

echo ' checked="checked"';

}

echo '>';

编辑： H2>

$result = mysql_query("

SELECT g.galleryname, m.galleryname AS name FROM gallery AS g

LEFT JOIN (SELECT galleryname, galleries FROM multigalleries) AS m ON

FIND_IN_SET(g.galleryname, m.galleries)

");

while($row = mysql_fetch_assoc($result))

{

$checked = '';

if($row['name'])

{

$checked = ' checked="checked"';

}

echo '

'.$row['galleryname'].'';

}