Storing images and text retrieved from mysql-db, into a table

From: 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 dooren
3rd 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

« previous php.db (#26549) next »