weird MySQL resource error

From: Date: Sat, 28 Dec 2002 20:52:27 +0000
Subject: weird MySQL resource error
Groups: php.general 
Request: Send a blank email to php-general+get-129529@lists.php.net to get a copy of this message
I am getting a "Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource" error only when the commented-out code bellow (starting from $id = bb_sponsor...) is added. If I omit the code the resource is recognized as valid. Can anyone explain? Thanks, loop P.S. - I know my conditions for comparing values are far from accurate, but they work for this particular purpose. /* variables for sponsor table insert */ $insert = ''; $insert_pre = "INSERT INTO bb_sponsor ( id , name , url ) VALUES ("; $insert_post = ");\n"; /* if inputed sponsor name exists, define it's index and url value.*/ while ($row = mysql_fetch_row($sponsor)) { foreach ($bb_sponsor as $key=>$value) { if (levenshtein($bb_sponsor[$key]['name'], $row[1]) <=3 or stristr(($bb_sponsor[$key]['name']), $row[1])) { $bb_sponsor[$key]['id'] = $row[0]; $bb_sponsor[$key]['url'] = $row[2]; } /* $id = $bb_sponsor[$key]['id']; $name = $bb_sponsor[$key]['name']; $sponsor = $bb_sponsor[$key]['url']; $insert = $insert . $insert_pre . "'', '$name', '$sponsor'" . $insert_post; */ } } _________________________________________________________________ Add photos to your messages with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail&xAPID=42&PS=47575&PI=7324&DI=7474&SU= http://www.hotmail.msn.com/cgi-bin/getmsg&HL=1216hotmailtaglines_addphotos_3mf

« previous php.general (#129529) next »