what is correct sql statement syntax in PHP?

Posted by terrani on Stack Overflow See other posts from Stack Overflow or by terrani
Published on 2010-03-24T07:38:38Z Indexed on 2010/03/24 7:43 UTC
Read the original article Hit count: 242

Filed under:

Hi,

when I write a sql statement in php, i usualy write it as below

SELECT COUNT(*) FROM catalogsearch_query AS main_table

but I found that some people write sql statement like

SELECT COUNT(*) FROM catalogsearch_query AS main_table

do I have to use ` ?

what is correct sql statement syntax in PHP?

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, when I write a sql statement in php, i usualy write it as below SELECT COUNT(*) FROM catalogsearch_query AS main_table but I found that some people write sql statement like SELECT COUNT(*) FROM catalogsearch_query AS main_table do I have to use ` ? >>> More
Php function within SQL statement syntax

as seen on Stack Overflow - Search for 'Stack Overflow'
I have the following code. I would like username to take the value of the getUserName function however I am fighting with syntax. Can anybody tell me what should be the correct one? $query = "SELECT user FROM users_entity WHERE username = getUserName()"; >>> More

Developer IT