Help with fetching a result from mySQL

hoax_monkey

Hi, I have a field for postcode/ZIP address and I am trying to retrieve the postcode held in the database for a certain customer. I think the problem may be that I am using mysql_fetch_array when I should be using something different?.
The code & error are below:

CODE:
<p><b>postcode:</b> <input type="text" name="postcode" size="40" maxlength="40" />
<?php // Retrieve the postcode and add to field.
$query = "SELECT postcode FROM customer WHERE customer.customer_id = {$_SESSION['customer_id']}";
$result = @ ($query);
while ($row = mysql_fetch_array ($result, MYSQL_ASSOC)) {
echo "<input type=\"text\" name=\"postcode\" size=\"40\" maxlength=\"40\" value=\"{$row['customer_id']}\">{$row['postcode']}/>\n";
}
?>
ERROR:
mysql_fetch_array(): supplied argument is not a valid MySQL result resource

Thanks

TTT

you have error because you have misspelled something in query or customer_id is not int or there is no rows...

<p><b>postcode:</b> 
<input type="text" name="postcode" size="40" maxlength="40"> 

<?php // Retrieve the postcode and add to field. 
$query = "SELECT postcode FROM customer WHERE customer_id = ".$_SESSION['customer_id']; 
$result = @mysql_query ($query); 
if(mysql_num_rows($query) != 0) {
   $row = mysql_fetch_array ($result); 
   echo "<input type='text' name='postcode' size='40' maxlength='40' value='$row[0]'>"; 
} else {
  echo "no rows";
}
?>

hoax_monkey

Hey thanks for your reply, but I still seem to be getting the error:

mysql_num_rows(): supplied argument is not a valid MySQL result resource

Do you have any clue to why this would be?
Cheers

rastem

mysql_num_rows() fetches the results from the identifier, not the query itself. In other words:

$result = @mysql_query ($query); 
if(mysql_num_rows($query) != 0) {

should be

$result = @mysql_query ($query); 
if(mysql_num_rows($result) != 0) { // from $query to $result

That'll work.

Jon7800

Play with this...it should work:

$sql = "SELECT
postcode
FROM customer
WHERE customer.customer_id = {$_SESSION['customer_id']}

$result = @mysql_query($sql,$connection) or die("Couldn't execute query!");

while ($row = mysql_fetch_array($result)) {

$postcode = $row['postcode'];


}

echo $postcode