random gallery

[adex3g]

echo "Random Gallery Items:";
$randomm = mysql_fetch_array(mysql_query("SELECT imageurl, uid FROM ibwf_usergallery WHERE sex='M' ORDER BY RAND() LIMIT 1"));
echo "<img src=\"$randomm[0]\" height=\"50\" width=\"50\" alt=\"$randomm[1]\"/>";
echo "<br/>";
$nick = getnick_uid($randomm[1]);
$urlnick = "$nick";
echo "by: $urlnick";


pls i want the above code to show both male and female gallery, it only showing male gallery. pls help @ALL

[sky2kv]

echo "Random Gallery Items:";
$randomm = mysql_fetch_array(mysql_query("SELECT imageurl, uid FROM ibwf_usergallery WHERE sex='M' ORDER BY RAND() LIMIT 1"));
echo "<img src=\"$randomm[0]\" height=\"50\" width=\"50\" alt=\"$randomm[1]\"/>";
echo "<br/>";
$nick = getnick_uid($randomm[1]);
$urlnick = "$nick";
echo "by: $urlnick";


pls i want the above code to show both male and female gallery, it only showing male gallery. pls help @ALL

$random = mysql_fetch_array(mysql_query("SELECT url, uid FROM table_gallery ORDER BY RAND() LIMIT 1"));
echo "<img src=\"$random[0]\" alt=\"$random[1]\"/>";
echo "<br/>";
$nick = getnick_uid($rnd[1]);
$urlnick = "<a href=\"index.php?action=viewuser&amp;sid=$sid&amp; who=$rnd[1]\"/>$nick</a>";
echo "by: $urlnick";
echo "<br/><br/>";
///////////////////////////////////////////////////////////////
for width and height
echo "<img src=\"$random[0]\" width=\"#\" height=\"#\" alt=\"$random[1]\"/>";

Read through the forums..the codings all here.

[adex3g]

thank you i will try it and give reply