Simple query syntax

Codes here !

Moderators: macek, egami, gesf

Post Reply
johnj
php-forum Super User
php-forum Super User
Posts: 1805
Joined: Thu Mar 10, 2011 5:07 pm

Re: Simple query syntax

Post by johnj » Thu Aug 30, 2012 9:24 pm

Visitor and visitor - Is there a difference between the two?. Use phpmyadmin to see whether the table name is starting with a lower or upper case.

User avatar
freshnet
php-forum Active User
php-forum Active User
Posts: 359
Joined: Tue Feb 22, 2011 8:19 am
Location: Canada

Re: Simple query syntax

Post by freshnet » Fri Aug 31, 2012 4:34 am

agree with John - your second query looks right. You can't use ' with table names, those are for quoted strings only. You can use ` with table names, although I generally don't. The table name is probably Visitor.

User avatar
freshnet
php-forum Active User
php-forum Active User
Posts: 359
Joined: Tue Feb 22, 2011 8:19 am
Location: Canada

Re: Simple query syntax

Post by freshnet » Sun Sep 02, 2012 2:50 am

Object names are case sensitive, in MYSQL at least. Keywords aren't case sensitive, i.e. SELECT = Select = SeLeCt. Strings can be case sensitive depending on the platform.

Post Reply

Who is online

Users browsing this forum: No registered users and 3 guests