set results to variable

[kev wood]

i want to pull a result from a mysql table but instead of echoing the result out i want to set it to equal a variable.  would the code look like this

 

$query = "SELECT email_count FROM sent_messages";
$result=mysql_query($query);

while($row=mysql_fetch_array($result, MYSQL_ASSOC)){
$sent_mail = $row['sent_messages'];

 

it is the line with $sent_mail i am unsure about

[blirette]

It should do the trick. Just try it!

 

Be sure to do something with the variable before the loop restart because it'll be reassigned on the second pass thought!

[kev wood]

could it be written without this line in

 

while($row=mysql_fetch_array($result, MYSQL_ASSOC))

 

as there is only one value inside the table for it to pick from