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

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
Thanks. NOW() and php date(); work for my newly created test tables, but it doesn't work for my working table. I can't insert date, time or now() into my old table (which is as below). For now, I'm using MySQL auto timestamp ('Updated' field), but I need to insert date

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

backup database

2004-10-09 Thread php mysql
I need to move one database with 5 tables to another box. What files I should copy? I use MYSQL 3.23.58. TH -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

encoding & decoding

2004-09-26 Thread php mysql
I use mysql version 3.23.58. I want to use 'decode' and 'encode' functions: http://dev.mysql.com/doc/mysql/en/E..._functions.html Using password I can decode and encode data in mysql. Below is my queries that return nothing: #1 create table. #2 insert data using encode function #3 trying to selec

REPAIR TABLE f_ivairus_bodies;

2004-06-01 Thread php
k/repair | +++--++ 1 row in set (0.00 sec) Thanks very much. Best regards, php mailto:[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: MySQL process increasing problem..

2003-11-06 Thread Jobs PHP Workshop
uot; -Original Message- From: Matt W [mailto:[EMAIL PROTECTED] Sent: Thursday, November 06, 2003 7:22 AM To: Jobs PHP Workshop; [EMAIL PROTECTED] Subject: Re: MySQL process increasing problem.. Hi, Yes, in top, those are threads not processes, as Gerald already said. Not that it reall

MySQL process increasing problem..

2003-11-05 Thread Jobs PHP Workshop
Hi, Problem is, Mysql server in our production machine keeps spawning child processes and it reaches to a level where mysql hangs and the only solution is to restart our mysql server. I have checked all the databases using "mysqlcheck" command and every table is OK now. Recently, MySQL server suffe

Cannot Access mysql database

2001-10-31 Thread PHP Nut
TED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Challenging SQL Problem

2001-06-30 Thread PHP Webmaster
ahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

afraid of using mysql!

2001-02-11 Thread php php
d to Asp with Oracle or access but i'm afraid of using mysql! is it difficult ? can u point me to sites that include all mysql data type, like memo, automatic numbers etc i have already tried php with access, it works , thwn with oracle , it does not work and as long a s i'm in hurry of