select a single coloumn from mysql

[charles07]

have you ever wondered how to select a single coloumn from mysql using php & checking whether a value or variable exists in the resulting array... well here is the code

 

$busid = '5412';

$results    =  mysql_query("SELECT `myname` FROM mytable WHERE myuser = 'user'");

        while($rows = mysql_fetch_array($results))

        { 

            $colnames[] = $rows['myname'];

        }

        if(!in_array($busid, $colnames))die("Access denied");

[SergeiSS]

You are selecting an information (MySQL) and then check if something exists in it (PHP). You'd better do it inside MySQL's request.

For example:

SELECT `myname` FROM mytable WHERE myuser = 'user' and myname='5412'

 

Maybe "WHERE myname='5412'" is enough.

 

Send this request and then check just a number of rows in result but not values. It will work faster. The difference could be 10e-3 seconds, of course, or something like this

[charles07]

thanks SergeiSS,

 

i think you are right, but WHERE myuser = 'user' is needed since each myname is related to specific users.

anyways let me try out your code.

[MasterACE14]

add 'LIMIT 1' to the end of the query if you want just a single record.

[charles07]

thanks SergeiSS

 

that worked like a charm

 

SELECT `myname` FROM mytable WHERE myuser = 'user' and myname='5412'

 

iam a enthusiastic newbie to PHP, googled the saem topic but couldn't get an answer, now it looks fine

[SergeiSS]

I'm glad that it helps Just to note: it's not a PHP task, it's MySQL task. I'd recommend you to read more about MySQL.