Newbie question about listing data form database

[Aurasia]

I'm using Dreamweaver and I have a test database which I'm accessing across a network. I'm trying to pull all of the values in a series of columns and lay them out in a Dreamweaver page.

There are 5 columns in this table and presently 2 rows (in the database) and I want Dreamweaver to create new table for each of the entries in the database. I want the first "id" column on the left of the table, the 2nd column to be displayed in the middle of the table and the fifth column to be displayed on the right side of the table.

I just don't know how to make that querry to the database. How do you ask, get the first row, then get the second row, then the third ... until there are no more rows?

I catch on quick, but this is only my second day. Thanks in advance for helping me!

[liquorvicar]

$sql = "SELECT * FROM table";
$query = mysql_query($sql,$c);
while ($row=mysql_fetch_assoc($query)) {
  // do your stuff
}

ps try using the PHP online manual. it's really very useful 😉

[Aurasia]

Thanks,

I am using the manual ... there's just so many different functions ... I need to find out what I need first ... kinda build a base of functional code in my head first - then I can diverge and start experimenting.

I know it's a dumb question, but I appreciate the reply.