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

How can i use [] tags instead of <> tags for profiles??
On my site im making ive made it so u can register, login and u have a profile which u can update..<

Allowing ' and "
Hello everyone,

I am creating a form where users submit information to go into a database. I

getting most records by count
Code: [Select]<?php

$connect = mysql_connect("localhost","dam

PHP Login
Hey!
I got this shopcart code online, am trying to modify it but am getting an error when i try a

Timer control causing error
I recently decided to add a timer control to an existing page that uses AJAX on my site. As soon as

Attempt to assign property of non-object in...
I'm having issues with the following function in PHP 5...

function getTreeWithChildre

PHP, jAVASCRIPT setting input values, why isn't it working?
Hi:

I am calling this javascript:
<script language="javascript">

square instead of number
Hello
I do not know why but this code seems to work fine only in my xampp local insallation but n

Date Format
Hi there,

I have a date format like this right now:
Sat, 17 Oct 2009 17:04:00

I ne

Track downloads' status
Hello,

I need to make somehow, some system, to track whether downloads are completed or faile