random its all new to me

UKlee

Hi guys Im interested in using random to retrieve information from a table obviously 🙂 I can get this to generate the random information and display it in a table.This would display random outbound flights starting with FLYxxxA
but this is a bit silly since you would also need an inbound flight aswell these use the same number and letters but have a B at the end, is there anyway that I could call this information also and display this aswell so you would have an outbound and an inbound flight.even if this was displayed in another table bellow perhaps.

any help or hints would be great

kind regards

Lee

working example of this script

<?


$dbh=mysql_connect("localhost", "", "") or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db ("");
$query = "SELECT * FROM `timetable`where  hub='EGPF' AND departure='EGPF' AND rankneeded <= '9' ORDER BY RAND() ASC LIMIT 6;";
$result = mysql_query($query)
or die ("Couldn't execute query.");  

$flightno[$i]= $colum["flightno"];   

  /* Display results in a table */  echo "<table width='820' align='center' cellpadding='1' cellspacing='0' border='1' bordercolor='#000066'>
<tr>
<td width='110'bgcolor='#000066' bordercolor='#000066'align='center'style='font-weight: bold'style='text-decoration: none'><font color='#FFFFFF' size='2'>Flight No</td>	
<td width='10'bgcolor='#000066' bordercolor='#000066'align='center'style='font-weight: bold'style='text-decoration: none'><font color='#FFFFFF' size='2'>Depart</td>
<td width='250'bgcolor='#000066' bordercolor='#000066'align='center'style='font-weight: bold'style='text-decoration: none'><font color='#FFFFFF' size='2'>Departure Airport</td>
<td width='10'bgcolor='#000066' bordercolor='#000066'align='center'style='font-weight: bold'style='text-decoration: none'><font color='#FFFFFF' size='2'>Dest</td>
<td width='250'bgcolor='#000066' bordercolor='#000066'align='center'style='font-weight: bold'style='text-decoration: none'><font color='#FFFFFF' size='2'>Destination Airport</td>
<td width='200'bgcolor='#000066' bordercolor='#000066'align='center'style='font-weight: bold'style='text-decoration: none'><font color='#FFFFFF' size='2'>Aircraft</td>
<td width='100'bgcolor='#000066' bordercolor='#000066'align='center'style='font-weight: bold'style='text-decoration: none'><font color='#FFFFFF' size='2'>Type</td>
</tr>";

  while ($colum = mysql_fetch_array($result))
  {
extract($colum);
echo "<tr>\n
<td width='110'bgcolor='#D1D1E7' bordercolor='#000066'align='center'style='font-weight: 'style='text-decoration: none'><font color='#000000' size='2'>$flightno </td>	
<td width='10'bgcolor='#D1D1E7' bordercolor='#000066'align='center' style='font-weight: 'style='text-decoration: none'><font color='#000000' size='2'>$departure</td>\n
<td width='250'bgcolor='#D1D1E7' bordercolor='#000066'align='center' style='font-weight: 'style='text-decoration: none'><font color='#000000' size='2'>$departuredetails</td>\n
<td width='10' bgcolor='#D1D1E7' bordercolor='#000066'align='center' style='font-weight: 'style='text-decoration: none'><font color='#000000' size='2'>$destination</td>\n
<td width='250'bgcolor='#D1D1E7' bordercolor='#000066'align='center' style='font-weight: 'style='text-decoration: none'><font color='#000000' size='2'>$destinationdetails</td>\n
<td width='200'bgcolor='#D1D1E7' bordercolor='#000066'align='center' style='font-weight: 'style='text-decoration: none'><font color='#000000' size='2'>$aircraft</td>\n
<td width='100'bgcolor='#D1D1E7' bordercolor='#000066'align='center' style='font-weight: 'style='text-decoration: none'><font color='#000000' size='2'>$type</td>\n
</tr>\n";
  }
  echo "</table>\n";?>

Weedpacket

Well, first of all, try reading up on stylesheets. That HTML is so 1990s....

Second of all, remember your punctuation - I can hardly make out what you're on about. Something to do with random inbound and outbound flights is all I can make out.

UKlee

yep 1990's you say its new to me ,what I was trying to ask or get accross was that I can call flights using that code above and get random results for all outbound flights,ie all the flights end with a capital A.

Would it or is it possible to get the same random infomation for the return flight which use exactly the same flightnumbers but they end with a capital B.

So I would like to call the random flights ending with an A ,but also poulate the random numbers but with B so in effect you have outbound and inbound the same.

FLY123A random
but have FLY123B also appear.

hope that clears it up and I will look into style sheets right away.

thanks for looking regards

Lee

kakki

so you want to have six random elements of a table and then afterwards
the corresponding values ???
i think you need a sub-query ( or sth. equivalent )
i dont know, what your tables look like, but i used code like this for a script:

$inString='';
// this gets me 6 random elemts of a table, the key-row is named "id"
$inQuery = "SELECT id FROM `timetable`where  hub='EGPF' AND departure='EGPF' AND 
rankneeded <= '9' ORDER BY RAND() ASC LIMIT 6;"; 
while( $row=mysql_fetch_row( $inQuery )
{
     if ( strlen ( $inString > 0 ) )
     {
         $inString .= ',';    // add a comma, if more than one value present
     }
     $inString .= $row[ 0 ];
}
// now we have the value for the "in"-part in the next sql
$query = "SELECT * FROM `timetable` as a, timetable as b WHERE a.id=b.id AND a.id IN ( ". $inString ." ) ";

with that you have a dynamic "join" on the tables ( with the random elemts )
i think the easiest sql would be:
( does the same, but on a sql-basis BUT not functioning on mysql V3... )
SELECT from timetable as a, tiemtable as b WHERE a.id=b.id AND a.id in ( SELECT FROM timetablewhere hub='EGPF' AND departure='EGPF' AND rankneeded <= '9' ORDER BY RAND() ASC LIMIT 6; )

UKlee

hmmm i cant seem to get this to work

my information is stored like this

so Im not sure how to set your script up to even test this i keep getting an error also

Warning: mysql_fetch_row():

so am not sure whast going on thank you for taking the time to try and help me

cheers

lee

UKlee

or as an alternative or aswell as is it possible to take for example the random flight numbers and insert them into a field or fields in my datbase.????

thanks for taking the time to even look at this thread

cheers

Lee

kakki

mmmmhhh...

if all your flightno. are encoded like: FLYxxxA and FLYxxxB;
i think that you cannot form a "simple" sql statement,
( because you stored two information in one field (in the ending "A" and "B" ) )
if you still can change your db-tables then i suggest, that you
have a field named flightno1 and flightno2,
no1 storing FLYxxx
no2 storing A,B
then you can get the according flights with sql-statements

otherwise:
you have to take your random rows, get the flightno and change the last digit( 'A' -> 'B' )
with php
then you'll have to do a second query with all your modified flightno ( $inString )
afterwards you can load them to an array and output the corresponding lines when you
output the random values

UKlee

SO Kakki if I was to replace my flight numbers in my tabl ethen this would be more simple.

i already have a field called flightno and that contains the flight numbers in FLYXXXA
or FLYXXXB if i removed the A/B and create a new field holding the A/B info depending on outbound or inbound i could then call both parts of the flight inbound and outbound using a script like the one above.

Also is it possible if i do this that i can grab the 6 random flight numbers and place them in another table ie a pilots list and have the flight numbers add to this????aswell as having it display in a table.

I hope I am making sence it is hard to describe what I mean with my php being limited.

Im dealing with 400+ flights so if it has to be done I would rather do this now rather than later as more information would need to be added.

regards

Lee

kakki

maybe you can use this without modification of your tables

$inString='';
// thats your query( modified, you only get the key-field of the table )
$inQuery = "SELECT flightno FROM `timetable`where  hub='EGPF' AND departure='EGPF' AND
rankneeded <= '9' ORDER BY RAND() ASC LIMIT 6;"; 
while( $row=mysql_fetch_row( $inQuery )
{
     if ( strlen ( $inString > 0 ) )
     {
         $inString .= ',';    // add a comma, if more than one value present
     }
     $globalInString .= $row[ 0 ];
}
$inString=ereg_replace ( 'A', 'B', $globalInString ); 
// now $inString looks like this: FLY111B, FLY222B, FLY333B
// if your flightno are without any further A's
$query = mysql_query( "SELECT * FROM `timetable` WHERE  flightno IN ( ". $inString ." ) ORDER BY flightno" ); 
// now you have all responding lines 
$allCorrespondingFlights=array()
while ( $row=mysql_fetch_array( $query ) )
{
     $allCorrespondingFlights[] = $row; // just store it in a local array
}
// output from here
$query = mysql_query( "SELECT * FROM `timetable` WHERE  flightno IN ( ". $globalInString ." ) ORDER BY flightno" ); 
$counter=0;
while ( $row=mysql_fetch_array( $query ) )
{
// "normal" flight ( flightno. FLYxxxA ) in $row
// "corresponding" flight ( flightno. FLYxxxB ) in $allCorrespondingFlights[$counter]
    $counter++;
}

i think, that if you split your flightno-column into "FLYxxx" and "A/B" you dont need
the $inString part or the allCorrespondingFlights - part