Ad:

MySQL Discussion Thread
Marked Solved
Views: 1031

May 30th, 2008

query results

Expand Post »

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

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.

Similar Threads

test mysql query for no results in PHP
Displaying query results dynamically in table in PHP
Database Query Help in MS SQL
FILTER QUERY results on a FORM? in Visual Basic 4 / 5 / 6
pagination of mysql query results in PHP

kevin wood

Reputation Points: 27

Solved Threads: 1

Posting Whiz

Offline

347 posts
since Feb 2008

Permalink

May 30th, 2008

Re: query results

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

kevin wood

Reputation Points: 27

Solved Threads: 1

Posting Whiz

Offline

347 posts
since Feb 2008

Permalink

May 30th, 2008

Re: query results

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.

ProfessorPC

Reputation Points: 31

Solved Threads: 29

Posting Whiz in Training

Offline

270 posts
since Dec 2007

Permalink

Jun 2nd, 2008

Re: query results

the end code look like this

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];

thanks for the reply though

kevin wood

Reputation Points: 27

Solved Threads: 1

Posting Whiz

Offline

347 posts
since Feb 2008

This thread is solved

Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in MySQL Forum Timeline: help needed!

Next Thread in MySQL Forum Timeline: mysql question

DaniWeb Message

Cancel Changes

User Name
Password