mysql_fetch_array errror:

[Radon3k]

The code below is what I have used to make a "Search" feature on my page. I get this error:

"

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/bbadmins/public_html/uid/index.php on line 78"

Search: <input type="text" name="search" style="background:c0c0c0"><br>
<input type="submit" name="subsrch" value="Search" style="background:c0c0c0"><br>

<?php

if($submit == "Search") {
	$dbsrch = mysql_query("SELECT * FROM user WHERE * LIKE '%$search%'");
	if(!$dbsrch) {
		echo("Unable to display search results at this time.");
		exit();
	}
}

while( $row = mysql_fetch_array($dbsrch) or die(mysql_error()) ) {
	echo($row['Name']);
}
?>

The line that is the while loop is line 78.

Thanks for any help! 🙂

[sgoku01]

Does it disappears when you remove ' or die(mysql_error())' ??

[Radon3k]

Yes I added that to see if it would show me the error, but it doesn't.

[Radon3k]

Anybody?

[mahers]

Is register globals off? If thats the case you would have to do:

if($_POST['submit'] =="Search") {

Also the while loop should probably be contained inside the above if statement, otherwise the mysql_fetch_array() function is using an undefined result resource if the search forum isnt submitted.

[Radon3k]

Thanks! 🙂 You got rid of the error, but now it just won't display the results. Any help there?

Thanks again! 🙂

[xblue]

Radon3k, the mysql_error() might be more helpful at this line:

$dbsrch = mysql_query("SELECT * FROM user WHERE * LIKE '%$search%'") or die (mysql_error());

I don't think the 2nd asterisk is valid, you'd probably need to specify a column name here.

With respect to your last post: check if your if-block is still executed at all (put some echo statement in it). Is the form submitted by get or post?

[Radon3k]

Hi,

I added the mysql_error() part as you said, and there is no error being returned. Where would I put the echo command in the if condition? Also, I changed my query to this:

$dbsrch = mysql_query("SELECT * FROM user WHERE name,email,aim,msn,icq,msn LIKE '%$search%'") or die(mysql_error());

Thanks for the help, I appreciate it! 🙂

[xblue]

the echo statement may go anywhere within the if-block.

<?php

if($_POST['submit'] == "Search") {
    echo "inside";
    $dbsrch = mysql_query("SELECT * FROM user WHERE * LIKE '%$search%'") or die(mysql_error());
    if(!$dbsrch) {
        echo("Unable to display search results at this time.");
        exit();
    }
}

while( $row = mysql_fetch_array($dbsrch)) {
    echo($row['Name']);
}
?>

if it does not display "inside", the whole block is not executed.
if so:
1) check you form method - is it post or get?
2) check you php versions, in older ones you would need $HTTP_POST_VARS[] instead of $_POST[], and the same for get requests.

[Radon3k]

Ok well it did not say "inside", so that means that the entire thing is not executing. PHP version is 4.2.3, and I believe that is fairly new (maybe not the newest). I tried using both "post" and "get" for the form methods. hmm...what could be wrong?

[xblue]

4.2 will be okay with $POST or $GET

okay, seems like you have changed a lot of things, so I can't know what your code exactly looks like currently.

I'd suggest to take a look at your form and rewrite you if condition.

if ($_FORMMETHOD['inputname']=="inputvalue")

where formmethod is the current form mehtod in uppercase letters, inputname is the current name of the input field and inputvalue its value.

[Radon3k]

That's pretty much how it looks now, here is my code:

<?php

if($submit == "Search") {
	$dbsrch = mysql_query("SELECT * FROM user WHERE name,email,aim,msn,icq,msn LIKE '%$search%'") or die(mysql_error());
	if(!$dbsrch) {
		echo("Unable to display search results at this time.");
		exit();
	}
	while( $row = mysql_fetch_array($dbsrch) or die(mysql_error()) ) {
	echo($row['Name']);
	}
}
?>

Anything wrong with that (besides it doesn't work :p). Thanks! 🙂

[xblue]

eh, did you read my last post? look at the form, post it if necessary, after all it has to match the code you posted.

[Radon3k]

It does match...I just didn't use the register_globals.

[Radon3k]

OK I got it to the point where it says "inside" but now it won't display the search results. Any idea as to why? Thanks! 🙂

[diego25]

SELECT * FROM user WHERE name,email,aim,msn,icq,msn LIKE '%$search%'

should be

SELECT * FROM user WHERE name LIKE '%$search%' OR email LIKE '%search%' OR etc

Diego

[Radon3k]

Still not displaying the information...What am I doing wrong? 😕

[Radon3k]

Anybody else? Thanks for the help. 🙂