Hello all,
I have the following code:
echo "<td>\n";
echo "<table width=\"100%\" border=\"0\" align=\"center\"
cellpadding=\"2\">\n";
$sql2 = mysql_query("SELECT signature FROM event ORDER BY cid DESC
LIMIT 10");
while ($row = mysql_fetch_array($sql2)) {
// $cid_alert = $row["cid"];
$number = $row["signature"];
$name = mysql_query("SELECT sig_name FROM signature WHERE sig_id =
$number");
echo "<tr><td><p>$number</p></td><td><p>$name</p></td></tr>\n";
}
echo "</table>\n";
echo "</td>\n";
When I view on my web page, the $number value comes out fine, but the $name
comes out as "Resource ID #x" where x is some number. Currently is says
"Resource ID #6". I know the SQL syntax is right, I have tested it. But what
is wrong here?
I have tried putting single quotes around $number in my query statement. It
dod not work though. If anyone can help, it is greatly appreciated!!!
Thanks,
R Clark
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
