You don't need to use var_dump. Just use the following statements: $newquery = mysql_query("SELECT * FROM local_shows WHERE show_date='$row[show_date]' AND venue='$row[venue]'"); print $newquery;
-----Original Message----- From: Jonathan Underfoot [mailto:[EMAIL PROTECTED]] Sent: Friday, February 08, 2002 8:48 AM To: Jeroen Timmers Cc: [PHP-DB] Subject: Re: [PHP-DB] MySQL / PHP Database Help What does bool(false) mean? Thats off the vardump.... -J ----- Original Message ----- From: "Jeroen Timmers" <[EMAIL PROTECTED]> To: "Jonathan Underfoot" <[EMAIL PROTECTED]> Cc: "[PHP-DB]" <[EMAIL PROTECTED]> Sent: Friday, February 08, 2002 8:58 AM Subject: Re: [PHP-DB] MySQL / PHP Database Help > Hello, > > something that you can help is the follow > > try var_dump($newquery); > > then you see the complete query and run it in phpmyadmin. > Jeroen > ----- Original Message ----- > From: "Jonathan Underfoot" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Friday, February 08, 2002 2:43 PM > Subject: [PHP-DB] MySQL / PHP Database Help > > > 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]'"); > > var_dump($newquery); /* for example to see the query */ > > 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. > > -Jonathan > > > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php