How do I sort a mysql data row?

murph7185

heres my script that doesn't work, the line that doesn't work in the sort() line included are 2 dif datafields at hte bottom

$result = mysql_query("SELECT catagory,part_number,description,retail FROM inventory WHERE catagory LIKE '%$catagory%' AND description LIKE '%$description%'")or die(mysql_error());

echo "<table border=\"0\" cellspacing=\"5\" cellpadding=\"2\">\n";

echo "<tr><td>Part Number</td><td>Year, Make and Model</td><td>Price</td></tr>\n";

while ($myrow = mysql_fetch_row($result)) {
sort ($myrow[2]);

	printf("<tr><td><font face=\"arial\" size=\"3\">%s</font></td><td><font face=\"arial\" size=\"3\">%s</font></td><td><font face=\"arial\" size=\"3\">%s</font></td></tr>\n",
	$myrow[1], $myrow[2], $myrow[3]);

}

here is an example of 2 dif inputs in the $myrow[2] row

2004 ARCTIC CAT F6 FIRECAT
2002 Z570 (GREEN)

what command should i use to sort those by year

aran

I would suggest using the ORDER BY keywords in your SQL statement to do this the quickest.

murph7185

How would i do it threw php?

murph7185

Anyone got any advice on this thread?

xblue

you've received a reasonable advice: use an ORDER BY clause in your query.

in order to use array sorting functions in php, you'd need to create an array first. $myrow[2] is not an array, it simple holds the string value "description" of the current record set.

again, this is not recommended at all.

eriksmoen

$result = mysql_query("SELECT catagory,part_number,description,retail FROM inventory WHERE catagory LIKE '%$catagory%' AND description LIKE '%$description%' ORDER BY $catagory DESC")or die(mysql_error());

DESC = descending. can also use ASC for ascending... whichever you prefer.

hope that helps.