[RESOLVED] Reading an array

[dcjones]

Hi all,

don't know why but I am having trouble reading the content of an array. This is what I have:

mysql_select_db($database_test, test1);
$query_eventlist = sprintf("SELECT * FROM table1 WHERE category = %s", GetSQLValueString($colname_eventlist, "text"));
$eventlist = mysql_query($query_eventlist, $test1) or die(mysql_error());
$row_eventlist = mysql_fetch_assoc($eventlist);
$totalRows_eventlist = mysql_num_rows($eventlist);


$x=array($eventlist);
 foreach ($x as $value)
   {
   echo $value . "<br />";
   }

what I am trying to to is print out all the records from the query result.

Many thanks in advance.

Cheers,

Dereck

[cahva]

$eventlist is a mysql resource, not the result(well its a result but not the result you can loop just like that). Use mysql_fetch_assoc and while to loop through the result:

while ($r = mysql_fetch_assoc($eventlist))
{
    print_r($r);
}

[dcjones]

hi cahva,

Many thnks for your reply and solution. I should have known this.

Thanks

Dereck