help with mysql_fetch_array

Anon

Hey everyone,

I need a little help with a fetch array.

Here is the code:

30 $sql = "SELECT * FROM players WHERE player_id=$player_id";
31
32 $result = mysql_query($sql);
33
34 $myrow = mysql_fetch_array($result);

Then I proceed to bring the results into a form for online editing. It gives the following error:

Warning: Supplied argument is not a valid MySQL result resource in /www/sportscardsource/changes/edit.php on line 34

What is wrong with that statement?

amcgrath

This may not b it, but it's not evident from what you posted: but are you sure you have instantiated a connection to the database?

[deleted]

"Supplied argument is not a valid MySQL result resource"

that would suggest that your query is not executed.

use error checking, check if mysql_query was ok, and print mysql_error() if it was not.

Anon

Here is the whole top portion of the code

<?php

$db = mysql_connect("localhost", "domain", "password");

mysql_select_db("mydb",$db);

if ($player_id) {

if ($submit) {

$sql = "UPDATE players SET position='$position', team_id='$team_id', photo='$photo' WHERE player_id=$player_id";

$result = mysql_query($sql);

echo "Thank you! Information updated.\n";

} else {

// query the DB

$sql = "SELECT * FROM players WHERE player_id=$player_id";

$result = mysql_query($sql);	

$myrow = mysql_fetch_array($result);

?>

Of course I have replaced the words domain and password for my domain and password.

I am sure it is not a connection thing. I was getting errors like that before when I forgot to put in the correct password.

Anon

Thanks for the help!

I was sending it to the wrong database.