Retrieving data using php

solo1 · #1 (**permalink**) 07-19-2007, 09:18 AM

Hi, does anyone here know how to display data from mysql database in columns rather than lists or rows?

FireFox · #2 (**permalink**) 07-20-2007, 02:14 PM

Quote:

Originally Posted by solo1

Hi, does anyone here know how to display data from mysql database in columns rather than lists or rows?

How you mean? In tables?

shendo00 · #3 (**permalink**) 07-23-2007, 11:27 PM

i dont remember the code

$mysql $connect..

like that..lol

Jay_Z · #4 (**permalink**) 07-25-2007, 04:55 PM

Are you talking about HTML tables? If not, be more specific.

Calibula · #5 (**permalink**) 07-26-2007, 03:51 AM

Something like this?

PHP Code:


			
$sql = mysql_query("SELECT * FROM cars");
while($row=mysql_fetch_array($sql)){
$car = $row['car'];
$photo = $row['photo'];

echo "<table>
<tr>
<td>Car</td>
<td>Photo</td>
</tr>
<tr>
<td>$car</td>
<td>$photo</td>
</tr>
</table>";
}

If not, I didn't got the idea..

solo1 · #6 (**permalink**) 07-28-2007, 03:23 AM

Thanks for the replies but I've figured it out.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode