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

2001-07-03 Thread tony . mccrory
=mssql_fetch_array($id); $taskid will then be whatever mssql set your identity/autoincrement field to be. Regards, Tony -- Tony McCrory IT, Trinity Mirror group (Ireland) (028) 9068 0168 [EMAIL PROTECTED

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

2001-07-03 Thread tony . mccrory
to be. Regards, Tony -- Tony McCrory IT, Trinity Mirror group (Ireland) (028) 9068 0168 [EMAIL PROTECTED] Ryan Marrs rmarrs@strtrTo: '[EMAIL PROTECTED]' [EMAIL PROTECTED] ade.com cc

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

2001-07-30 Thread tony . mccrory
to that with a href=downloadimage.php?imagename=10293492.jpgcustomerid=11217Download Image/a Make sure the images are outside of your webservers document root. Then you can programatically decide whether to serve the image to the user. Removes the possibility of leeching the entire library.. Tony -- 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

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

RE: [PHP-DB] Store Procedures

2001-08-24 Thread tony . mccrory
on slashdot.org today... ;)

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

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

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 convert to