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
31 matches
Mail list logo
