fetch_array error...

General Nuisance · #1 08-07-2005, 11:57 PM

hey guys this is making me mad..

what ever im doing wrong i am doing it consistently because every script i have made lately gets same error...

this is the error:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\www\webroot\temp\faqs.php on line 14

and this is code..

PHP Code:


			
<html>

<?php

include ('global.php');

$fq = $_POST['fq'];

$fa = $_POST['fa'];



mysqlconnect();

mysqlselectdb();



//Query for faqs//

$rs ="select * from faqs order by id desc )";

$rs = mysql_query( $rs );



while ( $row = mysql_fetch_array( $rs) )  <---------- line 14

{

?>

<center>

  <li>Q.<?php echo $row['fq']; ?> </li>

  <li>A.<?php echo $row['fa']; ?></li>

</center>

<?php

}

?>

</html>

if yall see whats wrong i would appreciate it if you would tell me how to avoid it.

IcIshoot · #2 08-08-2005, 12:16 AM

why is that ) in your sql query?

Try taking that out.

IcI

General Nuisance · #3 08-08-2005, 12:50 AM

thanks ici

that done it

Scott · #4 08-08-2005, 01:04 AM

Quote:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\www\webroot\temp\faqs.php on line 14

That error almost always means there is an error in the actual mysql query, the the mysql_fetch_array, wheather is be a typo in the query or the table coloums/table's are spelt wrong..

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
DFLW Swapfile error fix error	Hellfighter	Tech Support	0	02-29-2008 03:35 AM
installing DFBHD, I get an error, “An error occurred during the move data process.”	Steve	Delta Force	1	01-09-2007 04:54 AM
If your getting an error with Team Speak with the Richedit Line Insertion Error READ	.DareDevil.	Hardware and Software	0	09-29-2004 03:50 PM
error message, “Error 106.”	Steve	Delta Force	0	01-08-2004 08:27 PM
error need help	bat21_uk	Delta Force	1	09-20-2003 09:51 PM

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