Re: [PHP-DB] SELECT

[peppe]

Hi
I made this query
$sql    = "SELECT * FROM users WHERE FIND_IN_SET( 2, access ) > 0 ";
$result   = mysql_query($sql);
$numRows  = mysql_num_rows($result);

    for ($row =1; $row <= $numRows; $row++) {
          $rowArray = mysql_fetch_array($result);
    $access1   = $rowArray[1];

    if ($access1 =='2'){
    echo "Access is 2 ";
    } else {
echo "acces is not 2";
}
}

I get always access not 2 how can I make this If works
"Ignatius Reilly" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> SELECT
> ...
> FROM users
> WHERE FIND_IN_SET( 2, values ) > 0
>
> Ignatius
> _________________________
> ----- Original Message -----
> From: "peppe" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Thursday, March 04, 2004 12:28
> Subject: [PHP-DB] SELECT
>
>
> > Hi I have a  table users with columns name email and access
> > In email I have values [EMAIL PROTECTED] etc in access I have values
> 1,2,3,4,7,8
> > How can I filter value 2 ?
> > Beacause I need only users with value 2 to send email
> > Greetings
> >
> > --
> > PHP Database Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> >
> >

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php