Count Within Loop from Different Table

[Anon]

Ran into small problem, hopefully someone can help....

I need to count records from a different table that match records in a loop. Any suggestion, solutions???

[ace21]

Maybe this is something that can be solved using the COUNT function built into sql? www.mysql.com for more info on COUNT

Ace21

[lobley]

If you put a query to the DB within the loop you can test all of the values. Are the values in an array?

[Anon]

I'm more confused one the queries than anyhing. Would I use a loop within a loop??? No the data isn't in an array.

[lobley]

if you send the code and more information about what you are trying to achive then I can help. If you can write down your code flow it might be easyer to understand. eg.
1) pull info from db
2) Put results into array
3) Test against values in another array
4) The ones that match display on screen

[Anon]

$query = "SELECT posted, jcode, designation FROM listing WHERE uid = '$uid' ORDER by posted DESC";
$result = mysql_query($query, $connection) or die ("Couldn't execute SQL query");
$num = mysql_num_rows($result);

while ($row = mysql_fetch_array($result)) { $jcode = $row["jcode"];
$designation = $row["designation"];
$posted = $row["posted"];

$posted = date("M j", strtotime($posted));

echo"$count<tr>
<td bgcolor='#ffffff' width='60'><font><b><center>$posted</center></b></font></td>
<td bgcolor='#ffffff' width='100' align='center'><font><b>$jcode</b></font></td>
<td bgcolor='#ffffff'><font><b><a href=\"/careers/job_details.php?jcode=$jcode\">$designation</a></b></font></td>
<td bgcolor='#ffffff' width='80'><font><b><center><a href=\"index.php?md=Applicants&jcode=$jcode\">View</a></center></b></font></td>
</tr>"; }

What I need to do is count the applicants from the users table and display the count where View currently is.

I'm trying to explain this, but am kind dumbfounded. I REALLY appreciate your help.

[lobley]

$get_users = "SELECT count(*) AS num_users FROM users";
$users_result = mysql_query($get_users, $connection) or die ("Couldn't execute SQL query");
$get_results = mysql_fetch_array($users_result);
$total_users = $get_results[num_users];

echo $total_users;

If you need to have a table join to join all the users that are related to the listing then it would be different. If that is what you need look up INNER JOINs