use results from one query in another query on same page

matthewst

<?php
include('user_check.php');
include('db_con.php');
?>

<html>
<head>
<title>Reports</title>
</head>
<body bgcolor="white">
<font face="Verdana, Arial, Helvetica, sans-serif">
<center>Ad Number<br><br></center>	

<?php
$tableid=68;
echo "<center><strong>$tableid</strong><br><br></center>";
$query="SELECT * FROM ad_order WHERE cust_id=$tableid";
$result=mysql_query($query);
$num=mysql_numrows($result);
mysql_close();
$i=0;
while ($i < $num)
{$id=mysql_result($result,$i,"id");
//////////////////////////////////////////////////////////////////
//////I need something like query=SELECT time FROM job_log WHERE id=$id
//////echo $id $time associated with that id
//////then go on with the loop
//////////////////////////////////////////////////////////////////
echo "<center>$id<br></center>";
$i++;}
?> 

</body>
</html>

My page looks like this:
Table ID

id#
id#
id#
id#

What I need is this:
Table ID

id# time
id# time
id# time
id# time

Ben Stein voice "Anyone, anyone?"

ahundiak

So what seems to be the problem? Make your query and execute it then loop over the results.

I noticed that you had a mysql_close() in your code. That will prevent subsequent queries so you might want to remove it. usually not needed anyways.

Might also want to look at JOIN statements. You really only need one query.

NogDog

If using MySQL >= 4.1, you could also use a sub-query, something like:

$query = "SELECT id, time FROM job_log WHERE id IN (SELECT cust_id FROM ad_order WHERE cust_id=$tableid)";

Roger_Ramjet

Definitly need to remove the mysql_close(): closing a connection will kill all resources associated with that connection, like for instance the query results you want to process in the next statement???

Weedpacket

Incidentally, if you're going to write a [man]for[/man] loop you might as well write a for loop, instead of simulating one.