[Resolved] PHP and PostgreSQL

[BBDan]

Hello,

I have a line:

<A HREF> Products </A HREF>

When somebody click on this link, I want the program to execute:

$query=" SELECT * FROM webpurchases ORDER BY products ";

What command can I use to link the two lines?

Thanks

[erikwebb]

You can't execute PHP based on mouse click. What'd you have to do is set the link to a page where that PHP will execute. For example:

<a href="<?php print $PHP_SELF . "?sort=products"; ?>">Products</a>

If you are trying to sort by columns (which is what it appears you are doing), just use a switch statement before you output the table and determine which field to search by.

[BBDan]

Hello erikwebb,

"?sort=products"; ?>">

What does that portion do?

Thanks for your suggestion

[stolzyboy]

lets you call a variable

$_GET['sort']

on the next page, and it will have the value "products"

[erikwebb]

That's just an example. It's just a variable to let you know what you are sorting by, how you use it is completely up to you.

[BBDan]

I'm not really sure I'm understanding it correctly Like for the line below:

echo "<a href=webpurchase1.php."?sort=contactperson";>Contact Person</a> ";

There will be a variable in webpurchase1.php called sort, and it will be assigned the value contactperson?

Is it what it means?

By the way, I think I made some syntax error on that line, I would really appreciate it if you guys can help me out.

Thanks a alot

[erikwebb]

This is correct:

echo "<a href=\"webpurchase1.php?sort=contactperson\">Contact Person</a> ";

What this does is tell what the sort variable is equal to. You can use the sort variable to determine by which column to sort.

[BBDan]

Assume in Page 1 that I have the below code:

if($col==1)
{
$OutCtrl=1;
//echo "<a href=webpurchase1.php>Company Name</a> ";
echo "<a href=\"webpurchase1.php?sort=companyname\">Company Name</a> ";
}

Then in Page 2 I have the following:

if($_GET['sort']==companyname)
{
if($sortCompany==0)
{

                    $query=" SELECT * FROM webpurchases ORDER BY companyname DESC";
                    $sortCompany=1;
                    }
            else
                    {

                    $query=" SELECT * FROM webpurchases ORDER BY companyname ASC ";
             $sortCompany=0;
                    }

            $OutCtrl=0;
            }

I want that everytime I click on the Company Name link, the table will sort alternatingly between descending and ascending order. But the above code just seem to be executing the descending order code portion only. I only declared sortCompany in the above segment and nowhere else.

Please help. Thanks.

[BBDan]

Thanks Stolzyboy and erikwebb, your suggestions worked