Paul M Foster wrote:
> On Mon, Mar 16, 2009 at 06:05:33PM -0500, PJ wrote:
>
>> Paul M Foster wrote:
>
>
>
>> 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 tha
On Mon, Mar 16, 2009 at 06:05:33PM -0500, PJ wrote:
> Paul M Foster wrote:
> 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 reall
Paul M Foster wrote:
> On Mon, Mar 16, 2009 at 03:46:29PM -0500, PJ wrote:
>
>
>
>
$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 03:46:29PM -0500, PJ wrote:
> >> $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['book
PJ wrote:
> Jim Lucas wrote:
>> PJ wrote:
>>> haliphax wrote:
On Fri, Mar 13, 2009 at 1:24 PM, PJ 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,
Jim Lucas wrote:
> PJ wrote:
>> haliphax wrote:
>>> On Fri, Mar 13, 2009 at 1:24 PM, PJ 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:
J
PJ wrote:
haliphax wrote:
On Fri, Mar 13, 2009 at 1:24 PM, PJ 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
haliphax wrote:
> On Fri, Mar 13, 2009 at 1:24 PM, PJ 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 rathe
On Fri, Mar 13, 2009 at 1:24 PM, PJ 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 unders
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
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 insertion
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 inserti
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 administr
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: http://www.p
> 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
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')";
> >>> $
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
>Su
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($
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 IN
>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
>-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 i
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 &
>
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 administra
PJ 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 directory,
accesse
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
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 v
>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 u
>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 us
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
>>
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
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
> r
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 val
32 matches
Mail list logo
