mysql fetch array keep returning false

Question

function get_subject_by_id($subject_id){
    global $connection; 
    $query = "SELECT * ";
    $query .= "FROM subjects ";
    $query .= "WHERE 'id' ={$subject_id} "; 
    $query .= "LIMIT 1 "; 
    $result_set = mysql_query($query, $connection); 
    confirm_query($result_set); 
    // if no rows are returned fetch_array will return false
    if(!is_null($result_set)){
    echo "got here";
    echo $result_set; 
    } 
    if($subject=mysql_fetch_array($result_set)){ // not working properly
        echo "testing fetch array";
        return $subject; 
    }else {
        return NULL; 
    }

The fetch query keeps returning false although I have 3 items in my table. Some of the code obviously is testing to see if I got result back and those all work but the fetch array isn't executing the if statement because it thinks that it is false. Please help a few hours of frustration belong to this problem

Barmar · Accepted Answer · 2014-02-22 08:07:01Z

3

You have the wrong type of quotes in your query, they should be backticks:

$query .= "WHERE `id` ={$subject_id} "; 
                 ^  ^

Quotes make id a string, not a column name. Since the string id is never equal to $subject_id, the query doesn't return anything.

answered Feb 22, 2014 at 8:07

Barmar

789k57 gold badges554 silver badges669 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Chacliff Over a year ago

thank you for sharing that, it makes more sense as to why it wouldn't work this solved the issue i was having on the client side. Thank you.

Russell England · Accepted Answer · 2014-02-22 08:06:44Z

1

I think it's because the id column is enclosed in single quotes rather than back ticks

$query .= "WHERE 'id' ={$subject_id} ";

should be

$query .= "WHERE id ={$subject_id} ";

Or

$query .= "WHERE `id` ={$subject_id} ";

answered Feb 22, 2014 at 8:06

Russell England

10.3k2 gold badges30 silver badges42 bronze badges

Collectives™ on Stack Overflow

mysql fetch array keep returning false

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related