help please

Eclipse · #1 (**permalink**) 11-12-2005, 11:26 AM

take a look at www.evolution-design.net/tutorials.php and see how i have a problem with the tutorial.php page on line 72 u look at it and i cant see anything wrong (im not good with it anyways) so how can i fix this. if you need the tutorial.php you can just ask me and i will paste the code.

jitender · #2 (**permalink**) 11-12-2005, 11:43 AM

i got below error

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/evolutio/public_html/tutorial/tutorial.php on line 72

i think check the sql result first, may be mysql get no value.

if yes check the mysql connection use connection value at the time of running the sql

Regards
Jitender

Eclipse · #3 (**permalink**) 11-13-2005, 02:21 AM

well i wouldn't have a clue where to start? could you give me directions on how to do that.

jitender · #4 (**permalink**) 11-15-2005, 06:55 AM

Hi there,

First you check the mysql connection, i found common mistake, guys start the connection but not add in mysql, make sure the below

PHP Code:


		
			
$connection=mysql_connect($SQL_SERVER, $SQL_USER, $SQL_PASS);
$db=mysql_select_db($SQL_DBASE,$connection);

now make sure when you execute the sql

PHP Code:


		
			
$results = ($sql,$db);

Check it again.

if it is ok!

Now Check the what data you get in results. if there is no data in result you get the same error.

Try the above.

Best of luck

Jitender

help please

General Web Design