Count from another table, for the array.

[Anon]

I need to count from another table, but the count needs to coincide with the first array......any help???

First array:
$query = \"SELECT jcode, designation, posted FROM listing WHERE uid = \'$uid\'\";
$result = mysql_query($query, $connection) or die (\"Couldn\'t execute SQL query\");

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

I need to count:
$query=\"SELECT count(mid) from jobman where jcode=\'$jcode\'\";