0

I'm working on my ticketing system project, there's an error on my code and I've already search on web some answer but nothing works. The error says

Notice: Undefined offset: 4 in C:\wamp\www\Online Bus Reservation\admin\bussch.php on line 69

Here is my code

$ddaa = mysql_query("SELECT id, route, time FROM bus_sch ORDER BY id");
echo mysql_error();
while ($data = mysql_fetch_array($ddaa))
{
$sold = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM seat_details WHERE busid='".$data[0]."' AND status='1'"));
$available = $data[4]-$sold[0];
$rname = mysql_fetch_array(mysql_query("SELECT routename FROM bus_route WHERE id='".$data[1]."'"));

The Line 69 is:

$available = $data[4]-$sold[0];

Please Help. Thank you :)

chris85
  • 23,846
  • 7
  • 34
  • 51
nelzkiiee
  • 31
  • 1
  • 4
  • 1
    `$data` doesnt have a fifth ([4]) index. Look at what it is, `print_r($data);`. You also should update your db driver (PDO or mysqli) and use parameterized queries. – chris85 Nov 13 '16 at 06:03

1 Answers1

0

Read the error message:

Undefined offset: 4

And pay attention to your query:

mysql_query("SELECT id, route, time FROM bus_sch ORDER BY id");

You have three element:

  • 0 for id
  • 1 for route
  • 2 for time
sensorario
  • 20,262
  • 30
  • 97
  • 159