Wassup with MySQL?

[Manat]

Hello all

This is my Where Clause:

WHERE
".$whereClause."
ORDER BY
prod.Nom ASC, prod.Price_Range_ID DESC
". $limit;

Tell me, is there something wrong with it? I don't get any errors, no PHP errors whatsoever, the page parses fine, but.... the second clause after the comma doesn't happen.

It only orders by prod.Nom ASC, but not prod.Price_Range DESC.
Anyone know why?
Is this a limitation of MySQL since it's not relational? Ya that question makes no sense, but anyhow, anyone know why it doesn't work?

Thanks

[Rodders]

1. You need to tell people what is in $whereClause and $limit

2. You should show the whole query, not the end of it

3. Can you show the results to show that the ORDER BY does not work?

[rheroux]

Try setting up your SQL statement like this:

$sql = "SELECT blah FROM tablename WHERE '" .$whereClause. "' ORDER BY prod.nom ASC, prod.Price_Range_ID DESC '" .$limit. "'";

[Manat]

//Returns the query which searches the product table
function productQuery($ageId,$priceId,$pieceId,$awardWinner,$newProduct,$pageIndex=1,$numToDisplay=6) {

$offset = ($pageIndex-1)*$numToDisplay;
$limit = " LIMIT $offset,$numToDisplay "; 
$whereClause = constructWhereClause($ageId,$priceId,$pieceId,$awardWinner,$newProduct);
$strSQL =
"SELECT DISTINCT 

	prod.Produit_ID AS prodId,
	prod.Is_New AS newProduct,
	prod.Is_Award_Winner AS awardProd,
	prod.Nom AS prodName,
	prod.img_thumb_1 AS prodThmImg,
	prod.img_pop_1 AS prodPopUpImg,
	prod.SKU AS prodSKU,
	prod.Number_Piece_Range_ID AS piecesId,
	prod.Price_Range_id AS priceId,
	prod.List_Group_Age_ID AS ageId

FROM
	Produit prod,
	Groupe_Age age

WHERE
".$whereClause." 
ORDER BY prod.Nom ASC, prod.Price_Range_ID DESC, prod.Produit_ID 
". $limit;
$q = new Query();
$q->setSQL($strSQL);
return $q;

}

This is currently on our Dev Server and is not online, So i can't send a URL to show the HTML Results, but shouldn't a nested Order By do what I want?

Nom is the Product Name.
$limit is just the limit of results for that page.

[diego25]

Shouldn't
FROM
Produit prod,
Groupe_Age age

be

FROM
Produit AS prod,
Groupe_Age AS age

Diego