function sms_log ($send_user,$toPhone,$msg,$date,$pub)
{
$msg_log_sql="INSERT INTO `norveldatabase`.`sms_log` (`send_user`,`toPhone`,`msg`,`date`,`pub`) VALUES ( ('$send_user','$toPhone','$msg','$date','$pub') ";
if (!mysql_query($msg_log_sql,$conn))
{
die('Error: ' . mysql_error());
}
else
{
echo "<br> 短信发送记录成功 <br>";
}}运行后总是 error
{
$msg_log_sql="INSERT INTO `norveldatabase`.`sms_log` (`send_user`,`toPhone`,`msg`,`date`,`pub`) VALUES ( ('$send_user','$toPhone','$msg','$date','$pub') ";
if (!mysql_query($msg_log_sql,$conn))
{
die('Error: ' . mysql_error());
}
else
{
echo "<br> 短信发送记录成功 <br>";
}}运行后总是 error
Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\test\inc\function.php on line 21
Error:21就是if (!mysql_query($msg_log_sql,$conn)) 这行
========================
VALUES后面怎么跟着两个括号呢?
echo $msg_log_sql;
2.echo 出sql语句,检查是否有误。
Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\test\inc\function.php on line 21
INSERT INTO sms_log (send_user,toPhone,msg,date,pub) VALUES ( 'zhenghua','13572421557','test','2009-05-11','')
require_once("mysqlconn.php");
function sms_log ($send_user,$toPhone,$msg,$date,$pub)
{
global $conn;
$msg_log_sql="INSERT INTO `norveldatabase`.`sms_log` (`send_user`,`toPhone`,`msg`,`date`,`pub`) VALUES ('$send_user','$toPhone','$msg','$date','$pub') "; if (!mysql_query($msg_log_sql,$conn))
{
die('Error: ' . mysql_error());
}
else
{
echo " <br> 短信发送记录成功 <br>";
}} 如果以上都出错,说明函数外,你的sql连接就没有成功。