retrieving value from MySQL DB,then storing as a Session var

[webguync]

I need some help with this. A user fills out a form, one of the fields is a zip code field. I need to retrieve that value from MySQL store as a session var and set that value as a variable to use with a weather display API. The ID is being stored from the form page.

 

Here is what I have so far, after the values are submitted into the DB.

 

<?php
session_start();
$con = mysql_connect("localhost","peter","abc123");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("my_db", $con);

$result = mysql_query("SELECT * FROM Profile WHERE id='{$_SESSION['id']}");

while ($row = mysql_fetch_assoc($result)) {
    $_SESSION['id'] = $row['id'];
$_SESSION['zip'] = $row['zip'];

}


mysql_close($con);
?>

 

and then for the weather API, I need to set the stored variable to something

$zip = 'stored zip code value'; 

[Rifts]

well since you are setting

 

$_SESSION['zip'] from row[zip]

 

why not just use it

 

$zip = $_SESSION['zip'];

 

now use $zip freely

[BlueSkyIS]

$_SESSION['zip'] = '';
$result = mysql_query("SELECT * FROM Profile WHERE id='{$_SESSION['id']}");
if (mysql_numrows($result) > 0) {
    $row = mysql_fetch_assoc($result);
    $_SESSION['zip'] = $row['zip'];	
}


// Later....
$zip = $_SESSION['zip'];

[webguync]

hmm, why would I be getting this warning?

Warning: mysql_numrows(): supplied argument is not a valid MySQL result resource in/new_site/Weather/weather.php on line 35

 

which is this part

$_SESSION['zip'] = '';
$result = mysql_query("SELECT * FROM Profile WHERE id='{$_SESSION['id']}");
if (mysql_numrows($result) > 0) {
    $row = mysql_fetch_assoc($result);
    $_SESSION['zip'] = $row['zip'];   
}

[suma237]

int mysql_num_rows  ( resource $result  );

check the syntax

[webguync]

sorry not sure I follow. I think the syntax looks ok.

[trq]

You haven't checked that $result is a resource. If your query fails (which it must be) $result will be the boolean false, not a resource which is what mysql_num_rows expects.

 

Always check variables are what you expect them to be before using them.

[webguync]

so basically no results were returned so I get the warning, correct?

[PFMaBiSmAd]

No your query is failing due to an error.

 

A query that executes successfully but matches zero rows is a successful query and does not produce errors when you access the result set (unless you use mysql_result(), which has the misfortune of producing an error when there are zero rows in the result set.)