Bookmark this on Delicious Share on Facebook

PHP : Function Reference : mSQL Functions : msql_query

msql_query

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

Example 1384. msql_query() example

copy to clipboard

<?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"];

}
?>

Change Language

Follow Navioo On Twitter

msql_affected_rows
msql_close
msql_connect
msql_create_db
msql_createdb
msql_data_seek
msql_db_query
msql_dbname
msql_drop_db
msql_error
msql_fetch_array
msql_fetch_field
msql_fetch_object
msql_fetch_row
msql_field_flags
msql_field_len
msql_field_name
msql_field_seek
msql_field_table
msql_field_type
msql_fieldflags
msql_fieldlen
msql_fieldname
msql_fieldtable
msql_fieldtype
msql_free_result
msql_list_dbs
msql_list_fields
msql_list_tables
msql_num_fields
msql_num_rows
msql_numfields
msql_numrows
msql_pconnect
msql_query
msql_regcase
msql_result
msql_select_db
msql_tablename
msql

hits counter