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
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
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 to insert a
- 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
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 I want to
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
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