Hi,
Thanks all, I will do it with php function.
--
Marc Soler
> 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
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
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 pag
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 lo
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
retrieve
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:
$fields
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
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 auto_incr
hey,
you could do something like this
first_name: $first_name company: $company";
}
?>
From: [EMAIL PROTECTED]
To: Jonathan Haddad <[EMAIL PROTECTED]>
CC: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] DISTINCT and multiple results...
Date: Mon, 7 Jun 2004 14:05:41 +0100
Ah, but then how can I select
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 = mysql_list_fields("Netw
"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
Re
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 ta
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
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 doesn
[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
15 matches
Mail list logo