Menu
Community /Pin to ProfileBookmark
@NogDogJul 22.2005 — #The error message definitely indicates that the query failed (thus the "supplied argument is not a valid MySQL result resource"). Try changing your mysql_query line to something like this so you can at least see what the mysql error message is:
PS: if ordernum is a numeric column, you might not want the quotes around $id (not positive how MySQL feels about automatically casting strings to numbers).
mysql_fetch_assoc
I have an error using the mysql_fetch_assoc defined function..i used it before in a lot of my scripts..what im i doing wron here?? its get an id value from the previous page..it does pass the $_GET proeperly..urghh lol hehe 😡
[code=php]
if(isset($_GET[‘key’])) {
$id = $_GET[‘key’];
$mysql_server = “***********”;
$mysql_user = “***********”;
$mysql_password = “***********”;
$connect=mysql_connect ($mysql_server, $mysql_user, $mysql_password) or die(“cannot make connection”);
$dbselect=mysql_select_db (“***********”) or die(“cannot select database”);
//sql statments
$result = mysql_query(“SELECT * WHERE ordernum = `$id`;”);
while ($row = mysql_fetch_assoc($result))
{
echo $row[“prodnum”];
}
}
I get the following php error:
[I]Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/content/h/i/s/hispanonatura/html/test/products5/admin/vieworder.php on line 31
any suggestions are apprecited ?
Sign in
to post a comment14 Comments(s) ↴
0
@NogDogJul 22.2005 — #The error message definitely indicates that the query failed (thus the "supplied argument is not a valid MySQL result resource"). Try changing your mysql_query line to something like this so you can at least see what the mysql error message is:[code=php]
$query = "SELECT * WHERE ordernum = '$id'";
$result = mysql_query($query) or die("Query failed: " . mysql_error() . " - " . $query);
[/code]PS: if ordernum is a numeric column, you might not want the quotes around $id (not positive how MySQL feels about automatically casting strings to numbers).