[RESOLVED] Help with retrieving database info with form

thejrod03

I am trying to use a form to retrieve data from database based on the values that are selected from the fields. I dont think I have problems with the form itself, but the php is giving me a hard time.

heres the form url: http://www.onedispatch.com/test/loadsearch.html

heres the php code:

<?php


$conn = mysql_connect("mysql18.ixwebhosting.com","username","password");
mysql_select_db("jarodd_currentloads",$conn);
$query="SELECT * FROM loads_now WHERE origin_state='$_POST[origin_state]',origin_area='$_POST[origin_area]',dest_state='$_POST[dest_state],dest_area='$_POST[dest_area]'";
$result=mysql_query($query);

$num=mysql_numrows($result);

mysql_close();

$i=0;
while ($i<$num){

$originstate=mysql_result($result,$i,"OriginState");
$originarea=mysql_result($result,$i,"OriginArea");
$deststate=mysql_result($result,$i,"DestState");
$destarea=mysql_result($result,$i,'DestArea");

echo "<b>$originstate</b><b>$originarea</b><b>$deststate</b><b>$destarea<b>";

$i++;

}

?>
[code=php]

Installer

Try separating the WHERE terms with AND instead of commas.

thejrod03

I put the AND instead of commas but I still do not get a response printed on screen, would it matter if there are more fields in the database than the ones listed in my code?

Installer

I've noticed now that the column names you use in the mysql_result() lines don't match the ones in the query. They should be like

mysql_result($result,$i,"origin_state")

Edit: You're also missing a quotation mark after $_POST[dest_state].

thejrod03

Thank you so much, didnt see the edit that you posted and almost through my computer out the window. That made the code work, thanks again!

Installer

Glad to help.

You should also look at mysql_real_escape_string().

thejrod03

On this output, I also need to include fields that are not included in the search. For example the origin_state, origin_area, dest_state, dest_area are in the table along with phone numbers and descriptions, how would I go about including those into the search? What I mean is when I search for specific states how also do I display the phone number and description that is also in the row of that record? Sorry if thats confusing...