Re: What if the user closes the browser while INSERT INTO MySQL? (PHP/MySQL)

2010-04-17 Thread Antonio PHP
Well... just summarizing my thread here. I tested this today. As Carsten mentioned... Without the function 'ignore_user_abort(true);', when the browser is closed the script will stop at some point (if there's output ('echo etc') of certain number (1,000s) of characters remaining.). Many Thanks

What if the user closes the browser while INSERT INTO MySQL? (PHP/MySQL)

2010-04-16 Thread Antonio PHP
This maybe a newbie question. Consider the following concept, ~/index.php #1. Fetch data from an external webpage using PHP Curl; #2. Preg_match/Prepare Data to INSERT from local MySQL; - this may take a few secs #3. While Loop { INSERT data (from #2) into local MySQL } - this may take only mili

Re: Now() : SQL syntax error. But why?

2009-04-30 Thread Antonio PHP
rote: > > On Apr 29, 2009, at 11:29 AM, Antonio PHP wrote: > > This is MySQL data structure. - I underlined where it causes the error >> message. (datetime) >> `id_Company` smallint(6) unsigned NOT NULL AUTO_INCREMENT, >> `Name` varchar(50) CHARACTER SET utf8 COLLATE

Re: Now() : SQL syntax error. But why?

2009-04-29 Thread Antonio PHP
e query and the table structure. timestamp fields > can have options set to auto update them, where order matters, and only one > field can support that feature. > > Please supply more data. > > > On Apr 28, 2009, at 2:18 PM, Antonio PHP wrote: > > You have an error in your

Now() : SQL syntax error. But why?

2009-04-28 Thread Antonio PHP
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Created = NOW(), Updated = NOW()' at line 8 'Created' and 'Updated' are set to datetime (InnoDB). The same syntax works for some newly created tables... and gives