RE: [PHP-DB] Access to MySQL Conversion question

2001-10-19 Thread Tony McCrory
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

RE: [PHP-DB] RE: Excel to MySQL

2001-10-18 Thread Tony McCrory
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

RE: [PHP-DB] How to do this with PHP

2001-09-22 Thread Tony McCrory
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

RE: [PHP-DB] Store Procedures

2001-08-24 Thread tony . mccrory
on slashdot.org today... ;) http://software.tangent.org/article.pl?sid=01/08/23/0817244&mode=

RE: [PHP-DB] getting ID

2001-08-20 Thread tony . mccrory
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

[PHP-DB] Querying active directory from PHP

2001-08-14 Thread tony . mccrory
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

Re: [PHP-DB] Re: Image Bank with php & mysql!! ??!!

2001-07-30 Thread tony . mccrory
possibility of leeching the entire library.. Tony -- Tony McCrory IT, Trinity Mirror group (Ireland) (028) 9068 0168 [EMAIL PROTECTED] "Hugh Bot

Re: [PHP-DB] Issue with MSSQL_QUERY()

2001-07-03 Thread tony . mccrory
','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

Re: [PHP-DB] Issue with MSSQL_QUERY()

2001-07-03 Thread tony . mccrory
;,'12','13','1 4','15',''; $return=MSSQL_QUERY($query); $id=mssql_query("select @@IDENTITY as 'taskid'"); $taskid=mssql_fetch_array($id