Query Synyax

[jenniferG]

We are tryng to add a sort [$SORT] clause  to these queries  and afterwards theydo not work. 

Syntax problem?

========================================================

$SORT='ORDER BY MFGR,CATGY_1';

$selectall="SELECT * FROM $tablename . $SORT";

$selectcat="SELECT * FROM $tablename WHERE CATGY_1 = '" . $CATGY_1 . "' . $SORT ";

$selectmfg="SELECT * FROM $tablename WHERE MFGR = '" . $MFGR . "' . $SORT";

$selectboth="SELECT * FROM $tablename WHERE CATGY_1 = '" . $CATGY_1 . "'

                AND MFGR = '" . $MFGR ."' .$SORT";

=========================================================

Thanks

Jennifer

 

[Stephen]

What is $CATGY_1 and $MFGR?

 

By the way, in $selectall I think it should be:

 

$selectall="SELECT * FROM ".$tablename." ".$SORT."";

[br0ken]

Try echoing your queries out before running them so you can see the exact query you're passing to MySQL.

 

Your query should be in the form...

 

SELECT * FROM TABLENAME ORDER BY field

 

Print out your queries and compare them to this and it should be obvious where you've gone wrong

[jelly]

<?php
          $sql = "SELECT FROM `table` WHERE `field` ORDER BY `field`";
          mysql_query($sql) or die(mysql_error());

          echo '<pre>';
            print_r($sql);
          echo '</pre>';
?>

 

--

jelly