[PHP-DB] php-db-unsubscribe@lists.php.net

[EMAIL PROTECTED] Christopher Jones wrote: Philippe wrote: Well, the exact message is: Unable to load dynamic library php_oci8.dll: The specified procedure could not be found If I remove the library the message becomes The specified module could not be found. It seems to be able to find the

[PHP-DB] DISTINCT and multiple results...

Hi there... I'm trying to create a MYSQL query that does the following... I've a table that lists ALL downloads from our site. so I may have the same user many times, but different files, or infact, same user, same file. What my boss wants to see is: If a user downloaded a file 3 times, she

Re: [PHP-DB] DISTINCT and multiple results...

It really is that simple?!?!?! Wow... I need to do a MySQL course... Jonathan Haddad [EMAIL PROTECTED] 07/06/2004 13:39 To [EMAIL PROTECTED] cc [EMAIL PROTECTED] Subject Re: [PHP-DB] DISTINCT and multiple results... select distinct email, username from table On Jun 7, 2004, at 8:19

Re: [PHP-DB] DISTINCT and multiple results...

Ah, but then how can I select other info from the same table (title, first name, company etc...) Jonathan Haddad [EMAIL PROTECTED] 07/06/2004 13:39 To [EMAIL PROTECTED] cc [EMAIL PROTECTED] Subject Re: [PHP-DB] DISTINCT and multiple results... select distinct email, username from

Re: [PHP-DB] DISTINCT and multiple results...

Tristan Pretty [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] com... Ah, but then how can I select other info from the same table (title, first name, company etc...) Just add all the required fields to your select statement: SELECT DISTINCT email, title, company FROM table

[PHP-DB] Dynamic Data

What is the best way to produce a report listing the fieldname and then the data in that field. It is a report containing only one row from a table, but I don't want to hard code the fields since they change often. I can get the field names dynamically like this: $fields =

Re: [PHP-DB] DISTINCT and multiple results...

hey, you could do something like this ?php $query = SELECT * FROM `table` Group by email; $query_count++; $result = mysql_query ($query); while ($row = mysql_fetch_assoc ($result)) { $title = $row[title]; $first_name= $row[first name]; $company = $row[company]; echotitle: $title br

[PHP-DB] About retrieving auto increment value

Hi I have the typical problem with retrieving auto increment value in php-mysql environment. I have search info in mysql page and I have found LAST_INSERT_ID() funtion but I don't know how to use correctly. I have one script that insert a row. And another script that must retrieve last

Re: [PHP-DB] About retrieving auto increment value

I think you want mysql_insert_id() http://us3.php.net/manual/en/function.mysql-insert-id.php I have the typical problem with retrieving auto increment value in php-mysql environment. I have search info in mysql page and I have found LAST_INSERT_ID() funtion but I don't know how to use

[PHP-DB] Re: Dynamic Data

Christopher J. Crane wrote: What is the best way to produce a report listing the fieldname and then the data in that field. It is a report containing only one row from a table, but I don't want to hard code the fields since they change often. I can get the field names dynamically like this:

[PHP-DB] Re: About retrieving auto increment value

Marc Soler wrote: Hi I have the typical problem with retrieving auto increment value in php-mysql environment. I have search info in mysql page and I have found LAST_INSERT_ID() funtion but I don't know how to use correctly. I have one script that insert a row. And another script that must

Re: [PHP-DB] Error loading module: Unable to load dynamic library

Thank you, that got me in the right direction. The OCI.DLL file on my system was an older version and dependency walker determined this. After that it was a simple matter of finding the right file version. Thanks! Christopher Jones wrote: Philippe wrote: Well, the exact message is: Unable to

[PHP-DB] Load data infile problem

Hello, I have a page with a button that when clicked loads a pre-determined text file into my database. The code is posted below. However, when clicked the button does nothing, just opens up the same page again. The data does not get loaded into the database. any ideas? Thanks Justin The

RE: [PHP-DB] Load data infile problem

Actually, I have just figured it out. It had to do with the 'slashes' around the query. The original $sql code was created using phpmyadmin, but I messed around with it until it worked, now using the following query: mysql_query(LOAD DATA INFILE 'C:abc.txt' INTO TABLE abc FIELDS TERMINATED BY