select max(idfield) from table
> -Original Message-
> From: Brad Harriger [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, October 18, 2001 7:32 PM
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] Access to MySQL Conversion question
>
>
> I have several MS Access databases that I need to conve
You could try the MyODBC driver. On the www.mysql.com website I think.
Then you won't need CSV or any other type of import file.
Tony
> -Original Message-
> From: Mikusch, Rita [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, October 17, 2001 5:05 PM
> To: [EMAIL PROTECTED]
> Subject: [PHP
Does anyone know how to achieve this using non-mysql servers? subqueries?
-Original Message-
From: Rick Emery [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 21, 2001 7:48 PM
To: '[EMAIL PROTECTED]'; [EMAIL PROTECTED]
Subject: RE: [PHP-DB] How to do this with PHP
SELECT * FROM mytab
on slashdot.org today...
;)
http://software.tangent.org/article.pl?sid=01/08/23/0817244&mode=
With MSSQL I do:
$result=mssql_query("select @@IDENTITY as 'jobNumber'");
$row=mssql_fetch_array($result);
$insertid=$row[jobNumber];
May be similar for sybase.. I understand they have similar origins..
Tony
Has anyone done anything with Windows 2000 Active Directory from PHP? I'd
quite like to try this out but I haven't been able to get anything to work!
To begin with I'd like to query basic attributes like user name, phone
number, email address
Any info/pointers whatsoever would be appreciated
possibility of leeching the entire library..
Tony
--
Tony McCrory
IT, Trinity Mirror group (Ireland)
(028) 9068 0168
[EMAIL PROTECTED]
"Hugh Bot
','15','';
$return=MSSQL_QUERY($query);
$id=mssql_query("select @@IDENTITY as 'taskid'");
$taskid=mssql_fetch_array($id);
$taskid will then be whatever mssql set your identity/autoincrement field
to be.
Regards,
Tony
--
Tony McCrory
IT, Trinity Mirror
;,'12','13','1
4','15','';
$return=MSSQL_QUERY($query);
$id=mssql_query("select @@IDENTITY as 'taskid'");
$taskid=mssql_fetch_array($id