Entering Data Problem

Posted on 16th Feb 2014 07:03 pm by admin

Code: $result = mysql_query("SELECT * FROM flights");
while ($row = mysql_fetch_array($result))
{

if ($flight_num == $row['flight_num']){
echo "<center>Flight Number Used!</center>";
}else{

$sql=mysql_query("INSERT INTO flights (`flight_num`, `dep_icao`, `dep_time`, `dep_name`, `arr_icao`, `arr_time`, `arr_name`, `route`, `aircraft`, `days`, `duration`, `status`)
VALUES ('$flight_num','$dep','$dep_time','$dep_name','$arr','$arr_time','$arr_name','$route','$aircraft','$days','$duration','$status')");
header ('Location: ?page=flt_ctr');

}}

Your Answer:

Login to answer

Other forums

problem with array - multilingual page
this is my test page :
Code: <?php
if(isset($_GET['lang'])) {
if($_GET['la

NOOB needs help with upload file
The intent of this form is to create a folder for a client and upload an image into another folder '

Time script, set to my time zone?
I am using this line to get the date and time

Code: $time = date(F." ".d.", &q

DataTable Help Required
Hi all I am creating an app that utilises and MS Access back end and queries it quite a bit at vario

Displaying image pathname instead of image
Hello

Im trying to upload and then display images from a mysql database - Its only basic and

Javascript or not?
How many people prefer javascript/ajax sites? How many prefer the good old fashion straight php sit

How to give the privillege for triggers?
Hi,

How to give the privillage for triggers to particular user?

Please let me

User registration and login
I don't know whether this is the correct forum, if not i apologise but am pretty desperate at the mo

DELETE FROM not working deletes wrong row
Hello

I have the following code which i found but it doesnt work properly.. it comes up with

Please help understand this code
I noticed the index page on my site was modified this morning and found this code inserted at the bo