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 >

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: http://ww

[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: http://www.php.net/

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 proces

[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 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] Re: ?!? wats wrong?

Hi Peter, Just a shot in the dark, but make sure that everything is correct case-sensitive wise. I know this has caused me grief in the past. J. Wharton "Peter Roescher" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED]... > I have a mysql query like this > > SELECT * FROM personen WE

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

[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: http://www.php.net/uns

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] Subj

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

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 mixe

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) + if(u.sex='2',2

[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 a

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

BTW... if you're going for an outline effect, you may want to look into or (unordered and ordered lists) first second third <>< Ryan -Original Message- From: Ryan Jameson (USA) Sent: Friday, May 10, 2002 10:15 AM To: [EMAIL PROTECTED] Subject: RE: [PHP-DB] Ordering question .

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

/t is a tab, however tabs won't show up in HTML, you'll have to use something like:   <>< 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 . Hi Bogdan et al.

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]\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] 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 [BU

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

[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 ge

[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: http://www.php.net/unsub.p

[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: http://www.php.net/unsub

[PHP-DB] how to ?

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

Re: [PHP-DB] increase PHP performance

Well, Georg, what is probably the slowest link here is the ADODB connection. One of the great things with PHP is that you have native support for a lot of DBs built-in or available as separate DLLs. You should really look into using this for your DB connections instead of using the MS method,