原代码[code]//写入数据库
if($select)
echo "已选择数据库finance";
else
echo ('数据库选择失败'.mysql_error());
$myselect = mysql_select_db(finance,$link);
$sql = "INSERT INTO expenditure (categories,name,address,amount,totalamount,time) VALUES ($categories,$name,$address,$amount,$totalamount,$time)";
$result = mysql_query($sql) or die("<br>插入失败:".mysql_error());
[/code]
返回结果:
[code]
已选择数据库finance
插入失败:No database selected
[/code]
if($select)
echo "已选择数据库finance";
else
echo ('数据库选择失败'.mysql_error());
$myselect = mysql_select_db(finance,$link);
$sql = "INSERT INTO expenditure (categories,name,address,amount,totalamount,time) VALUES ($categories,$name,$address,$amount,$totalamount,$time)";
$result = mysql_query($sql) or die("<br>插入失败:".mysql_error());
[/code]
返回结果:
[code]
已选择数据库finance
插入失败:No database selected
[/code]
//写入数据库
if($select)
echo "已选择数据库finance";
else
echo ('数据库选择失败'.mysql_error());
$myselect = mysql_select_db(finance,$link);
$sql = "INSERT INTO expenditure (categories,name,address,amount,totalamount,time) VALUES ($categories,$name,$address,$amount,$totalamount,$time)";
$result = mysql_query($sql) or die("<br>插入失败:".mysql_error());
已选择数据库finance
插入失败:No database selected
INSERT INTO finance.expenditure (categories,name,address,amount,totalamount,time) VALUES ($categories,$name,$address,$amount,$totalamount,$time)";
use finance;
然后再执行语句
它找不到你的数据库。
$result = mysql_query($sql,$select ) or die(" <br>插入失败:".mysql_error());