Re: [PHP-DB] Question about database design

to contain a where clause (active_ind = 'Y') to keep the old rows from showing up. I hope this helps. Tony On 10/24/07 7:30 AM, Bastien Koert [EMAIL PROTECTED] wrote: I would approach this by having a main people table (with a unique id of course) and then create a second addresses table which uses

[PHP-DB] PG: Table last updated?

We've got a huge table in one of our Postgres databases and nobody seems to know what it's for. Do any of the system tables keep track of the last time the table was altered (i.e. Row INSERTs, UPDATEs, etc)? Tony -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http

Re: [PHP-DB] PG: Table last updated?

I'm not sure. How can I tell? This database is running on a different server than the one that created the data. I'm trying to restore a fried server from a backup. Not sure if that matters. Tony On 10/23/07 6:20 PM, Bastien Koert [EMAIL PROTECTED] wrote: Is logging turned on? bastien

Re: [PHP-DB] Remote DB Connection: Pros and Cons?

Thank you all for the responses. I think we're going to try replicating the databases with Slony. Wish me luck! Tony On 10/11/07 6:23 PM, Chris [EMAIL PROTECTED] wrote: Tony Grimes wrote: Splitting the tables probably wouldn't work. Most of the tables are used by both sites and the ones

[PHP-DB] Remote DB Connection: Pros and Cons?

database remotely? Is there any other way to do this? Tony -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Remote DB Connection: Pros and Cons?

by remote connection would be easier, but we're worried about the performance. Tony On 10/11/07 6:01 PM, Chris [EMAIL PROTECTED] wrote: Tony Grimes wrote: Have any of you tried running a PHP website using a remote database connection? We currently have an in-house PHP website driven

[PHP-DB] MySQL BETWEEN Problems

expect it? What am I doing wrong? Tony -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] MySQL BETWEEN Problems

PM, Dan Shirah [EMAIL PROTECTED] wrote: So just change it to WHERE last_name BETWEEN 'A' AND 'G' . That'll get you Aa-Fz :) On 5/18/07, Tony Grimes [EMAIL PROTECTED] wrote: We tried that and it didn't work. We've also tried every combination of upper and lower case too. Tony

Re: [PHP-DB] MySQL BETWEEN Problems

Nice! That did the trick. Thanks Brad. I live to fight another day. Tony On 5/18/07 3:00 PM, Brad Bonkoski [EMAIL PROTECTED] wrote: Try using the substr, since you are only comparing the first letters... (sorry I did not reply all on the other email, Dan) i.e. select name from users

Re: [PHP-DB] Include function across servers

are outside of the route directory then that means only the local files can all them and execute them, right?? thanks tony My email address has changed. It is now [EMAIL PROTECTED] Visit my website - Original Message

Re: [PHP-DB] Include function across servers

thanks for your reply. that's what i figured using common sense, but that's not always the case with software. cu tony My email address has changed. It is now [EMAIL PROTECTED] Visit my website - Original

[PHP-DB] MySQL sort stopped working

is omitted (as if I clicked 'browse' in phpMyAdmin). The SQL works in phpMyAdmin, and the site uses PEAR::DB. We patched the server last week, but the problem showed up this morning. Anyone have any ideas on what could be causing this? Thanks in advance, Tony -- PHP Database Mailing List (http

Re: [PHP-DB] array field type

. -- Tony Marston http://www.tonymarston.net http://www.radicore.org I just want to know is there any way to keep array data type natively in a sql field. Regards. Sancar -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] SQL Performance Help

start_time BETWEEN point_a AND point_b Or should I just try caching the data in PHP? Would an index help? I realize any answers might be complicated, but if you could just point me in the right direction, I can probably figure the rest out. Thanks, Tony -- PHP Database Mailing List (http

Re: [PHP-DB]: small question php/postgreSQL

not a problem with your actual script. Maybe your configuration. Tony On 11/7/06 8:38 AM, Desmond Coughlan [EMAIL PROTECTED] wrote: X-No-Archive: true That doesn't work, either. Still the blank page. Hmm ... the file is in the right place../usr/local/www/data ... 'cos all of the other files (*.html

Re: [PHP-DB] RE : Re: [PHP-DB]: small question php/postgreSQL

. If you can't get a message to display, try copying the script from hello.php to right into your new script. That should give you enough to troubleshoot. Tony On 11/7/06 9:00 AM, Desmond Coughlan [EMAIL PROTECTED] wrote: X-No-Archive: true OK, that gives a blank page, too... which is puzzling

Re: [PHP-DB]: small question php/postgreSQL

You should turn on display_errors in your php.ini file. That would make it a lot easier to track down the error. Tony On 11/7/06 9:27 AM, Desmond Coughlan [EMAIL PROTECTED] wrote: X-No-Archive: Curious. I put this in a file... ?php echo 'pHello World/p

Re: [PHP-DB] Database abstract layer

picking through code to figure out what '3' means. Hope that helps, Tony On 11/7/06 2:19 PM, Vignesh M P N [EMAIL PROTECTED] wrote: Hi I am facing a common problem which any developer querying the database would face. In our web applications wherever we have more than one standard

Re: [PHP-DB] barcode

One of my programmers did something exactly like this. I can't remember specifics, but the car code is alpha numeric and displayed in a special 'barcode' font on the page. If you don't store any information in the code, why not just use the PHP session id? Tony On 10/21/06 3:54 AM, Mad Unix

[PHP-DB] EXISTS syntax for SELECT INTO?

in advance, Tony -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Unicode error with PostgreSQL

is utf-8 and the database is UNICODE, but I'm still getting the error. Is there some problem with the PHP library? Is there a PHP setting that controls character encoding within scripts? Any help would be appreciated. Thanks in advance, Tony

Re: [PHP-DB] Error when trying to connecting to an Oracle database

Hi Janet, This is a PHP 5 only function. Are you running PHP 5? If not, try using ocilogon() instead. If you are running 5, then maybe the Oracle library wasn't included when PHP was compiled. HTH, Tony On 9/26/06 2:13 PM, Janet Smith [EMAIL PROTECTED] wrote: I am trying to use a program

Re: [PHP-DB] Unicode error with PostgreSQL

So does that mean I will always get that error? There's got to be a way around that. Is there at least a way to detect invalid characters before I try to insert? Tony On 9/26/06 1:17 PM, Niel Archer [EMAIL PROTECTED] wrote: PHP isn't multibyte aware by default. Niel -- PHP Database

Re: [PHP-DB] Error when trying to connecting to an Oracle database

Hi Janet, This is a PHP 5 only function. Are you running PHP 5? If not, try using ocilogon() instead. If you are running 5, then maybe the Oracle library wasn't included when PHP was compiled. HTH, Tony On 9/26/06 2:13 PM, Janet Smith [EMAIL PROTECTED] wrote: I am trying to use a program

Re: [PHP-DB] Unicode error with PostgreSQL

So does that mean I will always get that error? There's got to be a way around that. Is there at least a way to detect invalid characters before I try to insert? Tony On 9/26/06 1:17 PM, Niel Archer [EMAIL PROTECTED] wrote: PHP isn't multibyte aware by default. Niel -- PHP Database

Re: [PHP-DB] PostgreSQL functions missing

Hi Chris, I'm not sure if PG was updated at the same time. I do know that a separate server has no problem connecting to the database and it's running PHP 4.3. In any case, I think I've given the support guys enough info to go on. I figure if they broke it, they can fix it :) Thanks, Tony

[PHP-DB] PostgreSQL functions missing

in advance, Tony -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] novice on table design

depending on which type an entry is. but with this approach, you can easily associate with an address table. Tony S. Wu [EMAIL PROTECTED] On May 14, 2005, at 4:49 AM, tony yau wrote: Hi Miguel, Thanks for the reply. the non-customer is actually a Shop, so Employee, Customer and Shop

[PHP-DB] novice on table design

, Customer or non-Customer etc) fkey(the pkey of Employee, Customer or non-Customer etc) I know this design looks awkward but it does have the advantage of having less tables otherwise. BUT somehow it doesn't feel right. Can someone points me its pros and cons. thanks all. Tony Yau -- PHP

Re: [PHP-DB] novice on table design

) tony. Miguel Guirao [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] The schema of your table is wrong, is you do bnormalize it you will find out that you need two tables for this approach. One table for your people and another one for the n addresses of your people. If you keep your

[PHP-DB] ways of making access and visib compat with 4 and 5

hi all, I'm trying to make my classes compat with php4 and php5 is there a way of doing something like this: if( version== 4) define( VISIBILITY, ); else if (version==5) define( VISIBILITY, protected ); class Flex { VISIBILITY function CompatFunc(); } -- Tony Yau -- PHP

[PHP-DB] Define constants: awkward usage?

fname = document.addrform.{$tmp}.value I'am finding the use of define constants rather awkward. does anyone make much use of them? Thanks Tony -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: neebee: on table designs.

screw up their own table it will not affect anyone else! any comments/suggestions are very much appreciated tony 1 table with clients 1 table with records -- Sebastian Mendel www.sebastianmendel.de www.warzonez.de www.tekkno4u.de www.nofetish.com www.sf.net/projects/phpdatetime

Re: [PHP-DB] question on select

sounds like a job for JavaScript. Tony S. Wu [EMAIL PROTECTED] Look into the right places, you can find some good offerings. http://homepage.mac.com/tonyswu/stw- The perfect business. http://homepage.mac.com/tonyswu/tonyswu- My web page

[PHP-DB] Using fopen() for internet URL

? just want to speed things up a bit :P thanks. Tony S. Wu [EMAIL PROTECTED] The world doesn't give us hope - it gives us chance. http://homepage.mac.com/tonyswu/tonyswu- My web page. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Using fopen() for internet URL

Thanks, i think i got the description mixed up :D Tony S. Wu [EMAIL PROTECTED] The world doesn't give us hope - it gives us chance. http://homepage.mac.com/tonyswu/tonyswu- My web page. On Sunday, June 8, 2003, at 04:29 PM, Tony S. Wu wrote: I have an auto-update script to gather some

[PHP-DB] fopen() question and auto update question

going to have to abandon the idea by using fopen() to gather information. can anyone suggest an alternative way, which won't cost me too much time to get to it? there will be around 200 data to be updated each time. thanks a lot. Tony S. Wu [EMAIL PROTECTED] The world doesn't give us hope

[PHP-DB] Mail() on OS X

hi all, i am trying to use mail() on Mac OS X 10.2 WITHOUT sendmail. I have php.ini file in my usr/local/lib directory, with SMTP set to my desire smtp server. But it just doesn't work. Does anyone here know how to use mail() on OS X? Thanks a lot. Tony S. Wu [EMAIL PROTECTED] The world doesn't

[PHP-DB] Re: Mail() on OS X

[EMAIL PROTECTED] wrote: Hello, On 06/01/2003 10:37 PM, Tony S. Wu wrote: hi all, i am trying to use mail() on Mac OS X 10.2 WITHOUT sendmail. I have php.ini file in my usr/local/lib directory, with SMTP set to my desire smtp server. But it just doesn't work. Does anyone here know how

Re: [PHP-DB] Re: Mail() on OS X [follow up]

local machines with no luck. what gives? On Sunday, June 01, 2003, at 07:05PM, Manuel Lemos [EMAIL PROTECTED] wrote: Hello, On 06/01/2003 10:37 PM, Tony S. Wu wrote: hi all, i am trying to use mail() on Mac OS X 10.2 WITHOUT sendmail. I have php.ini file in my usr/local/lib directory, with SMTP

[PHP-DB] [NB] Mail() question

got the email. So I was wondering if Mail() request any send mail program to work. Can anyone tell me? Thanks. Tony S. Wu [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] [NB] Mail() question

to figure out why it's not working fast... Thanks to your help. Tony S. Wu [EMAIL PROTECTED] It takes a smart man to be stupid. ~Tony On Saturday, January 18, 2003, at 01:47 PM, Micah Stevens wrote: The mail() function returns true if it functions, i.e. if you have all the parameters correct

Re: [PHP-DB] [NB] Mail() question

to figure out why it's not working fast... Thanks to your help. Tony S. Wu [EMAIL PROTECTED] On Saturday, January 18, 2003, at 01:47 PM, Micah Stevens wrote: The mail() function returns true if it functions, i.e. if you have all the parameters correct, and that sort of thing. If the SMTP server

Re: [PHP-DB] [NB] Mail() question

Ah, that must be it. I am running a Mac OS X server, which is Darwin based. Guess I should go with sendmail. Thanks a lot. Tony S. Wu [EMAIL PROTECTED] On Saturday, January 18, 2003, at 02:27 PM, Jason Wong wrote: On Sunday 19 January 2003 04:48, Tony S. Wu wrote: I need to send myself

[PHP-DB] Storing Radio Buttons Checkboxes in MySQL

); } mysql_free_result($query); } --- The name of each checkbox is the same but the values are different. Do both the name and values have to be different? When it is inserted into the DB it shouldn't matter since the record would not be a duplicate. -- Tony Bollino

[PHP-DB] mail() question

I am trying to get the mail() function to work. Here is my test code: ini_set(SMTP, mail.mydomain.com); ini_set(sendmail_from, [EMAIL PROTECTED]); echo ini_get(SMTP); echo brbr, ini_get(sendmail_from); echo brbr, ini_get(sendmail_path); echo $success = mail([EMAIL PROTECTED], A subject, Some

Re: [PHP-DB] Infinite Loop?

I've seen no way to get out of the while loop. Tony S. Wu [EMAIL PROTECTED] Nope, this world ain't perfect. But at least I know it's not because of me. Graeme McLaren at [EMAIL PROTECTED] wrote: Greetings list members. I've written the code below as part of an automatic email script

[PHP-DB] Free shopping cart

I need to write a shopping cart for my friend's website. I thought modifying a free one for my need would be easier. Sorry for asking question like this. But I've done the search on google and all I could find weren't free. Can anyone provide me some links? Thanks a lot. Tony S. Wu [EMAIL

Re: [PHP-DB] Free shopping cart

Thanks a lot :D Tony S. Wu [EMAIL PROTECTED] Nope, this world ain't perfect. But at least I know it's not because of me. Jason Wong at [EMAIL PROTECTED] wrote: On Sunday 20 October 2002 23:17, Tony S. Wu wrote: I need to write a shopping cart for my friend's website. I thought modifying

[PHP-DB] LDAP?

Hi list! Seen a lot of SQL stuff floating by, but my present, consuming interest is Openldap. Is this the right list, or should I subscribe to any other list? Best, Tony -- Tony Earnshaw Tha can allway tell a Yorkshireman, but tha canna tell 'im much. e-post: [EMAIL PROTECTED

[PHP-DB] oscommerce

Has anyone on this list had any experience working with oscommerce?

Re: [PHP-DB] search syntax

Try break up the query, like: WHERE (column1 LIKE '%$search%' OR column2 LIKE '%$search%' OR column3 LIKE '%$search%') AND ... Tony S. Wu Matthew K. Gold at [EMAIL PROTECTED] wrote: hi everyone, I'm writing the code to make my mysql database searchable. I can search two columns, but I

Re: [PHP-DB] A Simple Question

]; Tony S. Wu Manuel at [EMAIL PROTECTED] wrote: I recently discovered that you can pass variables through hyperlinks. (I didn't know this could be done) This will be very helpful for the project I'm working on but I cannot find any information on this subject. Does anybody know where I can

Re: [PHP-DB] delete multiple records with one query

[name_array] as $name_element) { // call a function to delete record } else { // print message because no checkbox has been selected exit; } Tony S. Wu Matt Nigh at [EMAIL PROTECTED] wrote: hi, i'm trying to delete multiple records at once from a mysql db and can't seem

Re: [PHP-DB] Problem w/ mysql_pconnect

You must create an account in MySQL with root user first, and grant the account with the privileges you want it to have. Tony S. Wu Chris Barnes at [EMAIL PROTECTED] wrote: Hi Paul, I'm no MySQL expert and i'm only very new to this list but i have had the same problem before. What i did

Re: [PHP-DB] Auto-update database records

I finally got this auto-update script to work, thanks for your so many replies. Tony S. Wu Jason Wong at [EMAIL PROTECTED] wrote: On Saturday 08 June 2002 21:34, Tony wrote: I do appreciate your reply. Yes, I've tried to track down the problem. I comment-out the fopen() function and use

[PHP-DB] Auto-update database records

; } } flush(); } } set_footer(); ? Tony S. Wu [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Auto-update database records

the database very often, and I don't want to do it by hands.. Tony S. Wu [EMAIL PROTECTED] On Saturday 08 June 2002 20:35, Tony wrote: Here is my code. If you see some variables not defined, assume it is: Hmm, is there a problem with your code? If so could you state what the problem

Re: [PHP-DB] Auto-update database records

much data to update at once, over a hundred maybe? Then it causes the PHP to timeout this script hence the error. If I can't solve this on PHP, I'll have to find an alternative way to do this... Tony S. Wu [EMAIL PROTECTED] On Saturday 08 June 2002 20:52, Tony wrote: You are being picky on me, huh

[PHP-DB] no subject

am thinking about using AppleScript (I am using OS X). Does anyone know how to communicate with MySQL via AppleScript, if possible? Thanks. Tony S. Wu [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] fopen() question

³attempt to load file ³MyFile¹s URL² failed² from browser. It¹s supposed to output the string ³URL not available², isn¹t it? Anyone know how to get around with this? Tony S. Wu [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Trouble displaying info in a multiline form

Text area is controled by col and row size. If it's not big enough (doesn't look big enough), just make the col or row size bigger. Tony S. Wu [EMAIL PROTECTED] Thanks for help. It worked fine. But now i have another problem ( i'm new in php/html) : the textarea doesn't have the size that i

Re: [PHP-DB] Using functions in SELECT statements

Hi Robin Instead of using sql to change the case of the search criteria try using php as in the statement below $query= SELECT * FROM [Organisation Membership] WHERE lower(organisation) LIKE '%. strtolower($SearchBox) .%'); Hope this is of some help to you Tony James

Re: [PHP-DB] Count and group ?

Hi Dave Assuming you are using mysql try the following query select count(Admin_id) as admin1, Admin_id as admin2 from TABLE_NAME group by admin2 substituting TABLE_NAME for whatever you have called your table. Hope this helps Cheers Tony James - Original Message - From: Dave

RE: [PHP-DB] need help guys

hi Rehab Because your submitted text on the url contains an '' anthing after this character will be parsed as a new variable. Instead of location.href=additems.php?category=+c try location.href=additems.php?category=+escape(c) this will encode the '' aswell as spaces to preserve

FW: [PHP-DB] Username

Hi Jennifer The table defines the uid field as not null. CREATE TABLE users ( uid int(10) unsigned NOT NULL auto_increment, name varchar(20) NOT NULL default '', password varchar(20) NOT NULL default '', .. However you are trying to insert null

FW: [PHP-DB] Username

Hi again The insert statement is incorrectly positioned within the if statement. ? if(!IsSet($stage)) { ? Please fill out the form below to get an account. FORM METHOD=POST ACTION=te.php Username:BRINPUT TYPE=TEXT NAME=name SIZE=15BR input type=hidden

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

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

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

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] How to do this with 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

RE: [PHP-DB] Store Procedures

on slashdot.org today... ;)

RE: [PHP-DB] getting ID

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

be appreciated! Tony IMPORTANT NOTICE The information in this e-mail is confidential and should only be read by those persons to whom it is addressed and is not intended to be relied upon by any person without subsequent written confirmation of its contents. Furthermore, the content of this e

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

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] php script showing up on web page!!!!

); ? Thanks for your time. Tony -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DB] Wrong solution!!!!

? Thanks for your time again. Tony -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DB] Thank you all for your help!!!

I tried both Julie's and David's script, and David's script worked. But, I do appreciate both of you and Chris for great help. Tony -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact

[PHP-DB] Now, I have new problem!!

with words In Stock or Out of Stock? Can anybody help me please? Thanks for your time again. Tony -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL

Re: [PHP-DB] Help!!! Can anybody help me with my script?

as stock.php3, and point a link from product html page with known item number for itemx? And, print the result back to product html page with Out of Stock or In Stock. I will appreciate your help. Thanks again for your help. Tony Christopher Ostmo [EMAIL PROTECTED] wrote in message 3B5858C3.22011.4C90352

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

=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()

sorry bum info in my last post, it should have read $id=mssql_query(select @@IDENTITY as 'taskid'); $result=mssql_fetch_array($id); $taskid=$result[taskid]; Tony