RE: [PHP-DB] Determine last quarter

If anyone is interested, this is what I finally came up with. I'm not sure how graceful it is, but it works ;) ? $quarter = ceil(date('n')/3); if ($quarter = 1) { $period_first_day = date(Y-m-d, mktime(0,0,0,10,1,date(Y)-1)); $period_last_day =

[PHP-DB] oracle-mysql

hi all, i need to migrate an oracle database (+-1gb) to a mysql one, but i don't have a clue how to do this. i'm thinking in dumping the whole content of the oracle database to a txt file but i don't know if there is a better way any ideias on this one. btw the oracle machine is running on

[PHP-DB] Copy distinct results to new table

Hi there everyone, How can I copy distinct results of a query to a table in a DB? I have 3 pulldowns, the first one selects the category, then the second one gets the holiday type based on the category, and the third one gets from countries where category = category AND holiday type =

[PHP-DB] Determine last quarter

If anyone is interested, this is what I finally came up with. I'm not sure how graceful it is, but it works ;) Here's another method... which can be condensed, but I left it expanded to demonstrate what was going on. The trick is finding the first day of the *next* month, and getting the

[PHP-DB] order by problem

Hello All, I´m having a 'problem' that I dont know how to resolve. The problem is: I have a table that I want to get the last number to increment. To do this I want to sort the filed 'ctrlnumber'. Using this query´s I get: mysql SELECT ctrlnumber FROM table WHERE id=14; ++ |

[PHP-DB] major performance disparities with mysql/php

Hello - I'm posted this to the mysql list but got no response. While it sounds like a mysql problem, I'm convinced that it is a PHP problem (see bottom of note.) I've recently installed mySQL on a RH7.2 box without any problems - it runs great. I've been testing some long running queries

Re: [PHP-DB] order by problem

Make CtrlNumber a numeric value instead of a string. =C= * * Cal Evans * Techno-Mage * http://www.calevans.com * - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, March 20, 2002 7:21 AM Subject: [PHP-DB] order by problem Hello All, I´m having a

Re: [PHP-DB] order by problem

On Wed, 20 Mar 2002 [EMAIL PROTECTED] wrote: You have your ctrlnumber field defined as varchar. If you define ctrlnumber as number, you could also use SELECT max(ctrlnumber) FROM table WHERE id=14; Cheers Urosh Hello All, Im having a 'problem' that I dont know how to resolve. The problem

[PHP-DB] Copy distinct results to new table solved

Hi there everyone, Just to let you all know I solved the problem I was having earlier - it's probably not the most elegant solution but hey, it works and it's very fast so I can't complain :-) Thanks to everyone in this group for your help on everything i've asked in the past (And will

Re: [PHP-DB] major performance disparities with mysql/php

Hank, i don´t know, but i thing the PHP have a time out for the PHP process and a time out for the MySQL connection, cause i a lot of people that don´t like to stay 70 seconds in front of computer :) probably have some way to extend the time out At 05:30 20/03/02 -0800, you wrote: Hello - I'm

[PHP-DB] Re: oracle-mysql

How many tables ? do you have the script that generated the oracle tables and their relationships ? what about the triggers, views, foreign keys, ... Are theses functionalities exist on MySQL (I don't know MySQL) ? You could have a look at Chyfo (http://www.ispirer.com/products/). Chyfo can

Re: [PHP-DB] elseif statement syntax

You probably have error reporting turned off in your php.ini file or you may be directing errors into your log file, try checking there. Why are you tacking or die(mysql_error()) on the end of each of your query assignments? You're just assigning a string to a variable so there's nothing to

[PHP-DB] PHP4 LDAP

Not sure if this is the right list for this, but I didn't see any others on the PHP web site that made sense... I'm using the following packages: php-common-4.1.2-1mdk php-4.1.2-1mdk mod_php-4.1.2-1mdk php-ldap-4.1.2-1mdk openldap-clients-2.0.21-1.1mdk openldap-servers-2.0.21-1.1mdk

[PHP-DB] PHP Linux performance vs. PHP Windows XP performance

Hi all. Anyone have experience/comments on the general performance of PHP (and perhaps MySQL) on Linux (e.g. RH 7.2) compared to that of Windows XP using the same hardware? Thanks. David -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] elseif statement syntax

Thanks for responding Steve, My error reporting is turned on, because I always get errors. I found the problem, I had two ;; at the end of one of the statements. Thanks- Andrea -Original Message- From: Steve Cayford [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 20, 2002 10:27 AM

[PHP-DB] Re: PHP4 LDAP

Just in case anyone was wondering, here's a bit more info. I'm not sure why some attributes show up the other way though: ? $baseDN = dc=mydomain,dc=com; $bindDN = uid=dumbuser,dc=mydomain,dc=com; $bindPass = mypass; $linkID = ldap_connect(ldapServer,ldapPort); if ($linkID) if