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

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

AW: [PHP-DB] Variable passing

Johannes Janson [mailto:[EMAIL PROTECTED]] wrote: You can output the passed varibles from the previous page in an input type=hidden 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

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

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 }$,$email)) { It

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

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 data type is

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

-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 OzenStoring images in the database is not a

AW: [PHP-DB] strange behavior

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 ?=session_name().'='.session_id()? in most cases, as it is automatically added by PHP. And for the few times PHP can not add session information,

AW: [PHP-DB] Large files using phpMyAdmin

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

AW: [PHP-DB] getting mysql_fetch_row into array

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]; }

AW: [PHP-DB] error_reporting()

Do you have display_errors = On in your php.ini ? Ryan Jameson (USA) wrote: I do the following ?PHP 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 List

Re: [PHP-DB] Error query : mysql_result

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......?

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

Re: [PHP-DB] update and join?

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 in

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

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)=7

Re: [PHP-DB] catalog system

. 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:656F04F343FC25409463829A15B5FDDC08AFC4;netwake-nt.netwake.de... Doesn't seem so. Wannabes/Leechers never die

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

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 equal to

Re: [PHP-DB] ROugh idea of speed

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 and about