Confused

[Rusty073]

Please can someone help me I am trying to retrieve info out of a database but all that is happening is it is just repeating the same querie 30 times over
It seems to be just getting the first in the database that match Dash 8 300
<?
mysql_connect(localhost,$username,$password);

@mysql_select_db($database) or die( "Unable to select database");

$dash8300 = "SELECT `Flight_Number` , `Departure_ICAO` , `Arrival_ICAO` , `Departure_Time`
FROM `flights1`
WHERE `Aircraft` = 'Dash 8 300'
ORDER BY `Flight_Number` ASC
LIMIT 0 , 30";

$dash83001 = mysql_query($dash8300) or die(mysql_error());

$row_dash8300 = mysql_fetch_assoc($dash83001);

$totalRows_dash8300 = mysql_num_rows($dash83001);

Thanks in advance
Shane

mysql_close();





?>

[etono]

I didn't immediatly see anything wrong. Perhaps it is the way you are looping through your array? Try this code, and let me know if it is giving you what you want.

PHP Code:

<?php
//assuming connection is made
$sql = "SELECT Flight_Number, Departure_ICAO, Arrival_ICAO, Departure_Time
        FROM flights1
        WHERE Aircraft = 'Dash 8 300'
        ORDER BY Flight_Number ASC
        LIMIT 0, 30";
$result = mysql_query( $sql );
while( $row = mysql_fetch_array( $result, MYSQL_ASSOC ) ) {
    echo "Flight Number: {$row['Flight_Number']}<br />Departure ICAO: {$row['Departure_ICAO']}<br />Arrival ICAO: {$row['Arrival_ICAO']}<br />Departure Time: {$row['Departure_Time']}";
}
?>

I have had troubles in the past with quoting of SQL statements so I always use the form wrote above where only values are single quoted and table fields are not quoted at all. Please repost if this solves your problem, or let me know that it is still not working.

[humair]

you can also use the for...each function to do the same thing