Correct use of SQL server query using PHP

Question

I am using PHP and when I tried to use the following query on SQL Server, it gives me a syntax error saying there is an invalid use near the key word WHERE. If I don't use the WHERE Status='Open' part in my query, this works fine without any error. Does the SQL server considering Status or Open as keywords?

$query = "SELECT * FROM ElectronicShop ORDER BY Completed WHERE Status='Open'";

Error:

Array ( [0] => Array ( [0] => 42000 [SQLSTATE] => 42000 [1] => 156 [code] => 156 [2] => [Microsoft][SQL Server Native Client 10.0][SQL Server]
Incorrect syntax near the keyword 'WHERE'. [message] => [Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near the keyword 'WHERE'. ) )

Read some books about SQL

Bogdan Burym
– Bogdan Burym

2014-08-01 14:34:38 +00:00
Commented Aug 1, 2014 at 14:34 — Bogdan Burym
– Bogdan Burym, Commented Aug 1, 2014 at 14:34

Kevin Labécot · Accepted Answer · 2014-08-01 14:29:11Z

2

The WHERE clause must be before the ORDER BY clause (with any database, this is not related to SQL Server).

$query = "SELECT * FROM ElectronicShop WHERE Status='Open' ORDER BY Completed";

answered Aug 1, 2014 at 14:29

Kevin Labécot

1,99513 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

dave Over a year ago

Unless you are using the Linq to Entities in .net ;-)

D P. Over a year ago

@Kevin Thank you for showing me with an example. Now it says, The data types text and varchar are incompatible in the equal to operator. Should I cast the Open to something else?

Kevin Labécot Over a year ago

Status type is Text ? Why are you using this type ? I would prefer nvarchar.

Collectives™ on Stack Overflow

Correct use of SQL server query using PHP

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related