[PHP-DB] Get the id generated from the previous INSERT operation

2001-05-06 Thread Alpha
mysql_insert_id - Get the id generated from the previous INSERT operation So how do I do that in ms-sql? - Alpha -- 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,

[PHP-DB] file() shooting blanks - importing fixed width file for use in MySQL

2001-05-06 Thread Jay Lepore
Hello, I have an ASCII fixed width text file I'm trying to convert to an array of fields. When I use file() to place each line (record) in it's own array element, it strips out any blanks it finds except one. This results in in ABC MOTORS becoming ABC MOTORS. That creates a problem if ABC is

[PHP-DB] php/mySQL and html select

2001-05-06 Thread Nick Terzich
hi... I have a user registration system that I need to add a state field to. Part of the form will look something like this but with all 50 states instead of just two: form select name=state option value=AKAK/option option value=ALAL/option /select /form ...how do I insert the user's state

Re: [PHP-DB] php/mySQL and html select

2001-05-06 Thread Tom Carter
Hi Nick, Assuming you have the rest of the databse interaction, all you need to is store the value of the selection (the store script will recieve a varialbe $state=AK or whatever. To then display the users state do the following //Get the users state from the database //do this however

Re: [PHP-DB] Get the id generated from the previous INSERT operation

2001-05-06 Thread Felix Kronlage
On Sun, May 06, 2001 at 07:22:24PM +0200, Alpha wrote: mysql_insert_id - Get the id generated from the previous INSERT operation So how do I do that in ms-sql? as sql it should be something like '@@IDENTITY'don't know if there is a php-function for it, just worked with ms-sql via java.

[PHP-DB] invalid select results from sybase with php

2001-05-06 Thread David Olszyski
Hello. I have a strange problem. Look: $query = select id from rates where id = 9521.0; $result = sybase_query($query); $a = sybase_fetch_row($result); echo $a[0]; This code prints number 9520.0!!! The column id is auto-incremented so it always has a unique value. But

[PHP-DB] Your Internet Education!

2001-05-06 Thread Noel Hadfield
Learn about computers and the Internet and build a business while you are doing it. Just hit: mailto:[EMAIL PROTECTED]?Subject=Education To be removed from this list, hit: mailto:[EMAIL PROTECTED]?Subject=Remove -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail:

RE: [PHP-DB] Your Internet Education!

2001-05-06 Thread Beau Lebens
something tells me that people on a php database mailing list already know a little about computers and the internet... dick // -Original Message- // From: Noel Hadfield [mailto:[EMAIL PROTECTED]] // Sent: Monday, 7 May 2001 10:54 AM // To: [EMAIL PROTECTED] // Subject: [PHP-DB] Your