NAME THIS ERROR

Anon

What does this error mean?
Supplied argument is not a valid MySQL result resource

WHAT THE DOES THAT MEAN!?!?!

<?php
if(isset($searchsalary)):
$db = mysql_connect("localhost");
mysql_select_db("bpa", $db);
$sql = "SELECT * FROM main WHERE salary '$salarycut'";
$result = mysql_query($sql);
while ($row = mysql_fetch_array($result)) {

$salarycut=between 30 and 50

That is my code and the last line is erroring out. The connection is fine, the db name is fine, the table name is fine.. So hmm. Can anyone help???

Anon

username for db connect?

Anon

No there is not username or password. So that line is ok. So hmm...

Anon

SELECT * FROM main WHERE salary '$salarycut'

That is not valid SQL, so the query fails and you don't get a result identifier.

You probably want to do something like "where salary < '$salarycut'", or "=", or ">", or whatever. 🙂

Hendrik

Anon

Yea i tried that hendrik and it worked but i need it to be from a form. They choose which salary cap they want and it displays. So how do i make this form friendly?

Anon

? 🙂

I don't know whether I fully understand your question, sorry.

Hendrik

Anon

I have a db named bpa and in the db there is a table named main. In main there is a field named salary. Which has salary numbers without the ,000. I want to have a form that people can put in what salary range they want to look up like i have 30,000-50,000 and when they click on it, it will pull up every career that has a salary range of 30-50. But its just not working. It is a pull down form button. If you need the full source code let me know. If that will help. Thank you for your time.
Chad

Anon

SELECT * FROM main WHERE salary > $minSal AND salary < $maxSal

That should select everything with a salary in the range of $minSal and $maxSal

Anon

Yea but the user needs to define how high and low they want it to be. Like if you want to find all the ones over 30 and under 50. But the next person wants to find everything from 51 to 80 and the next from 81 to 100 and then the last one wants to search from over 100. You know what I am saying? Is there a way to code it?
Chad
Variable name is salarycut and the table name is main, and the field is salary. Just read the previous posts to figure out what I am trying to do. Thanks!