table content display

[Anon]

I'm pretty new at databases, php and mysql. I've picked up a bit of knowledge so far in it. So far I can connect, add, update, delete or display a particular record. However, and I've not created a db that im definately gonna use yet, but have got tables and such in the db for learning purposes. What I want to do, is take say a members table and display it on a members page.

So for instance mem_name, char_type, etc. Is there a way to display ALL the members info in a table on a web page? or say even certain fields in the table for ALL the members?

Right now, I can do it on a query on just 1 particular one, and not too well I may add, but when I put it in the $display_block I dont know what to put to actually show data.

[frigidman]

$sql = "
SELECT member_name,member_type,etcetc
FROM members
ORDER BY member_name ASC
";
$sqlhandle = mysql_query($sql,$sqlconnection);

while ($row = mysql_fetch_array($sqlhandle)) {
echo "$row[member_name] $row[member_type] $row[etcetc]";
}

By using a while loop to store each ROW of data, you can access that rows data per loop. Allowing you to display the contents. Above is crude, you can add html to that, and make each element into a table cd TD and bolod stuff and alter data etc.

You CAN use the database column names like I exampled above. Its much more helpful than referencing by #, because if you ever change your SELECT statement, you have to go adjust all your #s ! eek! using the name in like $row[columnname], makes it much easier.

Hope this gives a good direction to follow.

[frigidman]

$allrows = NULL;
while ($temp = mysql_fetch_array($sqlhandle)) {
$allrows[] = $temp;
}

This will throw all the rows of data into a big multi dim array that you can repeatedly use over and over in various places after you have long since done a mysql_free_result() (like to grab more data from another sql statement).