Select Problem

[forumnz]

What have I done wrong? It should be simple.

 

Code:

<?php $uid = $row['uid'] ;
echo $uid; 

$con = mysql_connect("localhost","aaa","aaa");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("aaa", $con);

$result = mysql_query("SELECT * FROM currentclients WHERE 'id'=$uid");

while($row = mysql_fetch_array($result))
  {
$fname = $row['fname'] ;
$lname = $row['lname'] ; 
$url = $row['url'] ; 
$email = $row['email'] ; 
$address = $row['address'] ; 
$phone = $row['phone'] ; 
$active = $row['receive'] ;
}

echo $fname;
mysql_close($con);


?>

 

Error:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /usr/local/www/vhosts/aaa.com/httpdocs/clientemail/edit.php on line 22

 

Thanks,

Sam.

[revraz]

Change

 

WHERE 'id'=$uid");

 

to

 

WHERE id='$uid'");

[revraz]

Also, to avoid this error, you should check the number of rows returned before you put the results in an array, since there is no point to the array if the results are empty.

[PFMaBiSmAd]

A result set with zero rows does NOT generate that error message. Only a query that failed (syntax error, no connection to database server, no database selected...) does.