JavaScript Editor Javascript debugger     Website design 


Send mSQL query (PHP 4, PHP 5)
resource msql_query ( string query [, resource link_identifier] )

msql_query() sends a query to the currently active database on the server that's associated with the specified link identifier.



The SQL query.


The mSQL connection. If not specified, the last link opened by msql_connect() is assumed. If no such link is found, the function will try to establish a link as if msql_connect() was called, and use it.

Return Values

Returns a positive mSQL query identifier on success, or FALSE on error.


Example 1384. msql_query() example

= msql_connect("dbserver")
  or die(
"unable to connect to msql server: " . msql_error());
msql_select_db("db", $link)
  or die(
"unable to select database 'db': " . msql_error());

$result = msql_query("SELECT * FROM table WHERE id=1", $link);
if (!
$result) {
"query failed: " . msql_error());

while (
$row = msql_fetch_array($result)) {