Re: [PHP-DB] Simple question on auto_increment

www.php.net/mysql_insert_id --or-- www.php.net/mysqli_insert_id (of course for your example to work all the other fields would have to be nullable) Or even the MySQL function LAST_INSERT_ID(): http://dev.mysql.com/doc/refman/5.0/en/information-functions.html#id2725312 -- PHP Database Mail

Re: [PHP-DB] Simple question on auto_increment

WOW! perfect, thanks a lot mario On Mon, 2006-11-13 at 16:16 -0500, Brad Bonkoski wrote: > mario wrote: > > Hello, > > > > really a mysql question. Pls. help anyway. > > > > Is there a simple, common way to implemt the following: > > Say I have a table with a id autoincrement field. > > I wish

Re: [PHP-DB] Simple question on auto_increment

mario wrote: Hello, really a mysql question. Pls. help anyway. Is there a simple, common way to implemt the following: Say I have a table with a id autoincrement field. I wish to insert a record but just ist id value, get back the id value, use it to update the record. Do I need three separa

[PHP-DB] Simple question on auto_increment

Hello, really a mysql question. Pls. help anyway. Is there a simple, common way to implemt the following: Say I have a table with a id autoincrement field. I wish to insert a record but just ist id value, get back the id value, use it to update the record. Do I need three separate mysql queries

[PHP-DB] Simple Question... Complex Answer?

Dear All, How do I pass an ADO Recordset by reference to a COM object function in PHP v4.3.4? Cheers, Keith. ps. I posted a much more long-winded version of this earlier but it was screwed up in the Newsgroup somehow, (probably my fault). eg. My best guess... dies horribly :( $AComObject = ne

Re: [PHP-DB] Simple Question, hopefully simple answer

> > RTFM (MySQL) for COUNT() and SUM() (and many other useful functions). > > My MySQL client is giving me a syntax error when I enter that command. :-) =that? Please post the SQL/PHP causing the problem - the list's crystal ball filter is not working. =dn -- PHP Database Mailing List (

Fw: [PHP-DB] Simple Question, hopefully simple answer

- Original Message - From: "Jeroen Timmers" <[EMAIL PROTECTED]> To: "Kunden Admin" <[EMAIL PROTECTED]> Sent: Friday, February 08, 2002 1:04 PM Subject: Re: [PHP-DB] Simple Question, hopefully simple answer > > - Original Message - > From

Re: [PHP-DB] Simple Question, hopefully simple answer

Luke, > In one of my mySql tables I have a colum that contains many fields of > numbers. > for example > > > | id | Name | Age | Sex | > > |1 | Jim | 17 | m| > |2 | Dave | 31 | f | > |3 | Fred | 25 | m| > > Ok and

Re: [PHP-DB] Simple Question, hopefully simple answer

- Original Message - From: "Luke" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, October 08, 2001 10:52 AM Subject: [PHP-DB] Simple Question, hopefully simple answer > In one of my mySql tables I have a colum that contains many fields of

[PHP-DB] Simple Question, hopefully simple answer

In one of my mySql tables I have a colum that contains many fields of numbers. for example | id | Name | Age | Sex | |1 | Jim | 17 | m| |2 | Dave | 31 | f | |3 | Fred | 25 | m| Ok and I want to get the total value

RE: [PHP-DB] simple question

rom: Barry Rumsey [mailto:[EMAIL PROTECTED]] Sent: 10 January 2002 11:46 To: [EMAIL PROTECTED] Subject: [PHP-DB] simple question I have a colum with the numbers between 0-9 ( table is a list of bands )eg. 2 live crew , 2pac , 1 maniacs also in this table Ihave normal names like : abba , queen ,

[PHP-DB] simple question

I have a colum with the numbers between 0-9 ( table is a list of bands )eg. 2 live crew , 2pac , 1 maniacs also in this table Ihave normal names like : abba , queen , police etc.. How would I query the table to list only the ones starting with numbers.