Home >> FAQs/Tutorials >> MySQL Tutorials
MySQL Tutorial - Execute SQL Statements
(Continued from previous topic...)
How To Execute a SQL Statement?
You can run any types of SQL statements through the mysql_query() function.
It takes the SQL statement as a string and returns different types of data depending
on the SQL statement type and execution status:
- Returning FALSE, if the execution failed.
- Returning a result set object, if the execution is successful on a SELECT statement or other statement returning multiple rows of data.
- Returning TRUE, if the execution is successful on other statements.
Here is a good example of running a SQL statement with the mysql_query() function:
$sql = 'SELECT SYSDATE() FROM DUAL';
$res = mysql_query($sql, $con);
$row = mysql_fetch_array($res);
print("Database current time: ". $row ."\n");
If you run this script, you will get something like this:
Database current time: 2006-07-01 21:34:57
- How To Install PHP on Windows?
- How To Verify Your PHP Installation?
- What Do You Need to Connect PHP to MySQL?
- How To Turn on mysql Extension on the PHP Engine?
- How To Connect to a MySQL Server with Default Port Number?
- How To Connect to a MySQL Server with a Port Number?
- How To Connect to MySQL Server with User Accounts?
- How To Access MySQL Servers through Firewalls?
- How To Get Some Basic Information Back from MySQL Servers?
- How To Close MySQL Connection Objects?
- How To Get a List of Databases from MySQL Servers?
- How To Create a New Database?
- What Happens If You Do Not Have Privileges to Create Database?
- How To Get MySQL Statement Execution Errors?
- How To Drop an Existing Database?
- How To Select an Exiting Database?
- Can You Select Someone Else Database?
- How To Execute a SQL Statement?