ORDER doesn't work

[Dillenger]

Can someone tell me if there is something wrong with this line of code? I can't seem to get the ORDER to work, it just puts them in how it wants, even if I define which field to order it by.

$sql = "SELECT category.*, newproject_data.*, projectdata_details.* FROM category, newproject_data, projectdata_details WHERE category.catID='$new_cats[$i]' AND projectdata_details.projID=newproject_data.detailID AND newproject_data.nprojectID=newproject_data.nprojectID ORDER BY 'category.importance' ASC";

[TheDefender]

Remove the single quotes from around your ORDER BY item...

$sql = "SELECT category.*, newproject_data.*, projectdata_details.* FROM category, newproject_data, projectdata_details WHERE category.catID='$new_cats[$i]' AND projectdata_details.projID=newproject_data.detailID AND newproject_data.nprojectID=newproject_data.nprojectID ORDER BY category.importance ASC";

[Dillenger]

Thanks,

I've just tried that and it didn't work either.

[TheDefender]

It should work... The only other thing I would personally change is to concatenate the variable in the WHERE clause...

$sql = "SELECT category.*, newproject_data.*, projectdata_details.* FROM category, newproject_data, projectdata_details WHERE category.catID='".$new_cats[$i]."' AND projectdata_details.projID=newproject_data.detailID AND newproject_data.nprojectID=newproject_data.nprojectID ORDER BY category.importance ASC";

but that shouldn't be a factor... Are you certain the category.importance field exists? What happens if you just do a simple query like "SELECT * FROM category ORDER by importance ASC"? Does it sort properly then?

[vryce]

Try adding, for testing purposes, a line like this

echo $sql;

And post the results here.. Maybe your variable isn't getting read correctly and it is losing the ORDERBY part.

[Dillenger]

this is the output i get:

SELECT category.*, newproject_data.*, projectdata_details.* FROM category, newproject_data, projectdata_details WHERE category.catID='89' AND projectdata_details.projID=newproject_data.detailID AND newproject_data.nprojectID=newproject_data.nprojectID ORDER BY category.importance ASC

[Dillenger]

here is the full code for this function... could it be due to my explode statement???

/************************************* BEGIN PROJECT DETAIL DISPLAY **************************************/						

	/* takes the comma seperated values in catID and seperates them */
	$new_cats = "$catID";
	$new_cats = explode(",", $new_cats);

	/* for each seperated value, displays the category that is linked to it from the category table */
	for ($i=0; $i<sizeof($new_cats); $i++)
	{ 
	$sql = "SELECT * FROM category, newproject_data, projectdata_details WHERE category.catID='$new_cats[$i]' ORDER BY category.catSelect ASC"; 

	$result = mysql_query($sql);

	$owners = mysql_fetch_array($result);

	$id=$owners['nprojectID'];
	$name=$owners['catSelect'];
	$detail=$owners['description'];

	echo "<span class='headers3' STYLE='width:150px'>$name</span><br>";
	}

[superwormy]

You're only selecting one record in each query... how do you expect to order just one record?

You probably mean to be doing something like this:

$result = mysql_query("SELECT * FROM category, newproject_data, projectdata_details WHERE category.catID IN ( PUT YOUR COMMA-SEPARATED LIST OF catID VALUES IN HERE! ) ORDER BY category.catSelect ASC");

while ($array = mysql_fetch_array($result))
{
print_r($array);
}