Warning: mysql_fetch_assoc(): supplied argument is not a val

[knoxville]

Hi

I have some problems with mysql in xampp
here's the full error: Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in C:\apachefriends\xampp\htdocs\php\memberinfo.php on line 16

here's line 16: while ($record = mysql_Fetch_assoc($resultaat)){

i always get such errors with mysql also when i use mysql_fetch_object instead of mysql_Fetch_assoc and mysql_fetch_row().

can anyone help me? probably i have the wrong settings?

[Wiedmann]

All you need is there...

supplied argument is not a valid MySQL result resource

So, "$resultaat" is not a resource, maybe the value of this variable is just "FALSE".
The error must be in (or before) the line, where you set this value.

[knoxville]

hmm weard, maybe you can check: http://217.170.17.98/php/memberinfo.php, you see the error a couple of times.
and if you check http://217.170.17.98/php/memberinfo.php?id=1 then you see nothing so it didn't get info from the database

here's what i did in one of those cells:
<?php
include ("verbinding.php");
mysql_connect ("$dbhost","$username","$dbww");
mysql_select_db ("$db") or die ("Fout opgetreden");
$query = "SELECT * FROM users WHERE ID = $_GET[id]";
$resultaat = mysql_query ($query);
while ($record = mysql_Fetch_assoc($resultaat)){
echo "$record->uid<br>";
}
?>

i really can't find the prob prolly coz im pretty new to this

[Wiedmann]

$query = "SELECT * FROM users WHERE ID = $_GET[id]";

This print out the correct query?

Code: Select all

echo  "SELECT * FROM users WHERE ID = $_GET[id]";

$resultaat = mysql_query ($query);

No error handling for mysql_query ()?

echo "$record->uid<br>";

$record is no object.

[alucard01]

- what about using "mysql_fetch_assoc" (small letter f).
- Your code seems to be incorrect.

You codes should be like this:

<?php
include ("verbinding.php");
mysql_connect ("$dbhost","$username","$dbww");
mysql_select_db ("$db") or die ("Fout opgetreden");
$query = "SELECT * FROM users WHERE ID = $_GET[id]";
$resultaat = mysql_query ($query);
while ($record = mysql_fetch_assoc($resultaat)){
echo $record["uid"]."<br/>"; //CORRECTION HERE ONLY
}
?>