AW: [PHP-WIN] error in insert function
| From: | (Sven Schnitzke) | Date: | Mon, 19 May 2003 13:44:48 +0000 |
| Subject: | AW: [PHP-WIN] error in insert function | ||
| Groups: | php.windows | ||
| Request: | Send a blank email to php-windows+get-20002@lists.php.net to get a copy of this message | ||
Hi Anders,
> ...
> mysql_query($q,$db1) or die ("ERROR IN - add_menu_db function");
> ...
would you mind reworking your script like
...
if ( ! mysql_query($q,$db1)) {
echo 'ERROR ' . mysql_errno() . ': ' . mysql_error() . ' IN -
add_menu_db function.';
die('Can not recover - sorry !';
}
...
and take a look at the complaint MySQL has about your query?
Cheers,
Sven
> -----Ursprüngliche Nachricht-----
> Von: A. Mikkelsen [SMTP:a__mikkelsen@hotmail.com]
> Gesendet am: Montag, 19. Mai 2003 15:08
> An: php-windows@lists.php.net
> Betreff: [PHP-WIN] error in insert function
>
> Hi
>
> I'M stuck
>
> Can anyone help.
>
> I'm trying to call a function :
>
> $lev_date = '190303';
>
> add_menu_db($location,$lev_date,$wm_id,$payroll_no,$order_menu[0]['text'],$o
> rder_menu[0]['price'],$amount);
>
> The function :
>
> function
> add_menu_db($loc_no,$lev_date,$wm_id,$payroll_no,$line_text,$price,$amount)
> {
> global $db1;
> $q = "
> INSERT INTO invoice
> (loc_id, lev_date, wm_id, payroll_no, line_text, price, amount)
> VALUES
> ($loc_id, '$lev_date', '$wm_id', $payroll_no, '$line_text',
> $price,
> $amount)
> ";
> mysql_query($q,$db1) or die ("ERROR IN - add_menu_db function");
> }
>
> I get a error but it works if in a promt writes :
>
> INSERT INTO invoice
> (loc_id, lev_date, wm_id, payroll_no, line_text, price, amount)
> VALUES
> (1, "190303", "wmtester", 19999, "text", 10 ,2)
>
>
> CAN ANYONE HELP ?????????+
> _____________________________
> Anders Mikkelsen
> A. Mikkelsen
> Telefon +45 21717224
> mailto:am@amikkelsen.com
>
>
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>