Error?

[wwedude]

I have the following in my site:

$lastVisit = mysql_fetch_array(mysql_query("SELECT column FROM table WHERE username = '$username'"));

 

But, when I echo the $lastVisit it comes up as "Array" when it should be "06", is there a problem in this code?

[cooldude832]

yes a lot of things

 

1) Don't nest it into 1 decleration

2) You didn't error check

3) It is an array of all results in your series

 

better

<?php
$q = "SELECT column FROM table WHERE username = '$username'";
$r = mysql_query($q) or die(mysql_error());
if(mysql_num_rows($r) >0){
$row = mysql_fetch_assoc($r);
print_r($row);
}
?>

[snk]

or

 

echo $lastVisit[0];

 

if you are 100% that there is just one entry.