hey everyone im putting the skills to use that i learnt in chapters 11 and 12 and making myself a program just so i remember as much as possible but im having a problem with a certain part...

    $default_sort_order = "ASC";
    $default_order_by = "userID";

    $max_records_page = 25;

    if(empty($order_by)) {

        $order_by_str = "ORDER BY $default_order_by";
        $order_by = $default_order_by;

    }
    else $order_by_str = "ORDER BY $order_by";



    if(empty($sort_order)) {

        $sort_order_str = $default_sort_order;
        $sort_order = 'DESC';

    } else {

        $sort_order_str = $sort_order;

        if($sort_order == 'DESC') {

            $sort_order = 'ASC';

        } else {

            $sort_order = 'DESC';

        }

    }

    $result = mysql_query("SELECT userID, username, user_email, quiz_wins FROM users $order_by_str $sort_order_str");
    $num_records = mysql_num_rows($result);

    $page_num = 1;

    start_border();

    $total_num_pages = $last_page_num = ceil($num_records / $max_records_page);


    echo "<br><center><b>Viewing Users (put in somethin)</b></center><br><table size=\"702\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" align=\"center\">\n\n";

    echo "<tr>\n";

        echo "<td width=\"105\" align=\"center\"><center><b><a href=\"$PHP_SELF?action=view_users&sort_order=$sor t_order&order_by=userID\">User ID</a></b></center><br></td>";

as you can see the code is identical to the book apart from i have used the variable $org_sort_order because i dont need it. you can view this page at http://stargate.lletnek.co.uk/main.p...ion=view_users im just totally baffled because when you click the link to change userid to ascending or descending it just wont change hopefully you can all see what i mean this problem has been bugging me for 2 days! please help... thanks. Tom

Tom Kentell
Website: http://www.lletnek.co.uk
Forum: http://forum.lletnek.co.uk

Is register_globals on?

Snib

<><

nope but i just worked it out lol always happens when i ask for help i fix it one damn line of code fixed 2 days of angst...

global $sort_order, $order_by, $default_order_by, default_sort_order;

im glad its done but that takes the piss lol

thanks anyway mate :)

Tom Kentell
Website: http://www.lletnek.co.uk
Forum: http://forum.lletnek.co.uk

LOL.... Glad it's working :-)

Snib

<><