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();





?>