Select * from table ??WHERE??

Anon

I am tring to do a query where there is 2 arguments in the where.
"SELECT * FROM table WHERE user=$user date=$date";
I have tried alot of things and I cant get it to go!! Can someone help!!.
I have looked everywhere and hopeing that phpbuilder can help!.

Thanks

Anon

Add an AND operator between the arguments.

Anon

also...
put quote before and after the variable statement....
example :
"select * from tuser where user='$user'"

manjeman

maybe u can use

"SELECT * FROM table WHERE user='$user' AND date='$date'";

if these 2 field are compulsory.

or replace AND to OR if where statement is a choices.

hope it will help u.

Anon

On a similar theme, I want to do something similar but I want to get the info from the url....

for example the url would be index.php?id=1 and so you'd get that record from the database, but I can't seem t figure out how to do it.

SELECT * FROM tble WHERE id="?????"

This may be one of those stoppid newbie questions, but then I'm a stoopid newbie :-)

Cheers

Brad

Anon

Hi again, I figured it out with a bit of research (it helps to know what these things are called)..

Any way, if your interested:

if ($HTTP_POST_VARS = $id) gets the info from the URL

and then you do your SQL thang like this

$sql = "SELECT * FROM tbl WHERE id=$id";

so then on your link you'd have index.php?id=1 and it'll do its thing for that record.

Hope this helps someone who was in the same boat as I was.

Regards

Brad