weird MySQL resource error
| From: | James Brennan | 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