[RESOLVED] Random and query question

[UKlee]

Hi I am trying to write a piece of code that will enable me to get one peice of information based on the last piece of information returnted from a mysql db.

Sounds unclear but here is what I mean

$query = "SELECT * FROM timetable where departure = 'EGNT'  ORDER BY RAND() Limit 1 ";

it returns the data EGLL as the next departure for example so I now wish to see random items with a departure from EGLL.

Now I am wondering is there a faster way to create maybe 6 of these situations as aposed to having to right 6 queries based upon the departure result of the last ie all in one query based upon the result of the last or am I confined to seperate queries on this on.

Thanks for taking the time to read this post have a great weekend

kind regards

lee

[stolzyboy]

will it always be 6?

if so, just run your query in a for loop, keep the result from the last query and loop it through to the next

i still don't fully understand what you are trying to do, but looping should get the desired results

[Piranha]

Edit: With the answer I realise that my suggestion can't work. Because of that I have removed it.

[UKlee]

Hi How would I write such a for loop in order to maintain the last retieved item of information for refference against the next and Ideas. About always being 6 I may be interested in more or less but 6 as a go for now.

what i am trying to do is gather information in a continuing flow.

starting at point A I randomly get a flight that takes me to point B from point I then would randomly get a flight from point B to point C and so on so based upon where I land i get a new place to land based on where I last left does that make any more sence when I explain it like this.

thanks for the replies guys and taking the time to look

Regards

Lee

[stolzyboy]

something like this... you'll have to implement it fully tho, and it is untested obviously, just threw example together quickly

<?
$answer = "";

for ($i = 1; $i = 6; $i++)
{
	if ($answer == "")
	{
		//do first select
		//$query = "SELECT * FROM timetable where departure = 'EGNT'  ORDER BY RAND() Limit 1 ";
	}
	else
	{
		//do next selects based on answers whatever the select is
	}
}
?>

[bradgrafelman]

I believe stolzyboy meant something like this:

for ($i = 1; $i <= 6; $i++)

for a for() statement (forgot the '<' operator).

[stolzyboy]

yeah, yeah, yeah... you forget one little thing and you get jumped on... maybe i wanted to infinite loop the webserver 😛

[Weedpacket]

But no-one here ever runs cut-and-pasted code without working out what it does first, so typos like that shouldn't be a problem.....

[Piranha]

LOL @ Weedpacket

[UKlee]

thanks guys and i have looked at it and now understand thanks

kind regards

Lee