Posted by Michael Fesser on 08/02/07 09:04

..oO(newbie)

>table `user`
>---------------------------------------
>| id | user_name | gender |
>---------------------------------------
>
>I can gurantee that ids in table user are unique (so each number
>correspond at most one row in the table). I have two questions
>1) can I somehow do away with mysql_fetch_array($result);?
>2) If i use $sql_query = "SELECT user_name from `user` WHERE (id =
>'$id')";

Don't quote $id, it's a numeric value.

>to replace line (1), do I get some better performance
>theoretically?

You need both, a mysql_query() call to query the database and a
mysql_fetch_*() call to get the results. But you could use the second
paramater of mysql_fetch_array() to specify whether it should return the
result as a numeric or associative array. By default it does both.

>if so, can I simply return $row; ---because
>'user_name' is the only field being selected.
>
> $sql_query = "SELECT * from `user` WHERE (id = '$id')"; // (1)

You shouldn't use "SELECT *" in production code, list all columns
explicitly.

Micha

• Next in forum: Re: PHP in html
• Prev in forum: Re: comparing datetime() in database
• Thread view: Re: am I doing unnecessary operations by mysql_fetch_array?

[Reply to this message]