[RESOLVED] Trying to output table contents - fetch error!

[conjurer]

I am just looking for a simple way to test if my database is working. Wanted to get a listing of the contents of the user table from my bookmarks database but the code I am using generates the following errror message.

Fatal error: Call to a member function fetch_assoc() on a non-object in /home/consult/public_html/development/Testing/26/dbtest2.php5 on line 14

The code running in php5 is as follows:

<?php 
$mysqli = new mysqli('localhost',"consult_test", "password");
$mysqli->select_db("consult_bookmarks");

$result = $mysqli->query("SELECT * FROM users");

while($row = $result->fetch_assoc()) {
	print $row['username'] . ' ' . $row['passwd'].' ' . $row['email']. '<br/>';
}

$result->close();
?>

Are you guys sure this php stuff works! j/k - just wish I knew what I was doing wrong. At least I got the parsing errors sorted!

[m_tt]

I am not sure what the mysqli class is, but the error is telling you that $result is not an object, therefor you cannot call a function from it with $result->fetch_assoc().

Perhaps it should be $row = $mysqli->fetch_assoc($result)?

[conjurer]

Tried that - now it gives:
Fatal error: Call to undefined method mysqli::fetch_assoc() in /home/consult/public_html/development/Testing/26/dbtest3.php5 on line 14

[conjurer]

So what would be a way after connecting to get it to just display all three rows of the data in my user table?

[m_tt]

I just looked up mysqli, your code is fine, perhaps $result is returning an empty set.

Try adding if $result. If the query is empty, the error code will disappear.

if ($result)	{
	while($row = $result->fetch_assoc()) {
		print $row['username'] . ' ' . $row['passwd'].' ' . $row['email']. '<br/>';
	}
} else {
	print "empty query";
}

[conjurer]

Hmmmm, it prints "empty query" now, but it shouldn't

There should be two rows in the table.

[m_tt]

Is your database and table names correct? Does consult_bookmarks.users exist?

[conjurer]

SQL result

Host: localhost
Database: consult_bookmarks
Generation Time: Oct 18, 2006 at 12:39 PM
Generated by: phpMyAdmin 2.8.0.2 / MySQL 4.1.21-standard
SQL query: SELECT * FROM user LIMIT 0, 30 ;
Rows: 2
username passwd email
bm_user 5baa61e4c9b93f3f0682250b6cf8331b7ee68fd8 [e-mail]
Houdini 2e71112960430c23b947f52978099524b8b9d068 [e-mail]

[conjurer]

That is from the phpadmin window

[m_tt]

user and users is not the same table 😉

[conjurer]

You sure? I thought they were.

Off to try that. Thanks.

[conjurer]

user and users is not the same table

By golly you are right. :eek:

Works now! Thank you!

And I thought I had carefully checked that to make sure I didn't do something that stupid!