&& Function Help

[Anon]

Hello I need some major help with getting this to work. I will give you the scenario. I have a MySQL db. Database name is bpa the table is named main there is a field that is called salary. I want to choose the salary's that are over 30 and under 50. How would the select statement look for that? I have a tried a few but none work. Any help? The actual select statement would be ever so helpful. Thanks!
Chad R. Smith

[Anon]

select * from bpa where salary > 30 and salary < 50;

[jc94062]

"Database name is bpa"
"the table is named main"

so...

select * from main where salary > 30 and salary < 50

[Anon]

Thank you soo much! And you both are right Paul and James. I am soo happy now! THANK YOU AGAIN!
Chad Smith

[amcgrath]

select * from bpa where salary between 30 and 50 looks prettier 😉

[Anon]

HAHAHA thanks Allen.. And yes it does look prettier. But check my other post. I cannot get it to work. If you could figure it out I would appricate it. Thanks!
Chad

[amcgrath]

I already did, check the other post.

[Anon]

Its still not working. I used this select statement:
$sql = "select * from main where salary '$salarycut'";

and $salarycut=between 31 and 50 that is out of a form.

Its spits out this error : Warning: Supplied argument is not a valid MySQL result resource in C:\apache\htdocs\search.php on line 55

This error is this line : LINE 54:$result = mysql_query($sql);
LINE 55: while ($row = mysql_fetch_array($result)) {

So hmm. Anyone got any help on this?

Chad

[amcgrath]

Post the code where you generate the sql, it is obviously either not formatted correctly or you are not even connecting to the database.