Another Newbie Question!

[daleGT]

Is it possible to use the Select from

$sqlget = "SELECT * FROM For_Sale ORDER BY input_build ASC";

 

To sort by "input_build" ASC and also check "input_body" for one of the two options (coupe or sedan) & display only coupes

as an example.

[pwntastic]

yes, you can do something like:

$sqlget = "SELECT * FROM `For_Sale` WHERE `input_body` = 'sedan' ORDER BY `input_build` ASC";

 

just as long as you have a column in your db named input_body

[daleGT]

Champion!

I was trying to use the WHERE i still struggle.

[thara]

The WHERE clause is used to extract only those records that fulfill a specified criterion.

Syntax

 

SELECT column_name(s)
FROM table_name
WHERE column_name operator value  

 

 

 

Example

 

SELECT * FROM Persons
WHERE FirstName='Peter'