how to pass string to database query?

[MyMarlboro]

i have a form where user click on a button then will direct him to another form which is database displaying page. i would like to filter the query based on user login id. So i could i do that?


$result = mysql_query("SELECT * FROM myDatabase WHERE name = 'userLoginID'"); // < i could i get the userLoginID and pass it to here??

[Atli]

Hi.

Yes, you can .

[hsriat]

You might SELECT * FROM yourTable rather than yourDatabase

[artov]

Yes, you could, but you do not like to. Study SQL injection (for example from http://en.wikipedia.org/wiki/SQL_injection) and use parameterized statements instead.

[ragonz]

try to
echo $userLoginID;
above that line, to see wheteher u fail or not gain the value from the previous page. If not than check ur method to post the data wheter using POST or GET method.

Regards