Simple query syntax

Codes here !

Moderators: egami, macek, gesf

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

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

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

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
  • Information
  • Who is online

    Users browsing this forum: No registered users and 5 guests