$rst = mysql_query("SELECT * FROM $randtable WHERE $idvar = '$rand[$randnum]' LIMIT 1", $link) or die('Could not retrieve random entry from databse. Please check the $idvar variable under IMPORTANT TABLE INFO to make sure the id field is correct'); // $q = mysql_fetch_array($rst); while ($row = mysql_fetch_array($rst)) { $qtargetID = $row['targetID']; $qtargetEmail = $row['targetEmail']; $qclientID = $row['clientID']; }
$rst = mysql_query("SELECT * FROM $randtable WHERE $idvar = '$rand[$randnum]' LIMIT 1", $link) or die('Could not retrieve random entry from databse. Please check the $idvar variable under IMPORTANT TABLE INFO to make sure the id field is correct'); $row = mysql_fetch_array($rst); $qtargetID = $row['targetID']; $qtargetEmail = $row['targetEmail']; $qclientID = $row['clientID'];