Someone Has To Know

Anon

Hey I have been posting almost all day because I still cannot figure this thing out! I have a db named bpa, a table named main, and inside main there is a field called salary. I want from a form where the user clicks on the drop down menu that says Over 30,000 and Under 50,000 I want it to give them all the entrys. I cut out the ,000 for quicker searches. This is my code... Whats wrong with it? Also the error that it spit out.

Supplied argument is not a valid MySQL result resource

<?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 while line is erroring out. The connection is fine, the db name is fine, the table name is fine.. So hmm. Can anyone help???

Thanks!
Chad Smith

xmatthawkx

I'm by no means a php pro, but i've honestly never seen a : used in an if statement, and that code is missing quite a few important characters, here's a clean up:

if(isset($searchsalary)){ // make sure you close this if statement with }
$db = mysql_connect("localhost");
mysql_select_db("bpa", $db);
$sql = "SELECT * FROM main WHERE salary='$salarycut'"; //equal signs are always nice when trying to match something
$result = mysql_query($sql);
while ($row = mysql_fetch_array($result)) {

and a username and password would be nice if mysql is having trouble connecting, although it's not necessary all the time.

You should always verify every stage of your scripts, like this:

if(isset($searchsalary)){
$db = mysql_connect("localhost");
if (!db){die("noooo connection made.");}
mysql_select_db("bpa", $db);
$sql = "SELECT * FROM main WHERE salary='$salarycut'";
$result = mysql_query($sql);
if (!result){die("error fetching result");}
while ($row = mysql_fetch_array($result)) {

Anon

Nope not at all. Your script didnt work at all. I have a few other if(isset($__)): happening so its not bad. Its the last step in this 3 week project of mine. All I want is to get it done. I never had to make a page in PHP before and this is my first one. So I am just trying. I think someone should make a tutorial on it! 🙂 Help if you can!
Chad

HERE IS MY FULL SOURCE CODE-----

<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>Search Our Site</title>
</head>

<body topmargin="0" leftmargin="0">
<?php
if(isset($searchjobs)):
$db = mysql_connect("localhost");
mysql_select_db("bpa", $db);
$sql = "select from main where job_name='$job'";
$result = mysql_query($sql);
while ($row = mysql_fetch_array($result)) {
include ("underbody.inc");
include ("widthin.inc"); printf("<b>Job Name:</b> %s<hr></td>\n",$row["job_name"]);
include ("underjobname.inc");
include ("widthin.inc"); printf("<b>Education Needed:</b> %s<hr>\n",$row["education"]);
printf("<b>Salary With College:</b> %s,000<hr>\n",$row["salary"]);
printf("<b>Rank:</b> %s<hr>\n",$row["rank"]);
printf("<b>Abilities Needed:</b> %s<hr>\n",$row["ability"]);
printf("<b>Job Description:</b> %s<hr>\n",$row["job_desc"]);
printf("<b>Other Information:</b> %s<hr></td>\n",$row["other"]);
include ("fotter.inc");
print("<p>");
}
endif;
?>
<?php
if(isset($searcheducation)):
$db = mysql_connect("localhost");
mysql_select_db("bpa", $db);
$sql = "select from main where education='$education'";
$result = mysql_query($sql);
while ($row = mysql_fetch_array($result)) {
include ("underbody.inc");
include ("widthin.inc"); printf("<b>Job Name:</b> %s<hr></td>\n",$row["job_name"]);
include ("underjobname.inc");
include ("widthin.inc"); printf("<b>Education Needed:</b> %s<hr>\n",$row["education"]);
printf("<b>Salary With College:</b> %s,000<hr>\n",$row["salary"]);
printf("<b>Rank:</b> %s<hr>\n",$row["rank"]);
printf("<b>Abilities Needed:</b> %s<hr>\n",$row["ability"]);
printf("<b>Job Description:</b> %s<hr>\n",$row["job_desc"]);
printf("<b>Other Information:</b> %s<hr></td>\n",$row["other"]);
include ("fotter.inc");
print("<p>");
}
endif;
?>
<?php
if(isset($searchsalary)):
$db = mysql_connect("localhost");
mysql_select_db("bpa", $db);
$sql = "Select * from main where";
$result = mysql_query($sql);
while ($row = mysql_fetch_array($result)) {
include ("underbody.inc");
include ("widthin.inc"); printf("<b>Job Name:</b> %s<hr></td>\n",$row["job_name"]);
include ("underjobname.inc");
include ("widthin.inc"); printf("<b>Education Needed:</b> %s<hr>\n",$row["education"]);
printf("<b>Salary With College:</b> %s,000<hr>\n",$row["salary"]);
printf("<b>Rank:</b> %s<hr>\n",$row["rank"]);
printf("<b>Abilities Needed:</b> %s<hr>\n",$row["ability"]);
printf("<b>Job Description:</b> %s<hr>\n",$row["job_desc"]);
printf("<b>Other Information:</b> %s<hr></td>\n",$row["other"]);
include ("fotter.inc");
print("<p>");
}
endif;
?>

<p align="center"><img border="0" src="searchourdb.jpg" width="174" height="44"></p>
<p align="center">Technology careers change at a growth rate which is far<br>
beyond any other field of business. Accurate information unfortunately<br>
is not found in a book but is found on the internet. Our database has<br>
been set up to give you the Category, Job Name, Education Level Needed,<br>
Salary, Ability, And a brief job description Please keep in mind that<br>
this is simply an average, the salary levels and education levels may vary<br>
upon job level.</p>
<table border="0" width="100%" height="59" cellspacing="0" cellpadding="0">
<tr>
<td width="100%" height="17" background="TopNaviBackgroundBLUE.jpg" colspan="2"><b><font color="#FFFFFF">..::
Search ::..</font></b></td>
</tr>
<tr>
<td width="11%" height="108" rowspan="4"></td>
<td width="89%" height="1" bgcolor="#808080">
<form method="POST" action="search.php">
<p><font color="#FFFFFF">By Name:<select size="1" name="job">
<?php
$db = mysql_connect("localhost");
mysql_select_db("bpa", $db);
$sql = "select from main order by 'job_name'";
$result = mysql_query($sql);
while ($row = mysql_fetch_array($result)) {
include ("optiontag.inc"); printf("%s",$row["job_name"]); include ("afterinclude.inc");
printf("%s",$row["job_name"]);
print("</option>");
}
?>
</select></font><input type="submit" value="Submit" name="searchjobs"></p>
</form>
</td>
</tr>
<tr>
<td width="89%" height="1" bgcolor="#C0C0C0">
<form method="POST" action="search.php">
<p>Education Needed:<select size="1" name="education">
<option value="Out Of High School (NO COLLEGE)">Out Of High
School (NO COLLEGE)</option>
<option value="2 Years College">2 Years College</option>
<option value="4 Years College">4 Years College</option>
<option value="Masters">Masters</option>
<option value="Doctorate">Doctorate</option>
<option value="5 Years Working Experience">5 Years Working
Experience</option><input type="submit" value="Submit" name="searcheducation"></p>
</form>
</td>
</tr>
<tr>
<td width="89%" height="19" bgcolor="#808080">
<form method="POST" action="search.php">
<p><font color="#FFFFFF">Salary:</font><select size="1" name="salarycut">
<option value="<=30"><30,000</option>
<option value="select from main where salary between 31 and 50">31,000-50,000</option>
<option value="between 51 and 80">51,000-80,000</option>
<option value="between 81 and 100">81,000-100,000</option>
<option value=">=101">>101,000</option>
</select><input type="submit" value="Submit" name="searchsalary"></p>
</form>
</td>
</tr>
<tr>
<td width="89%" height="18" bgcolor="#C0C0C0">
</td>
</tr>
<tr>
<td width="100%" height="1" colspan="2" background="TopNaviBackgroundBLUE.jpg"> </td>
</tr>
</table>

</body>

---End of source code.----

Anon

You have MySQL trying to process the query "select * from main where salary 'between 30 and 50'". For one thing, the '=' sign is missing.

Don't you mean "select * from main where salary>=30 and salary<=50"?

Anon

do i put that in the Option Value statement?

Anon

Yes, or have an array

$range[0]['less']='0';
$range[0]['more']='20;
$range[1]['less']='20';
$range[1]['more']='30;
$range[2]['less']='30';
$range[2]['more']='50;
...

And then the <option> value attributes would be "0","1","2"...

The SQL would be
$lowerbound=$range[$salarycut]['less'];
$upperbound=$range[$salarycut]['more'];
"select * from main where salary>=$lowerbound and salary<=$upperbound";

You can also use the $range array to fill in the text for each option

ehco "<option value=\"0\">$range[0]['less'],000 - $range[0]['more'],000";
...

Anon

Hayley Watson I cannot thank you enough! Your truly awsome! It worked and its perfect. I cannot thank you enough. Although you did have a little parse error but nothing that this newbie couldnt fix.
$range[0]['less']='0';
$range[0]['more']='20';
$range[1]['less']='20';
$range[1]['more']='30';
$range[2]['less']='30';
$range[2]['more']='50';

On the more ranges you forgot a ' at the end of the number. But other than that your idea worked perfectly and I cannot thank you enough! I appriciate all your help and everyone that helped me out with this project!

Thanks!
Chad