Mysql SELECT query returns false when ran in PHP

Asked Aug 18 '15 at 11:08

Active Aug 18 '15 at 11:44

Viewed 39 times

I'm trying:

$mysqli = new mysqli(DB_SERVER,DB_USERNAME,DB_PASSWORD,DB_DATABASE);
$usernames_results = $mysqli->query("SELECT username FROM users WHERE user_id = $member_id") or trigger_error($mysqli->error);
while($user_row = $username_results->fetch_object()) {
// do stuff with$user_row
}

This always returns FALSE. I'm certain $member_id is not null and that it does exist in the database. I ran the SQL query directly on the database and it returns the correct result. The error I get is

Fatal error: Call to a member function fetch_object() on a non-object`

when calling fetch_object() on $usernames_results.

$mysqli is also defined correctly because this works:

$conversations_results = $mysqli->query("SELECT UserID, ConversationID FROM Conversation_Members WHERE UserID = $user_id");

I have tried looking at $mysqli->error but it's empty.

What am I doing wrong in the first query?

This question has been wrongly marked duplicate before. Please do not mark this as a duplicate unless you're certain the suggested duplicate answers my problem.

edited Aug 18 '15 at 11:23

asked Aug 18 '15 at 11:08

Youssef Moawad

2,846
5
28
50

`$member_id` is integer? Have you ran it on mysql? – Sougata Bose Aug 18 '15 at 11:11
Can you show other syntax of `$usernames_results` ? – Harshit Aug 18 '15 at 11:11
check whether username and user_id exists in users table – Happy Coding Aug 18 '15 at 11:12
This information is incomplete to understand your problem!! Can you post your full code along with the value of`$member_id` – Saty Aug 18 '15 at 11:12
@b0s3 yes. I output $member_id and ran the query on MySQL with the output value and it returned the correct result. – Youssef Moawad Aug 18 '15 at 11:12
1

@YourCommonSense the suggested duplicate doesn't answer my question. Please reopen this question. – Youssef Moawad Aug 18 '15 at 11:14
try to print "SELECT UserID, ConversationID FROM Conversation_Members WHERE UserID = $user_id" – apm Aug 18 '15 at 11:16
or try to run it on phpmyadmin or in database directly – apm Aug 18 '15 at 11:16
@apm I did do that and that query works. – Youssef Moawad Aug 18 '15 at 11:18
1

show your full code including which MySQL API you are using to connect with. `mysql_`? `mysqli_`? PDO? check for errors on PHP and the query also – Funk Forty Niner Aug 18 '15 at 11:19
@Fred-ii- please check the edits. – Youssef Moawad Aug 18 '15 at 11:24
3

ahem `$usernames_results` and `$username_results->fetch_object()` - having used error reporting, it would have thrown an undefined variable notice. http://php.net/manual/en/function.error-reporting.php – Funk Forty Niner Aug 18 '15 at 11:26
2

question answered I do believe ^ *si?* – Funk Forty Niner Aug 18 '15 at 11:35
@YoussefSami if my comments above solved it, let me know. If so, you can either delete your question, or I will reopen it and reclose it with this link http://stackoverflow.com/questions/4261133/php-notice-undefined-variable-and-notice-undefined-index which is more appropriate, should that be the case. You didn't say anything, so I am moving on. Cheers – Funk Forty Niner Aug 18 '15 at 11:43
1

@Fred-ii- it did indeed solve my problem. Thank you. – Youssef Moawad Aug 18 '15 at 11:44
1

You're welcome Youssef. I reopened and reclosed, *cheers* glad it got resolved. – Funk Forty Niner Aug 18 '15 at 11:44

Mysql SELECT query returns false when ran in PHP

0 Answers0