ordering problem

[treds1]

Hi i am using the following query to select the first 10 rows from a stockist db and dispaly data page by page using a paginator script.

My problem is that i cant order the returned data, i want to order the whole data set alphabetically and display the first 10 results on first page and so on.

SQL is

$sql1 = mysql_query("SELECT SQL_CALC_FOUND_ROWS * FROM stockist WHERE county_code='$code' AND country_code='$countrycode' ORDER BY county_code LIMIT $from, $max_results");

any ideas

[cassius]

The * is supposed to be used whenever you choose to SELECT ALL data/fields that match your conditions, not when you specify whick field to choose data from.

A simple example:

$sql = "SELECT * FROM DataTable ORDER BY entryID DESC LIMIT 2, 6";

With a specified coloumn:

$sql = "SELECT passengerName FROM DataTable ORDER BY entryID DESC LIMIT 2, 6";

The last sql-statement specifies to choose data from the field "passengerName" in the table, therefor you can drop the * that will select/return data from all fields in the records that match your conditions.