Jump to content

Archived

This topic is now archived and is closed to further replies.

peoplespaul

SQL results in table help me please:)

Recommended Posts

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)

Share this post


Link to post
Share on other sites

×

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.