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
