Re: [PHP-DB] Re: Maximum field length with PHP 4.1.2/MSSQL v7 ?

Hi, now I rewrote my PHP-DB-Module using COM and ADO (OLEDB), it works well, the 255 Bytes limitation doesen't exist with this method, but uff it takes a lot of memory, after openening the db-connection, the php-process increases his memory usage with about 4 MB, this seems to be a problem

[PHP-DB] how to ?

how to ? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] searching for a software

Iv been trying to find an open source software that would calculate the number of data retrievals (from certain fixed IPs)from MySQL database. Any idea where I could find such a script? Henri -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:

[PHP-DB] looking for a script

Iv been trying to find an open source software that would calculate the number of data retrievals (from certain fixed IPs)from MySQL database. Any idea where I could find such a script? Henri -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:

[PHP-DB] tables/columns with spaces

Someone, in their infinite wisdom, named some, not all of course, tables and columns with spaces, i.e. BUSINESS AREA in a SQL server database that i am working with. You can run lots of queries that return fine, but when I run a query such as select * from REQ where BUSINESS AREA = '$var', i

RE: [PHP-DB] tables/columns with spaces

[] is the correct notation for both tables and columns. I don't ever recommend using spaces in anything, file names, tablenames, or anything else that will bite you later. But that is the correct syntax, so there may be another problem. Maybe BUSINESS AREA is numeric? Ryan -Original

RE: [PHP-DB] tables/columns with spaces

Don't i agree! I didn't create this database. and I don't use spaces for anything. that is always good pracice, but since these folks had...here is what i found. The [ ] notation, works fine on tables, i.e. [BUSINESS AREA] but when you have a column with a space then use this notation

Re: [PHP-DB] Ordering question .....

Hi Bogdan et al... Thanks! I've got that going now. I'm sure that I'll have more questions for you as I work on it. In fact here's one now! echo($myrow[1] $myrow[2]br\n); In the line above, how can I get a tab to work? I tried \t but that did not work. Also the \n does not work on this

RE: [PHP-DB] Ordering question .....

/t is a tab, however tabs won't show up in HTML, you'll have to use something like: nbsp;nbsp;nbsp;nbsp;nbsp; Ryan -Original Message- From: Jim Hatridge [mailto:[EMAIL PROTECTED]] Sent: Friday, May 10, 2002 10:03 AM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Ordering question .

RE: [PHP-DB] Ordering question .....

BTW... if you're going for an outline effect, you may want to look into ul or ol (unordered and ordered lists) lifirst/ li lisecond/ li lithird/ li / ul Ryan -Original Message- From: Ryan Jameson (USA) Sent: Friday, May 10, 2002 10:15 AM To: [EMAIL PROTECTED] Subject: RE: [PHP-DB]

[PHP-DB] stmt should return user-id only once. difficult select statement.

Hi there, I have a huge statement doing a calculation and returning a userid with a ranking. This workes fine for one table. But due to normalisation I do have 2. table containing languages of the users. Up to 3 languages for each user. The problem is, that I do get the same user 3 times with

RE: [PHP-DB] stmt should return user-id only once. difficult select statement.

This may only be preference but you've mixed join syntaxes here, it would be easier to read if you stuck with just one. Anyway, I think what you'll want is to max the whole expression. So, keep the group by, but use max (if(u.country='gm',25,0) + if(u.age='4',25,0) +

Re: [PHP-DB] stmt should return user-id only once. difficult select statement.

unfortunatelly not. I did already try this. It does not make a difference. Still three results for each user do you have another idea? thanks, Andy Ryan Jameson [EMAIL PROTECTED] schrieb im Newsbeitrag [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... This may only be preference but you've mixed

[PHP-DB] error loading libifgen.so

I'm trying to use PHP with Informix support. If I use Apache with dynamic modules, I get the following error when I try to load the Apache server: Cannot load /usr/local/apache/libexec/libphp4.so into server: /opt/informix/lib/esql/libifgen.so: undefined symbol: stat Apache loads if I use

RE: [PHP-DB] stmt should return user-id only once. difficult select statement.

That's only when they have a different language_id... the group by needs to have just user_id if you want to guarantee one user_id. GROUP BY u.user_id, l.language_id -Original Message- From: andy [mailto:[EMAIL PROTECTED]] Sent: Friday, May 10, 2002 12:07 PM To: [EMAIL PROTECTED]

[PHP-DB] autoincrement start with higher number

Is it possible to have an autoincrement field start with a number, so the first record would be, let's say, 1000 instead of 1? The next would be 1001 instead of 2, etc. kind regards, bill hollett -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:

Re: [PHP-DB] autoincrement start with higher number

Hello!! ALTER TABLE Table1 AUTO_INCREMENT = 1000; Dan On Friday, May 10, 2002, at 04:36 PM, [EMAIL PROTECTED] wrote: Is it possible to have an autoincrement field start with a number, so the first record would be, let's say, 1000 instead of 1? The next would be 1001 instead of 2, etc.

Re: [PHP-DB] stmt should return user-id only once. difficult select statement.

I agree, you are right, but that does not take me closer to the solution. So if I leave out the language_id in the group by statement I do get only the first language_id counted. Example: language table: language_id | user_id hr20 en20 gm

[PHP-DB] Does mysql_connect() perform password encryption?

Hello, Gurus, Sorry for this type of question but I can't find this info neither in MySQL manual, nor in PHP docs. To my understanding, when I call mysql_connect() and provide password php interpreter does password encryption, then opens socket to remote mysqld daemon and sends him encrypted

RE: [PHP-DB] stmt should return user-id only once. difficult select statement.

I may be confused as to what you're looking for, however I can tell you that the group by is done after the result set is created, hence the where clause is processed. So, if you search for where u.country = 'hr' then you will only ever get 'hr' in the country field after the group by is

[PHP-DB] Where to get MySQL help

I may need to convert an Interbase program to MySQL and I have some questions about MySQL. Todd -- Todd Cary Ariste Software 2200 D Street Extension Petaluma, CA 94952 707-773-4523 [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:

Re: [PHP-DB] Where to get MySQL help

On 10 May 2002 at 17:24, Todd Cary wrote: I may need to convert an Interbase program to MySQL and I have some questions about MySQL. http://www.mysql.com/ would probably be a good place to start. -- Stuart -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:

Re: [PHP-DB] Does mysql_connect() perform password encryption?

On Saturday 11 May 2002 06:25, alex wrote: Hello, Gurus, Sorry for this type of question but I can't find this info neither in MySQL manual, nor in PHP docs. To my understanding, when I call mysql_connect() and provide password php interpreter does password encryption, then opens socket