0

hi ,,,

i have create php page code for show booking online

and for free seat is come green color if paid red color and... blah blah

is working fine but can you fix it to be better and fast browseing page

this PHP file and MySql

ticket.php

tickets.txt

waiting Answer thanks

Attachments
<?php
include("mysql.php");
if (!$do) {
///echo "<meta http-equiv=\"refresh\" content=\"10;URL=ticket.php\">";

echo "<center>

<table border='0' width='500' dir='rtl' cellpadding='0' style='border-collapse: collapse' height='29'>
	<tr>
		<td align='center' width='139' bgcolor='#00FF00'><b>
		<font face='Tahoma' size='2'>
		 </font></b></td>
		<td align='center' width='141' bgcolor='#FF0000'><b>
		<font face='Tahoma' size='2'>
		</font></b></td>
		<td align='center' bgcolor='#990000' width='115'><b>
		<font face='Tahoma' color='#FFFFFF' size='2'> </font></b></td>
		<td align='center' bgcolor='#0000FF'><b><font face='Tahoma' size='2'>
		<font color='#FFFFFF'><span lang='en-us'> </span></font> </font>
		</b></td>
	</tr>
</table><hr size='2'><img border='0' src='images/show.png' width='712' height='171'>";
echo "
<form name='form' method='POST' action='' >";
$result = mysql_query("SELECT * FROM tickets");
$count=mysql_num_rows($result);

while($row = mysql_fetch_array($result))
  {
  
  $id[] = $row['id']; /// this id for multi update or delete
  $seat_number = $row['seat_number'];
  $status = $row['status'];
  $checkid = $row['id']; 
/////// line a free ////////
if ($seat_number == "A-1" && $status == "free")  {  $seatnumbera1 = "bgcolor='#00FF00'";  }  
if ($seat_number == "A-2" && $status == "free")  {  $seatnumbera2 = "bgcolor='#00FF00'";  }  
if ($seat_number == "A-3" && $status == "free")  {  $seatnumbera3 = "bgcolor='#00FF00'"; }  
if ($seat_number == "A-4" && $status == "free")  {  $seatnumbera4 = "bgcolor='#00FF00'";  }  
if ($seat_number == "A-5" && $status == "free")  {  $seatnumbera5 = "bgcolor='#00FF00'";  }  
if ($seat_number == "A-6" && $status == "free")  {  $seatnumbera6 = "bgcolor='#00FF00'";  }  
if ($seat_number == "A-7" && $status == "free")  {  $seatnumbera7 = "bgcolor='#00FF00'";  }  
if ($seat_number == "A-8" && $status == "free")  {  $seatnumbera8 = "bgcolor='#00FF00'";  }  
if ($seat_number == "A-9" && $status == "free")  {  $seatnumbera9 = "bgcolor='#00FF00'"; }  
if ($seat_number == "A-10" && $status == "free")  {  $seatnumbera10 = "bgcolor='#00FF00'"; }  
if ($seat_number == "A-11" && $status == "free")  {  $seatnumbera11 = "bgcolor='#00FF00'"; }  
if ($seat_number == "A-12" && $status == "free")  {  $seatnumbera12 = "bgcolor='#00FF00'";  }  
if ($seat_number == "A-13" && $status == "free")  {  $seatnumbera13 = "bgcolor='#00FF00'";  }  
if ($seat_number == "A-14" && $status == "free")  {  $seatnumbera14 = "bgcolor='#00FF00'";  }  
if ($seat_number == "A-15" && $status == "free")  {  $seatnumbera15 = "bgcolor='#00FF00'";  }  
if ($seat_number == "A-16" && $status == "free")  {  $seatnumbera16 = "bgcolor='#00FF00'";  }  
if ($seat_number == "A-17" && $status == "free")  {  $seatnumbera17 = "bgcolor='#00FF00'";  }  
if ($seat_number == "A-18" && $status == "free")  {  $seatnumbera18 = "bgcolor='#00FF00'";  }  
if ($seat_number == "A-19" && $status == "free")  {  $seatnumbera19 = "bgcolor='#00FF00'";  }  
if ($seat_number == "A-20" && $status == "free")  {  $seatnumbera20 = "bgcolor='#00FF00'";  }  
if ($seat_number == "A-21" && $status == "free")  {  $seatnumbera21 = "bgcolor='#00FF00'";  }  
if ($seat_number == "A-22" && $status == "free")  {  $seatnumbera22 = "bgcolor='#00FF00'";  }  
if ($seat_number == "A-23" && $status == "free")  {  $seatnumbera23 = "bgcolor='#00FF00'";  }  
if ($seat_number == "A-24" && $status == "free")  {  $seatnumbera24 = "bgcolor='#00FF00'";  }  
if ($seat_number == "A-25" && $status == "free")  {  $seatnumbera25 = "bgcolor='#00FF00'";  }  
if ($seat_number == "A-26" && $status == "free")  {  $seatnumbera26 = "bgcolor='#00FF00'";  }  
if ($seat_number == "A-27" && $status == "free")  {  $seatnumbera27 = "bgcolor='#00FF00'";  }  
if ($seat_number == "A-28" && $status == "free")  {  $seatnumbera28 = "bgcolor='#00FF00'";  }  
if ($seat_number == "A-29" && $status == "free")  {  $seatnumbera29 = "bgcolor='#00FF00'";  }  
if ($seat_number == "A-30" && $status == "free")  {  $seatnumbera30 = "bgcolor='#00FF00'";  }  
if ($seat_number == "A-31" && $status == "free")  {  $seatnumbera31 = "bgcolor='#00FF00'";  }  
if ($seat_number == "A-32" && $status == "free")  {  $seatnumbera32 = "bgcolor='#00FF00'";  }  
if ($seat_number == "A-33" && $status == "free")  {  $seatnumbera33 = "bgcolor='#00FF00'";  }  
if ($seat_number == "A-34" && $status == "free")  {  $seatnumbera34 = "bgcolor='#00FF00'";  }  
if ($seat_number == "A-35" && $status == "free")  {  $seatnumbera35 = "bgcolor='#00FF00'"; }  
if ($seat_number == "A-36" && $status == "free")  {  $seatnumbera36 = "bgcolor='#00FF00'";  }  
if ($seat_number == "A-37" && $status == "free")  {  $seatnumbera37 = "bgcolor='#00FF00'";  }  
if ($seat_number == "A-38" && $status == "free")  {  $seatnumbera38 = "bgcolor='#00FF00'";  }  
if ($seat_number == "A-39" && $status == "free")  {  $seatnumbera39 = "bgcolor='#00FF00'"; }  
if ($seat_number == "A-40" && $status == "free")  {  $seatnumbera40 = "bgcolor='#00FF00'";  }  
/////// line a paid ////////
if ($seat_number == "A-1" && $status == "paid")  {  $seatnumbera1 = "bgcolor='#ff0000'";  }  
if ($seat_number == "A-2" && $status == "paid")  {  $seatnumbera2 = "bgcolor='#ff0000'";  }  
if ($seat_number == "A-3" && $status == "paid")  {  $seatnumbera3 = "bgcolor='#ff0000'";  }  
if ($seat_number == "A-4" && $status == "paid")  {  $seatnumbera4 = "bgcolor='#ff0000'";  }  
if ($seat_number == "A-5" && $status == "paid")  {  $seatnumbera5 = "bgcolor='#ff0000'";  }  
if ($seat_number == "A-6" && $status == "paid")  {  $seatnumbera6 = "bgcolor='#ff0000'";  }  
if ($seat_number == "A-7" && $status == "paid")  {  $seatnumbera7 = "bgcolor='#ff0000'"; }  
if ($seat_number == "A-8" && $status == "paid")  {  $seatnumbera8 = "bgcolor='#ff0000'";  }  
if ($seat_number == "A-9" && $status == "paid")  {  $seatnumbera9 = "bgcolor='#ff0000'";  }  
if ($seat_number == "A-10" && $status == "paid")  {  $seatnumbera10 = "bgcolor='#ff0000'";  }  
if ($seat_number == "A-11" && $status == "paid")  {  $seatnumbera11 = "bgcolor='#ff0000'";  }  
if ($seat_number == "A-12" && $status == "paid")  {  $seatnumbera12 = "bgcolor='#ff0000'"; }  
if ($seat_number == "A-13" && $status == "paid")  {  $seatnumbera13 = "bgcolor='#ff0000'";  }  
if ($seat_number == "A-14" && $status == "paid")  {  $seatnumbera14 = "bgcolor='#ff0000'";  }  
if ($seat_number == "A-15" && $status == "paid")  {  $seatnumbera15 = "bgcolor='#ff0000'";  }  
if ($seat_number == "A-16" && $status == "paid")  {  $seatnumbera16 = "bgcolor='#ff0000'";  }  
if ($seat_number == "A-17" && $status == "paid")  {  $seatnumbera17 = "bgcolor='#ff0000'";  }  
if ($seat_number == "A-18" && $status == "paid")  {  $seatnumbera18 = "bgcolor='#ff0000'";  }  
if ($seat_number == "A-19" && $status == "paid")  {  $seatnumbera19 = "bgcolor='#ff0000'";  }  
if ($seat_number == "A-20" && $status == "paid")  {  $seatnumbera20 = "bgcolor='#ff0000'";  }  
if ($seat_number == "A-21" && $status == "paid")  {  $seatnumbera21 = "bgcolor='#ff0000'";  }  
if ($seat_number == "A-22" && $status == "paid")  {  $seatnumbera22 = "bgcolor='#ff0000'";  }  
if ($seat_number == "A-23" && $status == "paid")  {  $seatnumbera23 = "bgcolor='#ff0000'";  }  
if ($seat_number == "A-24" && $status == "paid")  {  $seatnumbera24 = "bgcolor='#ff0000'";  }  
if ($seat_number == "A-25" && $status == "paid")  {  $seatnumbera25 = "bgcolor='#ff0000'"; }  
if ($seat_number == "A-26" && $status == "paid")  {  $seatnumbera26 = "bgcolor='#ff0000'";  }  
if ($seat_number == "A-27" && $status == "paid")  {  $seatnumbera27 = "bgcolor='#ff0000'";  }  
if ($seat_number == "A-28" && $status == "paid")  {  $seatnumbera28 = "bgcolor='#ff0000'";  }  
if ($seat_number == "A-29" && $status == "paid")  {  $seatnumbera29 = "bgcolor='#ff0000'"; }  
if ($seat_number == "A-30" && $status == "paid")  {  $seatnumbera30 = "bgcolor='#ff0000'";  }  
if ($seat_number == "A-31" && $status == "paid")  {  $seatnumbera31 = "bgcolor='#ff0000'";  }  
if ($seat_number == "A-32" && $status == "paid")  {  $seatnumbera32 = "bgcolor='#ff0000'";  }  
if ($seat_number == "A-33" && $status == "paid")  {  $seatnumbera33 = "bgcolor='#ff0000'";  }  
if ($seat_number == "A-34" && $status == "paid")  {  $seatnumbera34 = "bgcolor='#ff0000'";  }  
if ($seat_number == "A-35" && $status == "paid")  {  $seatnumbera35 = "bgcolor='#ff0000'";  }  
if ($seat_number == "A-36" && $status == "paid")  {  $seatnumbera36 = "bgcolor='#ff0000'";  }  
if ($seat_number == "A-37" && $status == "paid")  {  $seatnumbera37 = "bgcolor='#ff0000'";  }  
if ($seat_number == "A-38" && $status == "paid")  {  $seatnumbera38 = "bgcolor='#ff0000'";  }  
if ($seat_number == "A-39" && $status == "paid")  {  $seatnumbera39 = "bgcolor='#ff0000'";  }  
if ($seat_number == "A-40" && $status == "paid")  {  $seatnumbera40 = "bgcolor='#ff0000'";  }  
/////// line a block ////////
if ($seat_number == "A-1" && $status == "block")  {  $seatnumbera1 = "bgcolor='#990000'";  }  
if ($seat_number == "A-2" && $status == "block")  {  $seatnumbera2 = "bgcolor='#990000'";  }  
if ($seat_number == "A-3" && $status == "block")  {  $seatnumbera3 = "bgcolor='#990000'"; }
if ($seat_number == "A-4" && $status == "block")  {  $seatnumbera4 = "bgcolor='#990000'"; }
if ($seat_number == "A-5" && $status == "block")  {  $seatnumbera5 = "bgcolor='#990000'";  }
if ($seat_number == "A-6" && $status == "block")  {  $seatnumbera6 = "bgcolor='#990000'";  }
if ($seat_number == "A-7" && $status == "block")  {  $seatnumbera7 = "bgcolor='#990000'"; }
if ($seat_number == "A-8" && $status == "block")  {  $seatnumbera8 = "bgcolor='#990000'";  }
if ($seat_number == "A-9" && $status == "block")  {  $seatnumbera9 = "bgcolor='#990000'"; }
if ($seat_number == "A-10" && $status == "block")  {  $seatnumbera10 = "bgcolor='#990000'";  }
if ($seat_number == "A-11" && $status == "block")  {  $seatnumbera11 = "bgcolor='#990000'"; }
if ($seat_number == "A-12" && $status == "block")  {  $seatnumbera12 = "bgcolor='#990000'"; }
if ($seat_number == "A-13" && $status == "block")  {  $seatnumbera13 = "bgcolor='#990000'"
-- phpMyAdmin SQL Dump
-- version 2.10.3
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generation Time: Oct 05, 2010 at 03:24 AM
-- Server version: 5.0.51
-- PHP Version: 5.2.6

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

-- 
-- Database: `ticket`
-- 

-- --------------------------------------------------------

-- 
-- Table structure for table `tickets`
-- 

CREATE TABLE `tickets` (
  `id` int(255) NOT NULL auto_increment,
  `seat_number` varchar(255) NOT NULL,
  `status` varchar(255) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=29585 ;

-- 
-- Dumping data for table `tickets`
-- 

INSERT INTO `tickets` VALUES (1, 'A-1', 'free');
INSERT INTO `tickets` VALUES (2, 'A-2', 'free');
INSERT INTO `tickets` VALUES (3, 'A-3', 'free');
INSERT INTO `tickets` VALUES (4, 'A-4', 'free');
INSERT INTO `tickets` VALUES (5, 'A-5', 'free');
INSERT INTO `tickets` VALUES (6, 'A-6', 'free');
INSERT INTO `tickets` VALUES (7, 'A-7', 'free');
INSERT INTO `tickets` VALUES (8, 'A-8', 'free');
INSERT INTO `tickets` VALUES (9, 'A-9', 'free');
INSERT INTO `tickets` VALUES (10, 'A-10', 'free');
INSERT INTO `tickets` VALUES (17, 'A-11', 'free');
INSERT INTO `tickets` VALUES (18, 'A-12', 'free');
INSERT INTO `tickets` VALUES (19, 'A-13', 'free');
INSERT INTO `tickets` VALUES (20, 'A-14', 'free');
INSERT INTO `tickets` VALUES (21, 'A-15', 'free');
INSERT INTO `tickets` VALUES (22, 'A-16', 'free');
INSERT INTO `tickets` VALUES (23, 'A-17', 'free');
INSERT INTO `tickets` VALUES (24, 'A-18', 'free');
INSERT INTO `tickets` VALUES (25, 'A-19', 'free');
INSERT INTO `tickets` VALUES (26, 'A-20', 'free');
INSERT INTO `tickets` VALUES (27, 'A-21', 'free');
INSERT INTO `tickets` VALUES (28, 'A-22', 'free');
INSERT INTO `tickets` VALUES (29, 'A-23', 'free');
INSERT INTO `tickets` VALUES (30, 'A-24', 'free');
INSERT INTO `tickets` VALUES (31, 'A-25', 'free');
INSERT INTO `tickets` VALUES (32, 'A-26', 'free');
INSERT INTO `tickets` VALUES (33, 'A-27', 'free');
INSERT INTO `tickets` VALUES (34, 'A-28', 'free');
INSERT INTO `tickets` VALUES (35, 'A-29', 'free');
INSERT INTO `tickets` VALUES (36, 'A-30', 'free');
INSERT INTO `tickets` VALUES (65, 'A-31', 'free');
INSERT INTO `tickets` VALUES (66, 'A-32', 'free');
INSERT INTO `tickets` VALUES (67, 'A-33', 'free');
INSERT INTO `tickets` VALUES (68, 'A-34', 'free');
INSERT INTO `tickets` VALUES (69, 'A-35', 'free');
INSERT INTO `tickets` VALUES (70, 'A-36', 'free');
INSERT INTO `tickets` VALUES (71, 'A-37', 'free');
INSERT INTO `tickets` VALUES (72, 'A-38', 'free');
INSERT INTO `tickets` VALUES (73, 'A-39', 'free');
INSERT INTO `tickets` VALUES (74, 'A-40', 'free');
INSERT INTO `tickets` VALUES (75, 'B-1', 'free');
INSERT INTO `tickets` VALUES (76, 'B-2', 'free');
INSERT INTO `tickets` VALUES (77, 'B-3', 'free');
INSERT INTO `tickets` VALUES (78, 'B-4', 'free');
INSERT INTO `tickets` VALUES (79, 'B-5', 'free');
INSERT INTO `tickets` VALUES (80, 'B-6', 'free');
INSERT INTO `tickets` VALUES (81, 'B-7', 'free');
INSERT INTO `tickets` VALUES (82, 'B-8', 'free');
INSERT INTO `tickets` VALUES (83, 'B-9', 'free');
INSERT INTO `tickets` VALUES (84, 'B-10', 'free');
INSERT INTO `tickets` VALUES (129, 'B-11', 'free');
INSERT INTO `tickets` VALUES (130, 'B-12', 'free');
INSERT INTO `tickets` VALUES (131, 'B-13', 'free');
INSERT INTO `tickets` VALUES (132, 'B-14', 'free');
INSERT INTO `tickets` VALUES (133, 'B-15', 'free');
INSERT INTO `tickets` VALUES (134, 'B-16', 'free');
INSERT INTO `tickets` VALUES (135, 'B-17', 'free');
INSERT INTO `tickets` VALUES (136, 'B-18', 'free');
INSERT INTO `tickets` VALUES (137, 'B-19', 'free');
INSERT INTO `tickets` VALUES (138, 'B-20', 'free');
INSERT INTO `tickets` VALUES (139, 'B-21', 'free');
INSERT INTO `tickets` VALUES (140, 'B-22', 'free');
INSERT INTO `tickets` VALUES (141, 'B-23', 'free');
INSERT INTO `tickets` VALUES (142, 'B-24', 'free');
INSERT INTO `tickets` VALUES (143, 'B-25', 'free');
INSERT INTO `tickets` VALUES (144, 'B-26', 'free');
INSERT INTO `tickets` VALUES (145, 'B-27', 'free');
INSERT INTO `tickets` VALUES (146, 'B-28', 'free');
INSERT INTO `tickets` VALUES (147, 'B-29', 'free');
INSERT INTO `tickets` VALUES (148, 'B-30', 'free');
INSERT INTO `tickets` VALUES (149, 'B-31', 'free');
INSERT INTO `tickets` VALUES (150, 'B-32', 'free');
INSERT INTO `tickets` VALUES (151, 'B-33', 'free');
INSERT INTO `tickets` VALUES (152, 'B-34', 'free');
INSERT INTO `tickets` VALUES (153, 'B-35', 'free');
INSERT INTO `tickets` VALUES (154, 'B-36', 'free');
INSERT INTO `tickets` VALUES (155, 'B-37', 'free');
INSERT INTO `tickets` VALUES (156, 'B-38', 'free');
INSERT INTO `tickets` VALUES (157, 'B-39', 'free');
INSERT INTO `tickets` VALUES (158, 'B-40', 'free');
INSERT INTO `tickets` VALUES (257, 'C-1', 'free');
INSERT INTO `tickets` VALUES (258, 'C-2', 'free');
INSERT INTO `tickets` VALUES (259, 'C-3', 'free');
INSERT INTO `tickets` VALUES (260, 'C-4', 'free');
INSERT INTO `tickets` VALUES (261, 'C-5', 'free');
INSERT INTO `tickets` VALUES (262, 'C-6', 'free');
INSERT INTO `tickets` VALUES (263, 'C-7', 'free');
INSERT INTO `tickets` VALUES (264, 'C-8', 'free');
INSERT INTO `tickets` VALUES (265, 'C-9', 'free');
INSERT INTO `tickets` VALUES (266, 'C-10', 'free');
INSERT INTO `tickets` VALUES (267, 'C-11', 'free');
INSERT INTO `tickets` VALUES (268, 'C-12', 'free');
INSERT INTO `tickets` VALUES (269, 'C-13', 'free');
INSERT INTO `tickets` VALUES (270, 'C-14', 'free');
INSERT INTO `tickets` VALUES (271, 'C-15', 'free');
INSERT INTO `tickets` VALUES (272, 'C-16', 'free');
INSERT INTO `tickets` VALUES (273, 'C-17', 'free');
INSERT INTO `tickets` VALUES (274, 'C-18', 'free');
INSERT INTO `tickets` VALUES (275, 'C-19', 'free');
INSERT INTO `tickets` VALUES (276, 'C-20', 'free');
INSERT INTO `tickets` VALUES (277, 'C-21', 'free');
INSERT INTO `tickets` VALUES (278, 'C-22', 'free');
INSERT INTO `tickets` VALUES (279, 'C-23', 'free');
INSERT INTO `tickets` VALUES (280, 'C-24', 'free');
INSERT INTO `tickets` VALUES (281, 'C-25', 'free');
INSERT INTO `tickets` VALUES (282, 'C-26', 'free');
INSERT INTO `tickets` VALUES (283, 'C-27', 'free');
INSERT INTO `tickets` VALUES (284, 'C-28', 'free');
INSERT INTO `tickets` VALUES (285, 'C-29', 'free');
INSERT INTO `tickets` VALUES (286, 'C-30', 'free');
INSERT INTO `tickets` VALUES (287, 'C-31', 'free');
INSERT INTO `tickets` VALUES (288, 'C-32', 'free');
INSERT INTO `tickets` VALUES (289, 'C-33', 'free');
INSERT INTO `tickets` VALUES (290, 'C-34', 'free');
INSERT INTO `tickets` VALUES (291, 'C-35', 'free');
INSERT INTO `tickets` VALUES (292, 'C-36', 'free');
INSERT INTO `tickets` VALUES (293, 'C-37', 'free');
INSERT INTO `tickets` VALUES (294, 'C-38', 'free');
INSERT INTO `tickets` VALUES (295, 'C-39', 'free');
INSERT INTO `tickets` VALUES (296, 'C-40', 'free');
INSERT INTO `tickets` VALUES (297, 'D-1', 'free');
INSERT INTO `tickets` VALUES (298, 'D-2', 'free');
INSERT INTO `tickets` VALUES (299, 'D-3', 'free');
INSERT INTO `tickets` VALUES (300, 'D-4', 'free');
INSERT INTO `tickets` VALUES (301, 'D-5', 'free');
INSERT INTO `tickets` VALUES (302, 'D-6', 'free');
INSERT INTO `tickets` VALUES (303, 'D-7', 'free');
INSERT INTO `tickets` VALUES (304, 'D-8', 'free');
INSERT INTO `tickets` VALUES (305, 'D-9', 'free');
INSERT INTO `tickets` VALUES (306, 'D-10', 'free');
INSERT INTO `tickets` VALUES (307, 'D-11', 'free');
INSERT INTO `tickets` VALUES (308, 'D-12', 'free');
INSERT INTO `tickets` VALUES (309, 'D-13', 'free');
INSERT INTO `tickets` VALUES (310, 'D-14', 'free');
INSERT INTO `tickets` VALUES (311, 'D-15', 'free');
INSERT INTO `tickets` VALUES (312, 'D-16', 'free');
INSERT INTO `tickets` VALUES (313, 'D-17', 'free');
INSERT INTO `tickets` VALUES (314, 'D-18', 'free');
INSERT INTO `tickets` VALUES (315, 'D-19', 'free');
INSERT INTO `tickets` VALUES (316, 'D-20', 'free');
INSERT INTO `tickets` VALUES (317, 'D-21', 'free');
INSERT INTO `tickets` VALUES (318, 'D-22', 'free');
INSERT INTO `tickets` VALUES (319, 'D-23', 'free');
INSERT INTO `tickets` VALUES (320, 'D-24', 'free');
INSERT INTO `tickets` VALUES (321, 'D-25', 'free');
INSERT INTO `tickets` VALUES (322, 'D-26', 'free');
INSERT INTO `tickets` VALUES (323, 'D-27', 'free');
INSERT INTO `tickets` VALUES (324, 'D-28', 'free');
INSERT INTO `tickets` VALUES (325, 'D-29', 'free');
INSERT INTO `tickets` VALUES (326, 'D-30', 'free');
INSERT INTO `tickets` VALUES (327, 'D-31', 'free');
INSERT INTO `tickets` VALUES (328, 'D-32', 'free');
INSERT INTO `tickets` VALUES (329, 'D-33', 'free');
INSERT INTO `tickets` VALUES (330, 'D-34', 'free');
INSERT INTO `tickets` VALUES (331, 'D-35', 'free');
INSERT INTO `tickets` VALUES (332, 'D-36', 'free');
INSERT INTO `tickets` VALUES (333, 'D-37', 'free');
INSERT INTO `tickets` VALUES (334, 'D-38', 'free');
INSERT INTO `tickets` VALUES (335, 'D-39', 'free');
INSERT INTO `tickets` VALUES (336, 'D-40', 'free');
INSERT INTO `tickets` VALUES (337, 'E-1', 'free');
INSERT INTO `tickets` VALUES (338, 'E-2', 'free');
INSERT INTO `tickets` VALUES (339, 'E-3', 'free');
INSERT INTO `tickets` VALUES (340, 'E-4', 'free');
INSERT INTO `tickets` VALUES (341, 'E-5', 'free');
INSERT INTO `tickets` VALUES (342, 'E-6', 'free');
INSERT INTO `tickets` VALUES (343, 'E-7', 'free');
INSERT INTO `tickets` VALUES (344, 'E-8', 'free');
INSERT INTO `tickets` VALUES (345, 'E-9', 'free');
INSERT INTO `tickets` VALUES (346, 'E-10', 'free');
INSERT INTO `tickets` VALUES (347, 'E-11', 'free');
INSERT INTO `tickets` VALUES (348, 'E-12', 'free');
INSERT INTO `tickets` VALUES (349, 'E-13', 'free');
INSERT INTO `tickets` VALUES (350, 'E-14', 'free');
INSERT INTO `tickets` VALUES (351, 'E-15', 'free');
INSERT INTO `tickets` VALUES (352, 'E-16', 'free');
INSERT INTO `tickets` VALUES (353, 'E-17', 'free');
INSERT INTO `tickets` VALUES (354, 'E-18', 'free');
INSERT INTO `tickets` VALUES (355, 'E-19', 'free');
INSERT INTO `tickets` VALUES (356, 'E-20', 'free');
INSERT INTO `tickets` VALUES (357, 'E-21', 'free');
INSERT INTO `tickets` VALUES (358, 'E-22', 'free');
INSERT INTO `tickets` VALUES (35
3
Contributors
13
Replies
14
Views
7 Years
Discussion Span
Last Post by WaleedaaN
0

As far as i understand, your code is slow because the php server is taking much more time to process.
So I think your color is according to the status so why you write those code for every ticket, rather then you can write only 3 if conditions for 'block,free, and paid' only once.

And try to put those ticket listing in a loop.
Hope this might work.

0

thanks for replay,,,


did you have any idea or code to give me


thanks

0

You are doing a lot of hand coding there. hoooop

I dont remember the last time i did this. Very time consuming and slow.


Try more iteration functions. Thats whay they were made for.
It will cut your code from 500 lines to 200 or less i think.

:) explore

Edited by richieking: n/a

0

ok what the best why to create code php

for booking seats for show i have 2000 seat i want block,paid,free

and i have for 1 day more in 3 times show

how i can create best code of my code see ^^^ up ^^^ you will see my php file and sql


thanks

0

OK

1.You have 2000 seats in the hall,
2. You want block.php
3.paid.php
4.free.php

or what?????

what is block,paid,free thing????
Can you please come out with some good flow chart.
Explore :)

0

when i block seat is come background color black if is free green when paid red all same file or what you what to do but i want it work :)


you can ue my files to know my idea and what i do


thanks very much

0

my seats From A to Z and every litter like A or B have 40 seat

thanks

0

I will have to download your script and go through. can you reload your script again.

this time mark where you think needs attention. how much time do you have at hane before your deadline?

Explore :)

0

i have time for 10 days :)

Edited by WaleedaaN: n/a

0

Thats a lot of time. just mark when you think gives you problems on your file and upload it to me via PM ok?

0

you want me upload files and send it to you by pm ?

Edited by WaleedaaN: n/a

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.