The "Freeola Customer Forum" forum, which includes Retro Game Reviews, has been archived and is now read-only. You cannot post here or create a new thread or review on this forum.
$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?
$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?
> A hand, anybody?
*Applauds wildly*
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*
Why..why thank you.