[SOLVED] Limiting Results of Query

[gamerzfuse]

I have a query

				//Make first query to database
				$query = "SELECT * FROM vehicles";
				$result = mysql_query($query)
					or die ("Couldn’t execute query.");

				//Set Variables
				$vehiclemodel = $vehicles->model->ViewValue;

				$query = "SELECT * FROM vehicles WHERE model='$vehiclemodel'";
				$result = mysql_query($query)
					or die ("Couldn't execute query.");

				// Display results in a table

				echo "<tr><td colspan='5'></td></tr>";
				while ($row = mysql_fetch_array($result))
				{
				extract($row);

				//Table Contents
				$show_price = number_format($price);
				echo "<tr class='dataright'>\n
				<td colspan='5' class='dataleft'><a href='view.php?stock=$stock'> $year $model</a></td>\n
				<td>$odometer km  </td>\n
				<td align='right'>$$show_price.00 </td>\n
				</tr>\n";
				echo "<tr><td colspan='3'></td></tr>\n";
				}

 

I want to limit the results to only display # results. (ie: 10 results)

Google searches for "limit query" etc haven't given me what I'm looking for.

Any hints, links, etc would be much appreciated.

[JonnoTheDev]

$query = "SELECT * FROM vehicles LIMIT 10";

[Stryves]

$query = "SELECT * FROM vehicles LIMIT 10";

 

Additionally, you can use the following to order by the somecolumn being a real column to select what area of first 10 you want.

 

$query = "SELECT * FROM vehicles ORDER BY somecolumn LIMIT 10 ";

 

[gamerzfuse]

$query = "SELECT * FROM vehicles LIMIT 10";

 

Additionally, you can use the following to order by the somecolumn being a real column to select what area of first 10 you want.

 

$query = "SELECT * FROM vehicles ORDER BY somecolumn LIMIT 10 ";

 

Thanks loads guys, that was going to be my second question Stryves.

Thanks again!

[allworknoplay]

Depends on what you want to do with your application.

 

LIMIT 10 will only show you the first 10 results. But if you want to then show the next 10 results,

you have to provide it like so.

 

 

LIMIT 1,10 = first 10

LIMIT 11,20 = next 10

 

Or you can looking into pagination to provide the full user experience...

[gamerzfuse]

Since you guys are so great at sorting, I'll throw another one out there:

 

I have a list that is sorted based on the column header that is clicked (ie: click Price, sorts by Price)

 

Is there anyway to have it secondarily sort?

I have 400 items in the list and it lists like:

Chevrolet    2008

Honda          2008

Chevrolet    2008

 

Know what I mean?

EDIT: (I want it to sort secondarily by Make or Model regardless, just to keep things looking tidy.)

[Stryves]

$query = "SELECT * FROM vehicles ORDER BY somecolumn DESC, somecolumn2 LIMIT 10 ";

 

If you want to go from highest to lowest, add DESC beside the column name, otherwise it's always ascending.

 

Just put a comma between the 2 column names.

[gamerzfuse]

Just put a comma between the 2 column names.

 

Yeah.. but see, the function I'm using gets the SORT from the URL.

Meaning example.com/items.php?order=make&ordertype=ASC

 

Can I automatically have a second one the defaults to secondary regardless?

$sUrlParm = $this->UrlParm("type=" . mysql_real_escape_string($_GET['type']) . "&order=" . urlencode($fld->FldName) . "&ordertype=" . $fld->ReverseSort());

 

I'm not sure how I would enter commas into this variable?

 

[Ken2k7]

You don't. You do that in the SQL.

[gamerzfuse]

You don't. You do that in the SQL.

 

Yeah.. that stuff is way over my head.

I guess I'll just give up on that one.