convert resource to variable?

[rubing]

How do I assign the contents of a resource (e.g. results of a mysql query) to a variable.

 

I attempted using $var = echo $result;

 

but did not work.

 

thanks

[BlueSkyIS]

you need to use a mysql function to pull the values into an array, for instance:

 

$row = mysql_fetch_array($result);

 

then $row is an array of the values for that record, with the keys being the column names, e.g.,

 

$user_name = $row['userName'];

[Orio]

What exactly do you want to do?

You want to convert the resource to a string? For that use serliaze().

[rubing]

I am forwarding my emails to a php script and then executing a query to my database.  I want to mail the results using mail()

 

This has been very tricky to do, b/c if there is ever any standard output the email bounces with failed delivery.

[BlueSkyIS]

you need to use a mysql function to pull the values into an array, for instance:

 

$row = mysql_fetch_array($result);

 

then $row is an array of the values for that record, with the keys being the column names, e.g.,

 

$user_name = $row['userName'];

[rubing]

hmmmm....so how can i convert all of the resulting records into a string type variable  ???

[rubing]

can i do something like this???

 

while ($row = mysql_fetch_array($result))

{global $message

$message .= print_r($row,true);

}

 

[rubing]

yup worked!

 

Thanks Rubing You're the best! 

 

blueskyis and orio are cool too