I'm trying to write a script that checks for multiple entries on a table in a 
database.  So far I've been plagued by MySQL errors.  I'm fairly confident my 
scripting is ok (Then again, I've been wrong before.)  I think moreover there might be 
some difficulty with my theory.  Then again, I could try and do this with MySQL join 
statements.  Any feedback would be appreciated.

$sqlquery = mysql_query("SELECT * FROM local_shows");

while ($row = mysql_fetch_array($sqlquery)) {

$newquery = mysql_query("SELECT * FROM local_shows WHERE show_date='$row[show_date]' 
AND venue='$row[venue]'");

while ($row2 = mysql_fetch_array($newquery)) {

$num_rows = mysql_num_rows($row2);

if ($num_rows>1) {

 print "etc etc"  (Do things with my $row2 data)

I get loads of:

  Warning: Supplied argument is not a valid MySQL result resource in 
/home/ufr2/underfoot-www/admin/dupeshows.html on line 51

Can you not reselect in another while while selecting?  Does that make any sense to 
anyone but me?  I shouldent have to open another DB connection?

Anyhow... your I would appreciate any help.


Reply via email to