<?php // Send a select query to MSSQL $query = mssql_query('SELECT [username], [name] FROM [php].[dbo].[userlist]');// Check if there were any records if (!mssql_num_rows($query)) { echo 'No records found'; } else { // The following is equal to the code below: // // while ($row = mssql_fetch_row($query)) { while ($row = mssql_fetch_array($query, MSSQL_NUM)) { // ... } }// Free the query result mssql_free_result($query); ?>
$query = "insert into user(name,age) values($name,$age)";建议这样也试试
$query = "insert into user(name,age) values('".$name."','".$age."')";这样写更简洁
$query = "insert into user(name,age) values('$name','$age')";
$result=mssql_query($query);这句话呢? 我用的sqlserver
<?php
// Send a select query to MSSQL
$query = mssql_query('SELECT [username], [name] FROM [php].[dbo].[userlist]');// Check if there were any records
if (!mssql_num_rows($query)) {
echo 'No records found';
} else {
// The following is equal to the code below:
//
// while ($row = mssql_fetch_row($query)) { while ($row = mssql_fetch_array($query, MSSQL_NUM)) {
// ...
}
}// Free the query result
mssql_free_result($query);
?>
$query = "insert into user(name,age) values($name,$age)";建议这样也试试