how to show al the content of a database

CAN YOU HELP ME ON THIS PROBLEM ?

i must display data content also!

thank you!

Use a while() loop.

$query = mysql_query ("select * from tablename");

while ($data = mysql_fetch_array($query)) {
$num = count($data);
for ($ct = 0; $ct < $num; $ct++) {
echo $data[$ct]." ";
}
}

$query = mysql_query ("select * from tablename");

while ($data = mysql_fetch_array($query)) {
echo $data[field_name];
}

I've never heard of the [field_name] thing. I'll have to give it a whirl.

But if you're just using field_name to stand in for the field name read in by the fetch_array command, then you're not quite answering his question..

That will only produce one item from the row, not all the data from the database.

Could always use print_r instead of my for loop. I was just allowing for more output control with the for loop.

All you have to do is something like this ...

echo $row[\"field1\"];
echo $row[\"field2];

use all your fields and it will pull them all from the array.

oops left out a quote on the second one. And they would not be escaped with slashes in the real script.