尝试这个:
$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'].'';
}