How To Run a SQL Statement

Q

How To Run a SQL Statement? - MySQL FAQs - PHP Connections and Query Execution

✍: FYIcenter.com

A

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

2007-05-10, 4671👍, 0💬

How To Get the Number of Rows Selected or Affected by a SQL Statement
How To Get the Number of Rows Selected or Affected by a SQL Statement? - MySQL FAQs - Managing Tables and Running Queries with PHP Scripts There are two functions you can use the get the number of rows selected or affected by a SQL statement: mysql_num_rows($res) - Returns the number of rows selecte... 2007-05-10, 5049👍, 0💬

How To Fix the INSERT Command Denied Error
How To Fix the INSERT Command Denied Error? - MySQL FAQs - Managing Tables and Running Queries with PHP Scripts The reason for getting the "1142: INSERT command denied" error is that your user accound does not have the INSERT privilege on the table or database. To resolve this error, you need to ask... 2007-05-10, 4981👍, 0💬

What Happens If You Do Not Have Privileges to Create Database
What Happens If You Do Not Have Privileges to Create Database? - MySQL FAQs - PHP Connections and Query Execution If your MySQL server is provided by your Internet service company, your user account will most likely have no privilege to create new databases on the server. In that case, your CREATE D... 2007-05-10, 4962👍, 0💬

How To Insert Data into an Existing Table
How To Insert Data into an Existing Table? - MySQL FAQs - Managing Tables and Running Queries with PHP Scripts If you want to insert a row of data into an existing table, you can use the INSERT INTO statement as shown in the following sample script: <?php include "mysql_connection.php"; $sql ... 2007-05-10, 4785👍, 0💬

How To Select an Exiting Database
How To Select an Exiting Database? - MySQL FAQs - PHP Connections and Query Execution The first thing after you have created a connection object to the MySQL server is to select the database where your tables are located, by using the mysql_select_db() function. If your MySQL server is offered by yo... 2007-05-10, 4768👍, 0💬

Can You Select Someone Else Database
Can You Select Someone Else Database? - MySQL FAQs - PHP Connections and Query Execution If your MySQL server is provided by an Internet service company, they will provide you one database for your use only. There are many other databases on the server for other users. But your user account will hav... 2007-05-10, 4749👍, 0💬

How To Drop an Existing Database
How To Drop an Existing Database? - MySQL FAQs - PHP Connections and Query Execution If want to drop an existing database from the MySQL server, you can use the DROP DATABASE statement. Here is a good example of dropping an existing database: $con = mysql_connect('localhost:8888' ,'dev', 'iyf'); $sq... 2007-05-10, 4709👍, 0💬

How To Run a SQL Statement
How To Run a SQL Statement? - MySQL FAQs - PHP Connections and Query Execution 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 FA... 2007-05-10, 4672👍, 0💬

How To Get MySQL Statement Execution Errors
How To Get MySQL Statement Execution Errors? - MySQL FAQs - PHP Connections and Query Execution When you execute a MySQL statement with mysql_query(), and the statement failed, mysql_query() will return the Boolean value FALSE. This is good enough to tell that there is something wrong with that stat... 2007-05-10, 4647👍, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.