Programming Forums > Web Development and Design > PHP

dnathe4th · Oct 15th, 2004, 5:24 AM

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/h2zdesig/public_html/chat.php on line 39

*its impossible to search Google for this cause it appears so often*

How do I fix that? the line looks like this

(Toggle Plain Text)

function getMessages() {
  $rs = mysql_query( "SELECT * FROM MINICHAT ORDER BY NB" );

  $ret = Array();
  while ( $msg = mysql_fetch_array( '$rs' )) {
   $ret[] = date('h:m', $msg['ITSTIME'] )." ".$msg['LOGIN']." >".$msg['MESSAGE'];
  }

  return $ret;
}

Ade · Oct 15th, 2004, 5:48 AM

Just looked at some of my code and I don't have the ' either side of the variable.

like

mysql_fetch_array($result) instead of mysql_fetch_array( ' $result ' )

?

Might not make a difference but it's all I can see between your code and one that works for me.

Pizentios · Oct 15th, 2004, 10:41 AM

For sure that's the problem. a resource result doesn't need quotes.

dnathe4th · Oct 17th, 2004, 3:42 PM

no beans, I've tried every variation, adn it still doesn't like it

(Toggle Plain Text)

function getMessages() {
  $rs = mysql_query("SELECT * FROM MINICHAT ORDER BY NB");

  $ret = Array();
  $msg = mysql_fetch_array($rs);
  while ( $msg ) {
   $ret[] = date('h:m', $msg['ITSTIME'] )." ".$msg['LOGIN']." >".$msg['MESSAGE'];
  }

  return $ret;
}

dnathe4th · Oct 17th, 2004, 4:28 PM

I got it, by adding

(Toggle Plain Text)

if (!$rs) {
  die('Invalid query: ' . mysql_error());
}

i found were it was exactly erring out, and fixed it

Pizentios · Oct 18th, 2004, 10:40 AM

So the Problem was with your SQL then? Looks like you were missing a ; now that i think about it. Then again, i am a postgresql user ;-) I don't know that much about how mysql querys work.

anyways, glad to hear that you got it working.

kurifu · Oct 19th, 2004, 4:14 PM

Quote:

Originally posted by Pizentios@Oct 18 2004, 02:40 PM
So the Problem was with your SQL then? Looks like you were missing a ; now that i think about it. Then again, i am a postgresql user ;-) I don't know that much about how mysql querys work.

anyways, glad to hear that you got it working.

Actually with PHP, Perl, and almost every other database binding interface you never place the trailing ";" since you can only execute one query at a time anyway. And for some servers, this means you do not need the trailing '\g'

This includes Postgre and the DBI:: module in perl.

Pizentios · Oct 19th, 2004, 4:22 PM

hmmm, i put it into my querys i think....never really put much thought to it. What happens if i leave em in?

BlazingWolf · Oct 19th, 2004, 5:08 PM

You can use them but they are not nessecary.

It's kinda nice just to do it though because most commands/statements end in a ;.

tempest · Oct 27th, 2004, 10:27 AM

You have to send the mysql resource as an argument to the function so that the variable can be used inside of the function.

When you open the connection with mysql_connect assign the connection to a variable. Although it will be assumed in all other parts of your code, you will need this when calling your function.

(Toggle Plain Text)

function getMessages($resource) {
 $rs = mysql_query( "SELECT * FROM MINICHAT ORDER BY NB", $resource );

 $ret = Array();
 $count = 0;

 while ( $msg = mysql_fetch_assoc($rs))
   $ret[$count++] = date('h:m', $msg['ITSTIME'] )." ".$msg['LOGIN']." >".$msg['MESSAGE'];

 return $ret;
}

Im not 100% on that so you could also try...

(Toggle Plain Text)

function getMessages() {
 $rs = mysql_query( "SELECT * FROM MINICHAT ORDER BY NB");

 $ret = Array();
 $count = 0;

 while ( $msg = mysql_fetch_assoc($rs))
   $ret[$count++] = date('h:m', $msg['ITSTIME'] )." ".$msg['LOGIN']." >".$msg['MESSAGE'];

 return $ret;
}

And that could just work.

Hope ive helped.

Oct 15th, 2004, 5:24 AM	#1
dnathe4th Programmer Join Date: Oct 2004 Posts: 32 Rep Power: 0	Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/h2zdesig/public_html/chat.php on line 39 its impossible to search Google for this cause it appears so often How do I fix that? the line looks like this (Toggle Plain Text) function getMessages() { $rs = mysql_query( "SELECT * FROM MINICHAT ORDER BY NB" ); $ret = Array(); while ( $msg = mysql_fetch_array( '$rs' )) { $ret[] = date('h:m', $msg['ITSTIME'] )." ".$msg['LOGIN']." >".$msg['MESSAGE']; } return $ret; } function getMessages() { $rs = mysql_query( "SELECT * FROM MINICHAT ORDER BY NB" ); $ret = Array(); while ( $msg = mysql_fetch_array( '$rs' )) { $ret[] = date('h:m', $msg['ITSTIME'] )." ".$msg['LOGIN']." >".$msg['MESSAGE']; } return $ret; } __________________ <CENTER><span style='font-size:17pt;line-height:100%'>My Homepage</span></CENTER>

Oct 15th, 2004, 5:48 AM	#2
Ade Hobbyist Programmer Join Date: Oct 2004 Location: England, UK Posts: 139 Rep Power: 0	Just looked at some of my code and I don't have the ' either side of the variable. like mysql_fetch_array($result) instead of mysql_fetch_array( ' $result ' ) ? Might not make a difference but it's all I can see between your code and one that works for me. __________________ Don't wound what you can't kill

Oct 15th, 2004, 10:41 AM	#3
Pizentios Programming Guru Join Date: May 2004 Location: Brandon, Manitoba, Canada Posts: 2,023 Rep Power: 7	For sure that's the problem. a resource result doesn't need quotes. __________________ Profanity is the one language that all programmers understand. Check out my Blog <---updated Nov 30 2007!

Oct 17th, 2004, 3:42 PM	#4
dnathe4th Programmer Join Date: Oct 2004 Posts: 32 Rep Power: 0	no beans, I've tried every variation, adn it still doesn't like it (Toggle Plain Text) function getMessages() { $rs = mysql_query("SELECT * FROM MINICHAT ORDER BY NB"); $ret = Array(); $msg = mysql_fetch_array($rs); while ( $msg ) { $ret[] = date('h:m', $msg['ITSTIME'] )." ".$msg['LOGIN']." >".$msg['MESSAGE']; } return $ret; } function getMessages() { $rs = mysql_query("SELECT * FROM MINICHAT ORDER BY NB"); $ret = Array(); $msg = mysql_fetch_array($rs); while ( $msg ) { $ret[] = date('h:m', $msg['ITSTIME'] )." ".$msg['LOGIN']." >".$msg['MESSAGE']; } return $ret; } __________________ <CENTER><span style='font-size:17pt;line-height:100%'>My Homepage</span></CENTER>

Oct 17th, 2004, 4:28 PM	#5
dnathe4th Programmer Join Date: Oct 2004 Posts: 32 Rep Power: 0	I got it, by adding (Toggle Plain Text) if (!$rs) { die('Invalid query: ' . mysql_error()); } if (!$rs) { die('Invalid query: ' . mysql_error()); } i found were it was exactly erring out, and fixed it __________________ <CENTER><span style='font-size:17pt;line-height:100%'>My Homepage</span></CENTER>

Oct 18th, 2004, 10:40 AM	#6
Pizentios Programming Guru Join Date: May 2004 Location: Brandon, Manitoba, Canada Posts: 2,023 Rep Power: 7	So the Problem was with your SQL then? Looks like you were missing a ; now that i think about it. Then again, i am a postgresql user ;-) I don't know that much about how mysql querys work. anyways, glad to hear that you got it working. __________________ Profanity is the one language that all programmers understand. Check out my Blog <---updated Nov 30 2007!

Oct 19th, 2004, 4:22 PM	#8
Pizentios Programming Guru Join Date: May 2004 Location: Brandon, Manitoba, Canada Posts: 2,023 Rep Power: 7	hmmm, i put it into my querys i think....never really put much thought to it. What happens if i leave em in? __________________ Profanity is the one language that all programmers understand. Check out my Blog <---updated Nov 30 2007!

Oct 19th, 2004, 5:08 PM	#9
BlazingWolf Hobbyist Programmer Join Date: Sep 2004 Posts: 207 Rep Power: 5	You can use them but they are not nessecary. It's kinda nice just to do it though because most commands/statements end in a ;. __________________ _______________________________ BlazingWolf

Oct 27th, 2004, 10:27 AM	#10
tempest Programming Guru Join Date: Oct 2004 Posts: 1,041 Rep Power: 6	You have to send the mysql resource as an argument to the function so that the variable can be used inside of the function. When you open the connection with mysql_connect assign the connection to a variable. Although it will be assumed in all other parts of your code, you will need this when calling your function. (Toggle Plain Text) function getMessages($resource) { $rs = mysql_query( "SELECT * FROM MINICHAT ORDER BY NB", $resource ); $ret = Array(); $count = 0; while ( $msg = mysql_fetch_assoc($rs)) $ret[$count++] = date('h:m', $msg['ITSTIME'] )." ".$msg['LOGIN']." >".$msg['MESSAGE']; return $ret; } function getMessages($resource) { $rs = mysql_query( "SELECT * FROM MINICHAT ORDER BY NB", $resource ); $ret = Array(); $count = 0; while ( $msg = mysql_fetch_assoc($rs)) $ret[$count++] = date('h:m', $msg['ITSTIME'] )." ".$msg['LOGIN']." >".$msg['MESSAGE']; return $ret; } Im not 100% on that so you could also try... (Toggle Plain Text) function getMessages() { $rs = mysql_query( "SELECT * FROM MINICHAT ORDER BY NB"); $ret = Array(); $count = 0; while ( $msg = mysql_fetch_assoc($rs)) $ret[$count++] = date('h:m', $msg['ITSTIME'] )." ".$msg['LOGIN']." >".$msg['MESSAGE']; return $ret; } function getMessages() { $rs = mysql_query( "SELECT * FROM MINICHAT ORDER BY NB"); $ret = Array(); $count = 0; while ( $msg = mysql_fetch_assoc($rs)) $ret[$count++] = date('h:m', $msg['ITSTIME'] )." ".$msg['LOGIN']." >".$msg['MESSAGE']; return $ret; } And that could just work. Hope ive helped. __________________

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Programming Forums > Web Development and Design > PHP

Mysql_fetch_array()