-----Ursprüngliche Nachricht-----
Von: Per Jessen [mailto:p...@computer.org]
Gesendet: Freitag, 4. September 2009 13:05
An: mysql@lists.mysql.com
Betreff: Re: a better way, code technique?
AndrewJames wrote:
>> is there a better way (hopefully simpler) to code this?
>>
>> i want to get the user id of the logged in user to use in my next
>> statement.
>>
>> $q1 = sprintf("SELECT uid FROM users WHERE
>> users.username='$username'");
>The only "improvement" I can see is:
>
>$q1 = sprintf("SELECT uid FROM users WHERE users.username='%s'",
>$username);
sprintf only adds overhead to this. There is no need to use it here.
You can just use $q = "SELECT ...";
Or if you wanna have it more readable use heredoc style
$q = <<<EOSQL
SELECT
uid
FROM
users
WHERE
username = '{$username}'
EOSQL;
But thats a bit off topic ;)
Majk
