making a php function that If mysql returns 0 rows, return false

Question

Im trying to get the function below to return TRUE if it finds a matching row, and FALSE if it finds 0 rows.

function IsOpenEvent($id) {
    $result = mysql_query("SELECT * FROM `events`
                             WHERE `access` = 'public'
                               AND `id` = '$id'
                             LIMIT 1")
                or die(mysql_error());
    if ($result) {
        return TRUE;
    } else {
        return FALSE;
    }
}

Brendan Long · Accepted Answer · 2009-12-10 07:32:47Z

4

return mysql_num_rows($result) != 0;

answered Dec 10, 2009 at 7:32

Brendan Long

54.6k21 gold badges154 silver badges194 bronze badges

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

1 Comment

Brendan Long Over a year ago

I like the kind of questions where I can answer with one line of code :)

Svetlozar Angelov · Accepted Answer · 2009-12-10 07:33:07Z

2

if (mysql_num_rows($result) == 0)
    return false
else 
    return true

answered Dec 10, 2009 at 7:33

Svetlozar Angelov

21.8k7 gold badges64 silver badges68 bronze badges

Comments

Deniss Kozlovs · Accepted Answer · 2009-12-10 07:35:04Z

2

return (bool) mysql_num_rows($result)

answered Dec 10, 2009 at 7:35

Deniss Kozlovs

4,8392 gold badges30 silver badges36 bronze badges

Comments

Carson Myers · Accepted Answer · 2009-12-10 11:25:11Z

0

just to let you know, you should really be calling mysql_real_escape_string() on $id, otherwise you're leaving an SQL injection vulnerability in your code.

answered Dec 10, 2009 at 11:25

Carson Myers

38.7k42 gold badges131 silver badges183 bronze badges

Collectives™ on Stack Overflow

making a php function that If mysql returns 0 rows, return false

4 Answers 4

1 Comment

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related