Code: Select all
,Code: Select all
and [syntax="..."] tags where appropriate when posting code. Your post has been edited to reflect how we'd like it posted. Please read: [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url] to learn how to do it too.[/color]
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.phpCode: Select all
<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
Code: Select all
<?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);
}
?>the second question i have is my php doesnt seem to validate any idea's??
thanks for your help
Paul
feyd | Please use
Code: Select all
,Code: Select all
and [syntax="..."] tags where appropriate when posting code. Your post has been edited to reflect how we'd like it posted. Please read: [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url] to learn how to do it too.[/color]