PHP Newsletter

Join now and receive weekly updates pertianing to the world of PHP.

Polls

What do you think about the new PHPMine Design?
Awesome
Not Bad
Sucks

PHP Gigs By City

PHP Jobs By Topic

Advertisements

all SQL syntax is available in the "mysql_query(...)" PHP function?

Asked 2009-07-02 18:47:26 by Arturo

I'm studying the mysql_query() function, and I would like to know all the things that I could add into the first parameter of this function.
as I know they could be a lot, here, I found a list of all SQL reserved words:

http://developer.mimer.com/validator/sql-reserved-words.tml

My question is:
all those words, can be used in the mysql_query() function? or is there limitations?.

Anwered 2009-07-02 21:14:12 by hostmysite.com

Basically you can put any SQL query in the first parameter. An example of a query would be as follows:

SELECT * FROM tablename;

This will select all the data from table tablename. The best thing to do would be to run the SQL query manually then once you know it returns the data you want to then put it in the php mysql_query() function.

Stephen Williamson, Server Engineer

Questions and answers provided by the Yahoo Answers Community.