mysql_fetch_array problems

t_galan

Can't seem to get a mysql_fetch_array working in my script. Here's the error message:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/www/db/test1.php on line 15

Here's what line 15 looks like:

$line = mysql_fetch_array($result, MYSQL_BOTH);

I can post the entire script if need be.

Thanks in advance.

ScubaKing22

Can you post the area around this line, preferably where $result is being created? Invalid result resource means that you are using the result from an invalid/non-existent query.

MarineX69

Also if your not connected to your database youll get that error, make sure you got your DB info right.

laserlight

To summarise:
A "not a valid MySQL result resource" error means that
a) no or failed database connection
b) no or failed database selection
c) no or failed query, perhaps due to malformed query string
with respect to the result resource attempted for use in the function.

t_galan

I did confirm the database connection so I don't think that's the problem, but what do I know. I also confirmed that $id has a value. Here's the entire script:

<?php
//Include files
include "conf/addheader.php" ;
include "conf/dbcall.php" ;

// db
if ( $id != "" ) {
  $result=mysql_query("SELECT * FROM submitters WHERE email='$id'");

  if(!$result) {
    print('MySQL ERROR:' . mysql_error());
  }
}

$line = mysql_fetch_array($result, MYSQL_BOTH);

?>

<b><?php echo $line[0]?></b>

Thanks

laserlight

There's a little spaghetti code over there.
If $id was blank, mysql_fetch_array() would still be executed.

Try something along the lines of:

<?php
//Include files
include "conf/addheader.php" ;
include "conf/dbcall.php" ;

// db
if (!empty($id)) {
	$result = mysql_query("SELECT * FROM submitters WHERE email='$id'")
		OR die(mysql_error());
	$row = mysql_fetch_array($result);
	echo '<b>' . $row[0] . '</b>';
} else {
	echo 'id not specified';
}
?>

t_galan

Awesome, thank you very much.
For some reason, $id holds no value but when I look at the output of <?phpinfo()?>, I see that the value of _POST["id"] is equal to the value I entered on the form page. I replaced $id with a hard coded value and confirmed that the script connects to the db and spits out the requested information. Any ideas as to why I can't get a value into $id?

Here's my form:

<form name="report" method="post" action="results.php">
<input type=text maxlength=25 size=30 name=id>
<input type="submit" value="Submit">
<input type="reset" value="Reset">
</form>

Thanks again.

Mirage

Simple one I use.

if (!$id) {
$result = mysql_query("SELECT * FROM submitters WHERE email='$id'")
OR die(mysql_error());
$row = mysql_fetch_array($result);
echo '<b>' . $row[0] . '</b>';
} else {
echo 'id not specified';
}

t_galan

Well, could not figure out why $id would not hold a
value but I did find another solution that works.

$result = mysql_query("SELECT * FROM submitters WHERE email='$_POST[id]'")

Thanks to everyone for their help.

laserlight

Any ideas as to why I can't get a value into $id?

Because register_globals in php.ini is set of Off, which is now the default and perhaps more secure setting.

For development purposes it is ok to use $_POST['id'] straight out of the box, but as you go along to remember to validate your incoming data, otherwise you may become a victim of malicious SQL and code injection attacks.