View Single Post
  #2 (permalink)  
Old 11-06-03, 11:32 PM
ChristGuy ChristGuy is offline
Operations Support Develo
 
Join Date: Jun 2003
Location: Rivonia, South Africa
Posts: 111
Thanks: 0
Thanked 0 Times in 0 Posts
Greetingz,

Firstly could you post the structure of the tables and some test data...

Also

I'd change:
PHP Code:

$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'];

to
PHP Code:

$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']; 
You could try that...
__________________
Till We Meet Again...
Clifford W. Hansen
Aspivia (Pty) Ltd

"We Have Seen Strange Things Today!" Luke 5:26
Reply With Quote