Storing db values for later

[Rifts]

Hey guys,

What would you recommend to store db values for later?

 

the only thing I can come up with is doing it this way:

$result = mysql_query("SELECT * FROM users WHERE name='$user'");
while($row = mysql_fetch_array($result))
{
}
  {

and then using the $row['dbvariable'] later

 

is that the best way?

 

[nethnet]

Yes, of couse you can name $row anything you like.

 

Also, if you will only expect one row to be returned from the query, you don't need to use a loop to define $row.  Just doing the following will work perfectly fine:

 

<?php

$result = mysql_query("SELECT * FROM users WHERE name='$user'");
if (mysql_num_rows($result) === 1){
     $row = mysql_fetch_array($result);
} else {
     echo "No user found.";
}

?>

 

You should always check to make sure the query returned something before using any of the mysql_fetch_ functions, as a query with 0 results will cause resource warnings.  I simply checked to make sure there was exactly 1 row returned before passing the query resource to mysql_fetch_array().