Posted by Fire Juggler on 07/09/05 18:42

Hi I have this this code
{while ($row = mysql_fetch_array($numresultsgal)) {
$table=$row{'table_gal'};
$numresultphotos=mysql_query("SELECT * FROM" .$table. "order by date desc");
$numphotos=mysql_num_rows($numresultphotos);

echo"<b>Gallery:</b> " .$row{'gallery'}. "<br>";
echo "<b>No. Of Photos:</b> " .$numphotos. "<br>" ;}

But it keeps failing to produce the number of photos in the gallery. But it
will display the table name if i want it to. So it's got the correct name,
so any ideas why it's failing and not telling me how many rows are in the
database.

Thanks

--
Kathryn (Fire Juggler)
http://www.firejugglers.34sp.com
http://www.cornwalljugglers.co.uk

• Next in forum: Absolute or relative paths
• Prev in forum: PHPMailer: HT avoid error msges going back to wwwrun?
• Thread view: Loops

[Reply to this message]