[PHP] mysql insert internal server error 500

2011-05-16 Thread Grega Leskovšek
$ime=$_COOKIE['user'];
$dolgF=filesize($filename)
INSERT INTO `friendlyCMS`.`log` (`imepriimek`, `clock`, `action`,
`onfile`, `filesize`) VALUES ( $ime, CURRENT_TIMESTAMP,
'saved',$filename, $dolgF);

What is wrong with this?
PS First column of the log table is idlog primary key autoincrement
not null - I suppose I omit this when adding to table?
Thanks in advance, Grega
-- When the sun rises I receive and when it sets I forgive ->
http://moj.skavt.net/gleskovs/
Always in Heart, Grega Leskovšek

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] mysql insert internal server error 500

2011-05-16 Thread Bálint Horváth
I think it's not the best place to send it but:
$dolgF is not closed with ; ...and the insert is not in a variable!

(And also I think it's not a good way using COOKIE in PHP because we have
sessions)

So the answer is: the all.. :D -or what's the full part you use for insert
int this source!?

On Mon, May 16, 2011 at 5:11 PM, Grega Leskovšek  wrote:

> $ime=$_COOKIE['user'];
> $dolgF=filesize($filename)
> INSERT INTO `friendlyCMS`.`log` (`imepriimek`, `clock`, `action`,
> `onfile`, `filesize`) VALUES ( $ime, CURRENT_TIMESTAMP,
> 'saved',$filename, $dolgF);
>
> What is wrong with this?
> PS First column of the log table is idlog primary key autoincrement
> not null - I suppose I omit this when adding to table?
> Thanks in advance, Grega
> -- When the sun rises I receive and when it sets I forgive ->
> http://moj.skavt.net/gleskovs/
> Always in Heart, Grega Leskovšek
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>