New to PHP/MySQL - Need help with images

From: Date: Sat, 05 Jan 2008 22:51:47 +0000
Subject: New to PHP/MySQL - Need help with images
Groups: php.db 
Request: Send a blank email to php-db+get-44484@lists.php.net to get a copy of this message
I'm attempting to make a table with one row and 3 columns holding three different images. I want each image URL to be called from my database. Everything is set-up in my database. When I use the following code, it places the same picture across the three columns and does this three times (creating three rows.) I want a different picture to be placed across the three columns and to have only one row. What can I do? Here is the code: $result = @mysql_query('SELECT image FROM specials'); $num=mysql_numrows($result); $i = 0; while ($i < $num) { $image=mysql_result($result,$i,"image"); ?> <table> <tr> <td> <img src="<? echo "$image"; ?>"> </td> <td> <img src="<? echo "$image"; ?>"> </td> <td> <img src="<? echo "$image"; ?>"> </td> </tr> <? $i++; } echo "</table>"; ?> -- Using Opera's revolutionary e-mail client: http://www.opera.com/mail/

« previous php.db (#44484) next »