Jim Lucas wrote:
PJ wrote:
haliphax wrote:
On Fri, Mar 13, 2009 at 1:24 PM, PJ af.gour...@videotron.ca wrote:
Jim Lucas wrote:
PJ wrote:
am resending as this was erroneously ccd to mysql. sorry!
Ashley Sheridan wrote:
On Thu, 2009-02-26 at 11:27 -0500, PJ wrote:
Jerry Schwartz wrote:
PJ wrote:
Jim Lucas wrote:
PJ wrote:
haliphax wrote:
On Fri, Mar 13, 2009 at 1:24 PM, PJ af.gour...@videotron.ca wrote:
Jim Lucas wrote:
PJ wrote:
am resending as this was erroneously ccd to mysql. sorry!
Ashley Sheridan wrote:
On Thu, 2009-02-26 at 11:27 -0500, PJ wrote:
Jerry Schwartz
On Mon, Mar 16, 2009 at 03:46:29PM -0500, PJ wrote:
snip
$book_publisher = array();
$SQL = SELECT id, bookID, publisher_id FROM book_publisher;
if ( ( $results = mysql_query($SQL, $db) ) !== false ) {
while ( $row = mysql_fetch_assoc($results) ) {
$book_publisher[$row['bookID']][] =
Paul M Foster wrote:
On Mon, Mar 16, 2009 at 03:46:29PM -0500, PJ wrote:
snip
$book_publisher = array();
$SQL = SELECT id, bookID, publisher_id FROM book_publisher;
if ( ( $results = mysql_query($SQL, $db) ) !== false ) {
while ( $row = mysql_fetch_assoc($results) ) {
On Mon, Mar 16, 2009 at 06:05:33PM -0500, PJ wrote:
Paul M Foster wrote:
snip
Thanks Paul for the explanation. It really does help and iis much
appreciated.
I must respond to your chastisement of me, because i believe you may not
be aware of the fact that most books on programming really
Paul M Foster wrote:
On Mon, Mar 16, 2009 at 06:05:33PM -0500, PJ wrote:
Paul M Foster wrote:
snip
Thanks Paul for the explanation. It really does help and iis much
appreciated.
I must respond to your chastisement of me, because i believe you may not
be aware of the fact that most books
PJ wrote:
haliphax wrote:
On Fri, Mar 13, 2009 at 1:24 PM, PJ af.gour...@videotron.ca wrote:
Jim Lucas wrote:
PJ wrote:
am resending as this was erroneously ccd to mysql. sorry!
Ashley Sheridan wrote:
On Thu, 2009-02-26 at 11:27 -0500, PJ wrote:
Jerry Schwartz wrote:
Being rather new to
Jim Lucas wrote:
PJ wrote:
am resending as this was erroneously ccd to mysql. sorry!
Ashley Sheridan wrote:
On Thu, 2009-02-26 at 11:27 -0500, PJ wrote:
Jerry Schwartz wrote:
Being rather new to all this, I understood from the MySql manual
that
the auto_increment is to b e used
On Fri, Mar 13, 2009 at 1:24 PM, PJ af.gour...@videotron.ca wrote:
Jim Lucas wrote:
PJ wrote:
am resending as this was erroneously ccd to mysql. sorry!
Ashley Sheridan wrote:
On Thu, 2009-02-26 at 11:27 -0500, PJ wrote:
Jerry Schwartz wrote:
Being rather new to all this, I understood from
haliphax wrote:
On Fri, Mar 13, 2009 at 1:24 PM, PJ af.gour...@videotron.ca wrote:
Jim Lucas wrote:
PJ wrote:
am resending as this was erroneously ccd to mysql. sorry!
Ashley Sheridan wrote:
On Thu, 2009-02-26 at 11:27 -0500, PJ wrote:
Jerry Schwartz wrote:
Being rather new to all this,
PJ wrote:
am resending as this was erroneously ccd to mysql. sorry!
Ashley Sheridan wrote:
On Thu, 2009-02-26 at 11:27 -0500, PJ wrote:
Jerry Schwartz wrote:
Being rather new to all this, I understood from the MySql manual that
the auto_increment is to b e used immediately after an
Ashley Sheridan wrote:
On Thu, 2009-02-26 at 11:27 -0500, PJ wrote:
Jerry Schwartz wrote:
Being rather new to all this, I understood from the MySql manual that
the auto_increment is to b e used immediately after an insertion not
intermittently. My application is for administrators (the site
am resending as this was erroneously ccd to mysql. sorry!
Ashley Sheridan wrote:
On Thu, 2009-02-26 at 11:27 -0500, PJ wrote:
Jerry Schwartz wrote:
Being rather new to all this, I understood from the MySql manual that
the auto_increment is to b e used immediately after an insertion not
At 10:02 PM + 2/26/09, Ashley Sheridan wrote:
Only in America!
Ash
Not true -- I never thought otherwise.
Cheers,
tedd
--
---
http://sperling.com http://ancientstones.com http://earthstones.com
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit:
Jerry Schwartz wrote:
Being rather new to all this, I understood from the MySql manual that
the auto_increment is to b e used immediately after an insertion not
intermittently. My application is for administrators (the site owner
designates) to update the database from and administration
On Thu, 2009-02-26 at 11:27 -0500, PJ wrote:
Jerry Schwartz wrote:
Being rather new to all this, I understood from the MySql manual that
the auto_increment is to b e used immediately after an insertion not
intermittently. My application is for administrators (the site owner
designates)
-Original Message-
From: PJ [mailto:af.gour...@videotron.ca]
Sent: Thursday, February 26, 2009 11:27 AM
To: Jerry Schwartz
Cc: a...@ashleysheridan.co.uk; 'Gary W. Smith'; 'MySql'; php-
gene...@lists.php.net
Subject: Re: [PHP] RE: non-auto increment question
Jerry Schwartz wrote:
Being
Here's how I mostly do it (albeit simplified):
$query = INSERT INTO `sometable`(`title`,`content`)
VALUES('$title','$content');
$result = mysql_query($query);
$autoId = mysql_insert_id($result);
$query = INSERT INTO `another_table`(`link_id`,`value`)
VALUES($autoId,'$value');
$result =
On Thu, 2009-02-26 at 13:44 -0500, Jerry Schwartz wrote:
Here's how I mostly do it (albeit simplified):
$query = INSERT INTO `sometable`(`title`,`content`)
VALUES('$title','$content');
$result = mysql_query($query);
$autoId = mysql_insert_id($result);
$query = INSERT INTO
Ashley Sheridan wrote:
On Thu, 2009-02-26 at 13:44 -0500, Jerry Schwartz wrote:
Here's how I mostly do it (albeit simplified):
$query = INSERT INTO `sometable`(`title`,`content`)
VALUES('$title','$content');
$result = mysql_query($query);
$autoId = mysql_insert_id($result);
$query =
Sorry, I should know better.
-Original Message-
From: Ashley Sheridan [mailto:a...@ashleysheridan.co.uk]
Sent: Thursday, February 26, 2009 1:51 PM
To: Jerry Schwartz
Cc: 'PJ'; 'Gary W. Smith'; 'MySql'; php-general@lists.php.net
Subject: RE: [PHP] RE: non-auto increment question
On Thu
On Thu, 2009-02-26 at 14:04 -0500, PJ wrote:
Ashley Sheridan wrote:
On Thu, 2009-02-26 at 13:44 -0500, Jerry Schwartz wrote:
Here's how I mostly do it (albeit simplified):
$query = INSERT INTO `sometable`(`title`,`content`)
VALUES('$title','$content');
$result =
Being rather new to all this, I understood from the MySql manual that
the auto_increment is to b e used immediately after an insertion not
intermittently. My application is for administrators (the site owner
designates) to update the database from and administration directory,
accessed by
Not sure that this is the problem BUT you should probably qualify the name of
the variable such that SELECT MAX(id) AS id FROM book. But you don't want
max(id) as id but rather max(id) + 1 as id. With that you can then just
return the final value. Also, if you don't want to alias the value
On Wed, 2009-02-25 at 14:10 -0800, Gary W. Smith wrote:
Not sure that this is the problem BUT you should probably qualify the name of
the variable such that SELECT MAX(id) AS id FROM book. But you don't want
max(id) as id but rather max(id) + 1 as id. With that you can then just
return the
On Wed, 2009-02-25 at 19:03 -0500, PJ wrote:
Ashley Sheridan wrote:
On Wed, 2009-02-25 at 14:10 -0800, Gary W. Smith wrote:
Not sure that this is the problem BUT you should probably qualify the
name of the variable such that SELECT MAX(id) AS id FROM book. But
you don't want max(id) as id
Ashley Sheridan wrote:
On Wed, 2009-02-25 at 14:10 -0800, Gary W. Smith wrote:
Not sure that this is the problem BUT you should probably qualify the
name of the variable such that SELECT MAX(id) AS id FROM book. But
you don't want max(id) as id but rather max(id) + 1 as id. With
that you can
Being rather new to all this, I understood from the MySql manual that
the auto_increment is to b e used immediately after an insertion not
intermittently. My application is for administrators (the site owner
designates) to update the database from and administration directory,
accessed by
Being rather new to all this, I understood from the MySql manual that
the auto_increment is to b e used immediately after an insertion not
intermittently. My application is for administrators (the site owner
designates) to update the database from and administration directory,
accessed by
PJ wrote:
From: PJ [mailto:af.gour...@videotron.ca]
Sent: Wed 2/25/2009 2:01 PM
To: MySql; php-general@lists.php.net
Subject: non-auto increment question
I want to insert a new table entry 1 number higher than the highest in
the field (id). I cannot use auto-increment.
And I want to show the
Jim Lucas wrote:
PJ wrote:
From: PJ [mailto:af.gour...@videotron.ca]
Sent: Wed 2/25/2009 2:01 PM
To: MySql; php-general@lists.php.net
Subject: non-auto increment question
I want to insert a new table entry 1 number higher than the highest in
the field (id). I cannot use auto-increment.
And I
31 matches
Mail list logo