Hi there...do you guys know how to echo all the entries in a whole table (MYSql). What function do you use? I mean the entire entries in a table not just one single row. Thanks guys.

PHP Code:

$result = mysql_query("SELECT * FROM mytable");
while($row = mysql_fetch_array($result))
{
    // print them out
} 


Just a query without any WHERE clause.

Ok

But then is there a way to refer each row separately after you get all the entries. Like if you want to diplay row 6 only you do something like $data[5]. Is there a way to do that?

All you have to do is build your own array,

PHP Code:

$data = array(); // initialize is to keep me happy (as you know, in PHP it's not required)
$result = mysql_query("SELECT * FROM mytable");
while($row = mysql_fetch_array($result))
{
    $data[] = $row;
} 

echo $data[5]['Name']; // echo row 6's field 'Name' (if it were to exist) 


Wow...Great..thanks a lot