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
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
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
> > 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 (
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
- 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
> numbers.
> for example
>
> -
not tried it, but according to the manual, it should be something like..
SELECT * FROM Bands WHERE Name REGEXP "^[0-9]";
check out the relevant page and see what you think:
http://www.mysql.com/doc/S/t/String_comparison_functions.html
regards,
Matt
-Original Message-
From: Barry Rums