Wrong parameter count for mysql_query()
Her er mit script:#!/home/pkcn/php434/bin/php -q
<?
$link = mysql_connect("localhost","pkcn",211076);
mysql_select_db("pkcn_test",$link);
$sql = "SELECT kostplaner.userid, users.created from kostplaner, users where kostplaner.body='' AND kostplaner.userid=users.Id";
$result = mysql_query($sql)or die("QUERY: ".$sql." - MYSQL_ERROR: ".mysql_query());
while($array = mysql_fetch_array($result)){
$sql = "INSERT INTO waiting_dietplans SET userid='".$array[0]."', created='".$array[1]."', team='0'";
mysql_query($sql)or die("QUERY: ".$sql." - MYSQL_ERROR: ".mysql_query());
}
?>
Dette er fejlen jeg får:
<b>Warning</b>: Wrong parameter count for mysql_query() in <b>/home/pkcn/kp_update.php</b> on line <b>11</b><br />
QUERY: INSERT INTO waiting_dietplans SET userid='53', created='2004-01-25', team='0' - MYSQL_ERROR:
Hvad faen er der galt her ??