Jump to content

peoplespaul

New Members
  • Posts

    1
  • Joined

  • Last visited

    Never

Profile Information

  • Gender
    Not Telling

peoplespaul's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. hey, The first question is that i have is how to make one large form which retrieves data from a database and outputs it into a table. the current code i have is outputting it to a table but not correctly:? eg if there are four results to the query only 3 will be outputted :S and the 1st line in therewill be each row's title's, it is most likey something simple. would be grateful for the help. below is the code for the form in search.php <FORM METHOD= "post" ACTION= "dest_loc.php"> <H4> Departure location <!-- text box with attributes set --> <INPUT NAME ="dep_loc" TYPE="text" SIZE=40 MAXLENGTH=40> </H4> <H4> Destination location <INPUT NAME ="arr_loc" TYPE="text" SIZE=20 MAXLENGTH=40> <input type="submit" value="Search"></H4> </FORM> here is the php in dept_loc that i have done <?php $server=mysql_connect("clun.scit.wlv.ac.uk","demo",""); if (!$server): print ("error connecting to server"); exit; endif; mysql_select_db("cp1082",$server); $dep_loc = $HTTP_POST_VARS['dep_loc']; $arr_loc = $HTTP_POST_VARS['arr_loc']; $sql="SELECT * FROM `airline`"; if($dep_loc!="") $sql = $sql." WHERE ffrom = '$dep_loc'"; if($arr_loc!="") $sql = $sql." AND fto = '$arr_loc'"; echo $sql."<br><br>"; $result=mysql_query($sql); if (mysql_error()): print ("there has been an error<BR>".mysql_error()); exit; endif; print "There have been ".mysql_num_rows($result)." records returned<BR>"; while ($row=mysql_fetch_array($result)) { echo '<table border="1"> <TR><TD>ffrom</TD> <TD>fto</TD> <TD>flight_no</TD> <TD>departure</TD> <TD>arrival</TD></TR>'; while (list ($ffrom, $fto, $flight_no, $departure, $arrival) = mysql_fetch_row($result)) { echo "<TR><TD>$ffrom</TD> <TD>$fto</TD> <TD>$flight_no</TD> <TD>$departure</TD> <TD>$arrival</TD</TR>"; } echo '</table>'; mysql_close($server); } ?> i would be grateful as telling me why its not working correctly to save me makin the same mistake in the future the second question i have is my php doesnt seem to validate any idea's?? thanks for your help Paul (peoplespaul@hotmail.com)
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.