AW: [PHP-DB] Re: Table to BIG to dump, how ?

2001-12-18 Thread Thomas Lamy
Hi, If it's a php script dumping the data, have a look at the "max_execution_time" config variable. IIRC the default is 30 seconds, which you can override from within the running script with ini_set ("max_execution_time", 10); Hope this helps. Thomas > -Ursprüngliche Nachricht- > V

AW: [PHP-DB] Pictures+MySQL+PHP

2002-01-27 Thread Thomas Lamy
> -Ursprüngliche Nachricht- > Von: Michael Waples [mailto:[EMAIL PROTECTED]] > Gesendet: Samstag, 26. Januar 2002 09:54 > An: [EMAIL PROTECTED] > Betreff: Re: [PHP-DB] Pictures+MySQL+PHP > > > Ck Raju wrote: > > > > that I changed my mind. Gurhan Ozen>Storing images in the > databas

AW: [PHP-DB] strange behavior

2002-09-12 Thread Thomas Lamy
Hi, this isn't essantially DB-related It's a feature called transparent session id (activated at compile time with --enable-trans-sid). No need for in most cases, as it is automatically added by PHP. And for the few times PHP can not add session information, you may use the SID define, which

AW: [PHP-DB] Large files using phpMyAdmin

2002-09-22 Thread Thomas Lamy
Hi, 1. Problem (Uploads) Have a look at your php.ini, max_upload_size is 2 MB per default, you may wish to increase this. Not sure if phpMyAdmin has another parameter to configure this... 2. Problem (pics messed up) Seems to be some magic quotes problem. In your php.ini, check magic_qoutes_gpc a

AW: [PHP-DB] getting mysql_fetch_row into array

2002-09-23 Thread Thomas Lamy
Hi, it would have been easier to help you if you included some code snippet... Use something like this: $res = mysql_query ("SELECT COUNT(deptid) FROM maintenance GROUP BY deptid"); $deptcount = array(); // reset the array while ($row = mysql_fetch_row ($res)) { $deptcount[] = $row[0]; }

Re: [PHP-DB] export to csv file

2002-09-28 Thread Thomas Lamy
Diana Castillo [mailto:[EMAIL PROTECTED]] wrote: > > Hi, I want to export some fields on a regular basis from a > table to a text > file, preferable to the users local computer. I tried writing > to a file with > fopen but I get "permission denied" when I try to open it for writing. > What is t

AW: [PHP-DB] error_reporting()

2002-09-30 Thread Thomas Lamy
Do you have display_errors = On in your php.ini ? Ryan Jameson (USA) wrote: > > I do the following > > error_reporting(E_ALL); > echo error_reporting(); > ?> > > and it says 2047 and still reports no errors. What overrides > my setting? > > Thanks... > <>< Ryan -- PHP Database Mailing Li

Re: [PHP-DB] Error query : mysql_result

2002-10-10 Thread Thomas Lamy
Burgess [mailto:[EMAIL PROTECTED]] wrote: > Hi > > I have used the mysql_result function to return some specific > information > from database. The information is returned as it should but > I keep getting > this error message: > > Warning: Unable to jump to row 0 on MySQL result index 4 in

AW: [PHP-DB] OT...where do I go for this......?

2002-10-10 Thread Thomas Lamy
Have you checked apache's config file for: AddType application/x-httpd-php .php AddType application/x-httpd-php .php4 AddType application/x-httpd-php-source .phps ? IIRC Apache denies POST to file types not registered for... Also it may be possible that your OS upgrade has overwritten your (ol

Re: [PHP-DB] update and join?

2002-10-10 Thread Thomas Lamy
Cory Hicks [mailto:[EMAIL PROTECTED]] wrote: > Hello to all! > > Quick questionis it possible to do an update query w/ a > join yet? If not, what is your preferred method? Would you > take care of it on the PHP side? No, it's not possible, at least not with MySQL 3.x. MySQL 4.1, currently i

Re: [PHP-DB] easier way to do this? (time interval)

2002-10-11 Thread Thomas Lamy
Hi, convert your date to UNIX_TIMESTAMP, which is number of seconds since 1.1.1970, and you can use simple math, as in $query=mysql_query(" SELECT dtg FROM techs WHERE tech='$user' AND UNIX_TIMESTAMP(dtg) > UNIX_TIMESTAMP(NOW()) - 86400 AND HOUR(dtg)>=

Re: [PHP-DB] catalog system

2002-10-21 Thread Thomas Lamy
t; not asking to > build it for me. Thought I'd try and learn from one and make my own. > > If someone will point me to the Nubee-forum, I will gladly go. > > Wannabe > > > "Thomas Lamy" <[EMAIL PROTECTED]> wrote in message > news:656F04F343FC2540946

Re: [PHP-DB] catalog system

2002-10-21 Thread Thomas Lamy
Doesn't seem so. Wannabes/Leechers never die. They haven't really understood what this media ought to be. Most of the time it's faster (and wiser) to switch brain on for at least ten minutes, rather than surfing beginner's guides for hours. Otherwise get yourself some training day(s). Really. [N

Re: [PHP-DB] Idea as to why this query won't work as expected?

2002-11-05 Thread Thomas Lamy
Dave Smith [mailto:DavidSmith@;byu.net] wrote: > > I can never remember whether SQL is left-to-right, right-to-left, or > some other deviant. Using parens is a sure way to guarantee that your > statements are processed in the order you desire. > > --Dave > It's easy if you remember: AND is equ

Re: [PHP-DB] ROugh idea of speed

2002-11-09 Thread Thomas Lamy
Steve Vernon [mailto:steve@;extremewattage.co.uk] wrote: > > Hiya, > Just wondering what is the rough idea of speed of a > server like this is > holding a database with millions of records. I know its > difficult, depends > on the data stored etc. > > Its basically storing an index int a

AW: [PHP-DB] Concurrent update to database (PostgreSQL or MySQL) ??

2001-04-18 Thread Thomas Lamy
Another way is to keep another unique value inside the table to be updated and remember it. When needed, I add a second unique column to the table (in my case a char(64)) which is filled with the current timestamp and some md5 checksum. I select this value before the update, pass it along with the

AW: AW: [PHP-DB] Concurrent update to database (PostgreSQL or MySQL) ??

2001-04-18 Thread Thomas Lamy
above and could become a CON because > it could mean > that programmers can list unnecessary fields in the UPDATE > statement, which > is unnecessary network traffic. I prefer to update complete sets of data (as long as it's not against performance, like updating some large BLOB

AW: [PHP-DB] Variable passing

2001-04-24 Thread Thomas Lamy
> Johannes Janson [mailto:[EMAIL PROTECTED]] wrote: > > You can output the passed varibles from the previous page > in an in the form of the following page. > > Johannes > But be sure to urlencode() your data before putting in the hidden fields, and decode them when you enter the next page. T

AW: [PHP-DB] syntax error - -- agghhh!

2001-04-24 Thread Thomas Lamy
> Marc S. Bragg [mailto:[EMAIL PROTECTED]] wrote: > > Hi > > Anyone have any idea of what the syntax error in this statement is? > > else if (($op == "ds") && ($action == "sub") && ($password == > $passnog) > && ($password) && > (!eregi("^([a-z0-9_]|\\-|\\.)+@(([a-z0-9_]|\\-)+\\.)+[a-z]{2,4 >

Re: [PHP-DB] Retrieving Rows - Can I Change The Order?

2001-07-28 Thread Thomas Lamy
> Von: Caleb Walker [mailto:[EMAIL PROTECTED]] > Gesendet: Samstag, 28. Juli 2001 08:26 > An: Dave Watkinson; PHP-MySQL List > Betreff: Re: [PHP-DB] Retrieving Rows - Can I Change The Order? > > > > > Now then, I have changed a column in the table, and the > only way I found to > > change a da