It's something simple but.

[teejayuu]

I know that this is something simple but I can't get this to work

$sql="SELECT `trackid` FROM `".hesk_dbEscape($hesk_settings['db_pfix'])."tickets` WHERE `responded` =0 AND DATEDIFF( NOW( ) , `lastchange` ) >=1";
$result = hesk_dbQuery($sql);

while($res = hesk_dbFetchAssoc($result))
{
$trackingID = $res['trackid'];

$sql = "SELECT `t1`.* , `t2`.`email` AS `resemail` , `t2`.`name` AS `rname` , `t3`.`centre_name`
FROM `tickets` AS `t1`
LEFT JOIN `responder` AS `t2` ON `t1`.`r_name` = `t2`.`id`
LEFT JOIN `centres` AS `t3` ON `t3`.`id` = `t1`.`name`
WHERE `t1`.`trackid` = '" . $trackingID . "' LIMIT 1";

$result = mysql_query($sql);
$row = mysql_fetch_assoc($result);

$tid = $row['trackid'];
/*Testing */
$t++;
echo nl2br("Iteration = $t\nTracking ID = $trackingID \n\n");

}

The first $sql statement returns 4 trackingid's, but the

echo nl2br("Iteration = $t\nTracking ID = $trackingID \n\n");

only returns the first.

If I comment out

$result = mysql_query($sql);
$row = mysql_fetch_assoc($result);

this returns all 4 tracking ID's.

What am I missing? I know it's something simple
Thanks
Tony

[teejayuu]

Solved conflicting $result's - changed second to $res and it worked.