Storing images and text retrieved from mysql-db, into a table
| From: | gert vonck | Date: | Sat, 22 Mar 2003 00:56:30 +0000 |
| Subject: | Storing images and text retrieved from mysql-db, into a table | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-26549@lists.php.net to get a copy of this message | ||
hello,
i'm not very good with php and mysql, so this can look like a silly easy question.
I have a mysql database named 'oh'. there are 20 tables under it.
Now, i want to store 1 image and some text (8 to be exact) in a table.
I want to have 1 table with 3 column, and the first two are divided into 8 rows each.
1st column, 1st row, shows like this example : the boss :
2nd column, 1st row, shows : mr.Van dooren3rd column is for image) what i should retrieve from my table is the actual name of the field (boss), the value of that field (mr.Van dooren) en one time an image. How can i load them into such a table? with this code, i can show 1 image. :os <?php $sql = @mysql_query("SELECT picture_right FROM info_general") or die (mysql_error()); while($a_row = mysql_fetch_array($sql)) { $img_1= $a_row["picture_right"]; } mysql_close(); ?> <img src="<? echo($img_1); ?>"> Can someone help me please? Mvg, Gert Vonck _________________________________________________________________ MSN Search, for relevant search results! http://search.msn.be