Quick Query Question

[RobRocker]

Hey guys, I have a quick question

How do I add two WHERE statements? I used this code and it seems to output a error.

CODE:

$query_Props = "SELECT * FROM p_Sales WHERE datatable = 'c_4Sale' AND `user` = $username ORDER BY id ASC";

ERROR:

You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '* ORDER BY id ASC' at line 1

Now the $username is a variable that calls a function.

$username = username();

And this is the function

if($row_name['level'] != 'Admin')
{
function username(){
return '"'.$row_name['id'].'"';
}
}
else
{
function username(){
return "*";
}
}

Any ideas?

Thanks & God Bless

[devinemke]

the quotes are screwing up your query.

$query_Props = "SELECT * FROM p_Sales WHERE datatable = 'c_4Sale' AND user = '$username' ORDER BY id ASC";

[RobRocker]

Ok thanks,

But now it doesnt output anything doesnt "*" mean all?

So I want it to output all the user id's in the table...

[devinemke]

RobRocker wrote:

...doesnt "*" mean all?

no. the standard SQL wildcard character is %

[RobRocker]

Ok, So I should put % instead of *?