php and database mysql

[Cord_z]

guys, im just new in php and mysql, i just want to ask some help...
i want my records in my database to be displayed in table form in my homepage. .
.i have 4 columns in my database..
--need help..tnx.

[laserlight]

What have you tried thus far?

[Cord_z]

..I know how to load those data from database, i just dont know if how i am going to load it inside a table with 4 columns.
My database has 4 columns ID, Productname, description, price. . .

[Cord_z]

..I know how to load those data from database, i just dont know if how i am going to load it inside a table with 4 columns.
My database has 4 columns ID, Productname, description, price. . .

[laserlight]

Okay, show us the code that you are currently using to retrieve the data from the database table. From there, we can guide you as to how to format it into a table.

[Cord_z]

---for the connecttion---
<?php

require_once('datacon.php');
 $sl=mysql_query('SELECT * FROM tbl_post WHERE id=1');

?>

--to retrieve---

<p><?php $row=mysql_fetch_array($sl); echo $row['post'];?></p>

this i all i know, im just a beginner..i really need help..
and this code display only 1 out of 4 columns in my database..

[laserlight]

Ah. It only displays one column because you only printed one column. Furthermore, because you are not looping over the result set, it only displays one row of the table.

Are you learning PHP using a book? Your introductory book should have an example with the use of say, a while loop to loop over the result set.