PHP: msql_query - Manual

downloads | documentation | faq | getting help | mailing lists | reporting bugs | php.net sites | links | conferences | my php.net

search for in the

msql_regcase msql_pconnect

Last updated: Sat, 27 Jan 2007

view this page in

# msql_query

(PHP 3, PHP 4, PHP 5)

msql_query -- Send mSQL query

## Описание

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.

## Список параметров

`query`

  The SQL query.

`link_identifier`

  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.

## Возвращаемые значения

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

## Примеры

Пример 1. msql_query() example

`<?php
$link = 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) {
die("query failed: " . msql_error());
}
while ($row = msql_fetch_array($result)) {
echo $row["id"];
}
?>`

## Смотрите также

msql_db_query()
msql_select_db()
msql_connect()

add a note User Contributed Notes
msql_query
There are no user contributed notes for this page.
msql_regcase msql_pconnect

Last updated: Sat, 27 Jan 2007
show source | credits | stats | sitemap | contact | advertising | mirror sites
Copyright © 2001-2007 The PHP Group
All rights reserved.
This mirror generously provided by: Yahoo! Inc.
Last updated: Sat Mar 10 10:36:09 2007 PST