Is this syntax correct? it's a small syntax

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
Skywalker
Forum Contributor
Posts: 117
Joined: Thu Aug 29, 2002 3:33 am
Location: The Netherlands

Is this syntax correct? it's a small syntax

Post by Skywalker »

$query_PakketAP = "SELECT * FROM PakketAP Where Blok='yes' ORDER BY ID ASC";


It gives me an error: Unknown column 'Blok' in 'where clause'
User avatar
mydimension
Moderator
Posts: 531
Joined: Tue Apr 23, 2002 6:00 pm
Location: Lowell, MA USA
Contact:

Post by mydimension »

syntax looks fine. try making sure you have a column named Blok and also check the case (blok instead of Blok?).
Post Reply