Re: MySQL / PHP Database Help

you need to print the qeury and i guess you print the result in the var_dump i use always var_dump instead a print because the var_dump have more info. jeroen ----- Original Message ----- From: "Jonathan Underfoot" <jonathan@underfoot.cc> To: "Jeroen Timmers" <jeroen@start4me.nl> Cc: "[PHP-DB]" <php-db@lists.php.net> Sent: Friday, February 08, 2002 3:47 PM Subject: Re: [PHP-DB] MySQL / PHP Database Help > What does bool(false) mean? > > Thats off the vardump.... > > -J > > ----- Original Message ----- > From: "Jeroen Timmers" <jeroen@start4me.nl> > To: "Jonathan Underfoot" <jonathan@underfoot.cc> > Cc: "[PHP-DB]" <php-db@lists.php.net> > 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" <jonathan@underfoot.cc> > > To: <php-db@lists.php.net> > > 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 > >