trying to view an array

seanpaulcail

I have a call to a function on my index page:

display_categories();

the function display_categories looks like this

function display_categories()
{
$conn = db_connect();
$query = "select catid, catname from categories";
$result = @($query);
print_r($result);
echo "<ul>";
while ($row = mysql_fetch_array($result)) {
$url = "show_cat.php?catid=".($row["catid"]);
$title = $row["catname"];
echo "<li>";
do_html_url($url, $title);
}
echo "</ul>";
echo "<hr>";
}

I have print_r($result) so that I may view my query
but the repsonse I am getting is:
"Resource id #2"

you can see this @ http://www.caillouette.com/CHAPTER26a/index.hml

The categories show up just fine but their links aren't working.

I just to view the array "$result"

thanks

edwardsbc

$result is NOT an array, it is exactly what it says it is - a resource identifier (think pointer) to the result set. You are retreiving the results into $row correctly. What did you expect to see in $result (if it were an array)? Maybe there is some other way to get the information you wanted to see.

seanpaulcail

I would like to view the array on my screen so that I may better underatnd exactly how things are working.

It's not for the finished product it's just for my own education.

So what do I type to view the array?

Thanks

edwardsbc

The easiest way is:

print_r($row);

Harder, but easier to read would be something like this:

echo '<pre>';
foreach($row as $k=>$v) {
echo 'Key: ',$k,' Value: ',$v,"\n";
}
echo '</pre>';

This will show the key($k) and value($v) pairs of the array $row