Menu
Community /Pin to ProfileBookmark
@NogDogAug 03.2005 — #When you see that "not a valid MySQL resource" error, that mean your query failed (or you made a typo entering the variable name you used to capture the return value of the mysql_query() call.) In this case, either you did not successfully connect to the database (which I see no code for, so it might be in the header.php include?), or there was a syntax error in the query (which looks OK to me).
It's always a good idea to check the result of your mysql_query. I ususally so something simple like this when debugging, then maybe put in more robust error-handling later:
This way, if the query fails, it prints out the MySQL error message and the actual text of the query so I have half a chance of figuring out what happened.
while($result2 = mysql_fetch_assoc($sql2)) problem
is this wrong? it did work then with out doing anything to it(i think) it came up with this
[b]Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/sheldon/public_html/test/mva/viewuser.php on line 13
here is the code below
[code=php]<?
//INCLUDE THE HEADER – HEADER CONTAINS CONNECTTION AND SESSION START
include(“header.php”);
?>
<p class=”header”>All Members</p>
<?
//SQL QUERY TO SELECT ALL OF THE USERS
$sql2 = “SELECT * FROM users”;
$sql2 = mysql_query($sql2);
//WHILE USERS ARE IN THE DATABASE DO THE FOLLOWING
while($result2 = mysql_fetch_assoc($sql2)) {
//print user information
echo(“<span class=nav />Id:</span />{$result2[‘id’]} –
<span class=nav />Name:</span />{$result2[‘name’]} –
<span class=nav />email:</span />{$result2[’email’]} –
<span class=nav />username:</span />{$result2[‘username’]} –
<span class=nav />passowrd:</span />{$result2[‘password’]}”);
?>
</p>
<?
//END WHILE
}
//INCLUDE FOOTER
include(“footer.php”);
?>
Thanks
Sheldon
Sign in
to post a comment2 Comments(s) ↴
0
@NogDogAug 03.2005 — #When you see that "not a valid MySQL resource" error, that mean your query failed (or you made a typo entering the variable name you used to capture the return value of the mysql_query() call.) In this case, either you did not successfully connect to the database (which I see no code for, so it might be in the header.php include?), or there was a syntax error in the query (which looks OK to me).It's always a good idea to check the result of your mysql_query. I ususally so something simple like this when debugging, then maybe put in more robust error-handling later:
[code=php]
$query = "SELECT * FROM table";
$result = mysql_query($query) or die("Query Failed: " . mysql_error() . " - " . $query);
[/code]This way, if the query fails, it prints out the MySQL error message and the actual text of the query so I have half a chance of figuring out what happened.