calling all php and mysql guru's

[CP,]

Originally Posted by SirAdrian

The PHP variable... if its empty (and I'm pretty sure it is) the query will die because:

SELECT * FROM TABLE WHERE id = ;

Is not valid.

Ohh ok, no its not empty it has:


$result = mysql_query("
SELECT *
FROM contacts
WHERE member_id = $member_id
") or die(mysql_error());
$row = mysql_fetch_assoc($result);


please check with this: http://www.photo-host.org/img/958319table.jpg did i do it right?



$strsql="SELECT email, firstname, surname, address_line1, ".
"address_line2, city_county, postcode FROM ".
"contacts WHERE id = '$member_id'";