MySQL

query results

Please support our MySQL advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

Thread Solved

•

Join Date: Feb 2008

Posts: 347

Reputation: kevin wood is an unknown quantity at this point

Solved Threads: 1

kevin wood kevin wood is offline

Offline

Posting Whiz

query results

May 30th, 2008

after i have run my query on a mysql db how can i set the result to equal a variable that i will use later on in the page.

i have set the query up like this

 Help with Code Tags 
 MySQL Syntax (Toggle Plain Text) 
 <?php
$rand = RAND (0, 100);	
$query = "SELECT broad1 FROM images_broad";
$result=mysql_query($query);
 
while($row=mysql_fetch_array($result, MYSQL_ASSOC)){
$send_mail =$row['broad1'];
}
 
?>
 <?php
$rand = rand (0, 100);	
$query = "SELECT broad1 FROM images_broad";
$result=mysql_query($query);

while($row=mysql_fetch_array($result, MYSQL_ASSOC)){
$send_mail =$row['broad1'];
}
		     
?>

i dont think the last line is correct though. could anyone please help.

•

Join Date: Feb 2008

Posts: 347

Reputation: kevin wood is an unknown quantity at this point

Solved Threads: 1

kevin wood kevin wood is offline

Offline

Posting Whiz

Re: query results

May 30th, 2008

is it correct and this is why i get no reply. or is no one playing out?

•

Join Date: Dec 2007

Posts: 252

Reputation: ProfessorPC is an unknown quantity at this point

Solved Threads: 27

ProfessorPC ProfessorPC is offline

Offline

Posting Whiz in Training

Re: query results

May 30th, 2008

you are pulling from all rows in the db. your variable will only display the last rows info. but yes that should work for using that var later in the page.

•

Join Date: Feb 2008

Posts: 347

Reputation: kevin wood is an unknown quantity at this point

Solved Threads: 1

kevin wood kevin wood is offline

Offline

Posting Whiz

Re: query results

Jun 2nd, 2008

the end code look like this

 Help with Code Tags 
 MySQL Syntax (Toggle Plain Text) 
$query = "SELECT sent_messages FROM email_count"OR die(mysql_error());
$results = mysql_query($query);
$arr = mysql_fetch_array($results);
$sent_mail = $arr[0];
$query = "SELECT sent_messages FROM email_count"or die(mysql_error());
$results = mysql_query($query);
$arr = mysql_fetch_array($results);
$sent_mail = $arr[0];