Results from SQL

MitchEvans

I need some help with the following code, my website loads fine but the the word "array" appears instead of my results.

<?php
$db = mysql_select_db("mitch",$connection)
or die ("Couldn't select database");
$query = "SELECT * from product";
$result = mysql_query($query)
or die ("Couldn't execute query");
$row = mysql_fetch_array($result,MYSQL_BOTH);
extract ($row);
echo $row
?>

Any ideas?!?

hagen00

Here's one
http://www.php.net/mysql_fetch_array

And another one
http://www.catb.org/~esr/faqs/smart-questions.html

bpat1434

1.) You extract the variables from the array $row
2.) You echo the array.....

You need to either (A) use [man]mysql_fetch_array/man and loop through it to get the results or (😎 echo the variable names ($1, $2) to get what you want.

I think what you want is something like:

<?php
$db = mysql_select_db("mitch",$connection)
or die ("Couldn't select database");
$query = "SELECT * from product";
$result = mysql_query($query)
or die ("Couldn't execute query");

while($row = mysql_fetch_array($result,MYSQL_BOTH))
{
    echo $row['column1_name'];
}
?>