results in dropbox and ORDER BY problem

[Guenhwyvar]

I need to get the next result to appear in my dropdown box for personrow[0] etc
i dont see where i can put a loop as the options are in a loop?

(for loop using $i)
echo "<Option value = \"$i\">$PersonRows[0] $PersonRows[1] and $Person2Rows[0] $Person2Rows[1] </Option>";

I need to iterate though the results of $PersonRows[0] $PersonRows[1] and $Person2Rows[0] $Person2Rows[1] for each $i

At the moment I get

Andy Smith
Andy Smith
Andy Smith

But I need

Andy Smith
Tim Carbrook
Tom Steptoe

etc,

Also I have

$Choicequery ="SELECT PersonA, PersonB FROM modules WHERE GroupID = '$UpdateNumber'"; or
$Choicequery ="SELECT PersonA, PersonB,StartDate FROM modules WHERE GroupID = '$UpdateNumber'";

But if I add ORDER BY StartDate, it returns nothing? I really need them ordered....

Any ideas?, thanks

[bradgrafelman]

Guenhwyar wrote:

I need to iterate though the results of $PersonRows[0] $PersonRows[1] and $Person2Rows[0] $Person2Rows[1] for each $i

What $i? There is no $i in any of those references; you're specifically accessing array elements #0 and #1, so there is nothing to "iterate through" there. Perhaps you should be using $i to determine the index number instead?

Guenhwyar wrote:

But if I add ORDER BY StartDate, it returns nothing?

What is "it" ? Are you sure "it" isn't returning boolean FALSE, likely indicating that an error occurred while executing your SQL query (in which case, did you then retrieve the error message provided by the SQL server)?

Show us what the queries look like after you've attempted to add the ORDER BY clause.