PHP and MYSQL

[pranav95]

I try to run a mysql query in my website using php but I get the error mentioned below:-

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource

 

[as4s1n]

That usually means that there was an error with your query. However, no one can help you unless you post the code with this error.

 

[essellar]

The error message means what it says, which means that your problem lies in the query or the connection -- or you could simply have a typo in your code. You'd need to post code in order to get any more help.

 

[varunaroli]

plz use mysql error () command.

Eg:

<?php

$query="select * from tble";

mysql_query($query) or die(mysql_error());

?>

it will help you to find out errors.

 

[misson]

Just make sure you don't use or die or output mysql_error() for non-admin users in production code.

 

[jedaivokters]

try this out http://w3schools.com/php/php_mysql_intro.asp . It has good tutorials

 

[misson]

W3Schools is outdated, inaccurate and incomplete, and that's not just my opinion.

 

[sanji41]

hi im connecting my db on x10hosting which uses cpanel however i can't seem to connect it, i dont know what to put on username and localhost and the dbname..please help!