Posting All Entries

[Pioneer5000]

I need some help with posting information from a database to a page. So pretty much what i am doing is i have a html page where you enter information into, kinda like a information entry page and then a seperate page which then display's the infomation which is sent to the database from the other page. At the moment i have no problem with the infomation being echoed out but the thing is it only prints the last entry nothing else. How do i get it to post all the infomation sent to the database on the page the displays the infomation. At the moment im using:

"SELECT * FROM table1 ORDER BY date_auto";

this seems to be the correct thing to do but why is it only posting the last entry sent to database, when i run the above code in a mysql terminal it prints all the entries so why is the page not displaying all the entires?

Can someone help?

[coldwerturkey]

whats your php code for printing the data?

does it look similar to this?

$query = "SELECT * FROM table1 ORDER BY date_auto";
$result = mysql_query($query);
while($row = mysql_fetch_array($result)) {
	echo "{$row['column_name']}
	{$row['column_name']}
	{$row['column_name']}
	{$row['column_name']}
	"; //etc "column_name" being the actual names of the columns within 'table1'

}

[Pioneer5000]

No i didn't do it the way you posted but ive got it working now, I used a for statement but didn't put the echo stuff within the { } of the for statement, lol. But thanks anyway cause looking at your code made me realise what i had done wrong. Thanks.