Viewing Thread:
"PHP Woe"

Probably something stupid, but it's killing me. I want to let users sort a list of things by one field. Simple enough. However, I need to select the rows, get data from one field in the row, and create another recursive query using this data to pull the rest of the information out the base and echo it in a table.

$query1 = "SELECT diary_id FROM diary WHERE diary_category = '$diary_select'";
$result1 = mysql_query($query1)
or die()
while ($row1 = mysql_fetch_array($result1))
{

}

I'd like it to be something that puts each found value into separate variables, so that the second search is easier. I've tried various arrays, but I'm no expert.

A hand, anybody?

WòókieeMøn§†€® wrote:
> phuzzy wrote:
> A hand, anybody?
>
>
> *Applauds wildly*

Why..why thank you.

Why not use the inbuilt MySQL facility of ORDER BY and just append that to the query string?

i.e. have an array:

$orders = array ("id" => "id", "name" => "name", "title" => "title");

and then use:

if ($_GET['orderby']) { $query1 .= " ORDER BY ".$orders[$_GET['orderby']]; }

phuzzy wrote:
> A hand, anybody?


*Applauds wildly*

Probably something stupid, but it's killing me. I want to let users sort a list of things by one field. Simple enough. However, I need to select the rows, get data from one field in the row, and create another recursive query using this data to pull the rest of the information out the base and echo it in a table.

$query1 = "SELECT diary_id FROM diary WHERE diary_category = '$diary_select'";
$result1 = mysql_query($query1)
or die()
while ($row1 = mysql_fetch_array($result1))
{

}

I'd like it to be something that puts each found value into separate variables, so that the second search is easier. I've tried various arrays, but I'm no expert.

A hand, anybody?