Home >> FAQs/Tutorials >> MySQL Tutorials

MySQL Tutorial - Execute SQL Statements

By: FYIcenter.com

(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:

<?php
  include "mysql_connection.php";

  $sql = 'SELECT SYSDATE() FROM DUAL';
  $res = mysql_query($sql, $con);
  $row = mysql_fetch_array($res);
  print("Database current time: ". $row[0] ."\n");

  mysql_close($con); 
?>

If you run this script, you will get something like this:

Database current time: 2006-07-01 21:34:57

1. How To Install PHP on Windows?
2. How To Verify Your PHP Installation?
3. What Do You Need to Connect PHP to MySQL?
4. How To Turn on mysql Extension on the PHP Engine?
5. How To Connect to a MySQL Server with Default Port Number?
6. How To Connect to a MySQL Server with a Port Number?
7. How To Connect to MySQL Server with User Accounts?
8. How To Access MySQL Servers through Firewalls?
9. How To Get Some Basic Information Back from MySQL Servers?
10. How To Close MySQL Connection Objects?
11. How To Get a List of Databases from MySQL Servers?
12. How To Create a New Database?
13. What Happens If You Do Not Have Privileges to Create Database?
14. How To Get MySQL Statement Execution Errors?
15. How To Drop an Existing Database?
16. How To Select an Exiting Database?
17. Can You Select Someone Else Database?
18. How To Execute a SQL Statement?