Re: [PHP] Getting the last record in a mysql table FINALLY!!
Niklas,
I needed to change the statement slightly, but it did put me on the right
track.
Thanks again,
Hugh
$result=mysql_query("SELECT id FROM my_table ORDER BY id DESC, id limit 1");
$id=mysql_result($result,0);
- Original Message -
From: Niklas Lampén <[EMAIL PROTECTED]>
To: Php-General <[EMAIL PROTECTED]>
Sent: Thursday, January 17, 2002 10:29 PM
Subject: RE: [PHP] Getting the last record in a mysql table
> If you have ID that is a incrementing number, you could just query like
> this:
> 'SELECT ID FROM MY_TABLE ORDER BY ID DESC, LIMIT 1'
>
> And there you have just one result, the last (biggest) ID number.
>
>
> Niklas
>
>
> -Original Message-
> From: hugh danaher [mailto:[EMAIL PROTECTED]]
> Sent: 18. tammikuuta 2002 7:37
> To: Php-General
> Subject: [PHP] Getting the last record in a mysql table
>
>
> Help!
> I thought this would be easy but it ain't. What I want is the id number
> of the last record in a table. I've tried a number of variations to the
> following but am getting no where! Any help will be greatly
> appreciated. Hugh
>
>
> $results=mysql_query(" SELECT last_insert_id() FROM MY_TABLE ");
> $row=mysql_fetch_assoc($results); while
> ($row=mysql_fetch_row($results))
> {
> print "";
> foreach($row as $field)
>{
>if ($field=="")
> {
> $field=" ";
> }
>print "".$field."";
>}
> print "";
> }
> print "";
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP] Getting the last record in a mysql table FINALLY!!
Well, ofcourse you have to have the table + field names right. ;)
Niklas
-Original Message-
From: hugh danaher [mailto:[EMAIL PROTECTED]]
Sent: 18. tammikuuta 2002 9:38
To: [EMAIL PROTECTED]
Cc: Php-General
Subject: Re: [PHP] Getting the last record in a mysql table FINALLY!!
Niklas,
I needed to change the statement slightly, but it did put me on the
right track. Thanks again, Hugh
$result=mysql_query("SELECT id FROM my_table ORDER BY id DESC, id limit
1"); $id=mysql_result($result,0);
- Original Message -
From: Niklas Lampén <[EMAIL PROTECTED]>
To: Php-General <[EMAIL PROTECTED]>
Sent: Thursday, January 17, 2002 10:29 PM
Subject: RE: [PHP] Getting the last record in a mysql table
> If you have ID that is a incrementing number, you could just query
> like
> this:
> 'SELECT ID FROM MY_TABLE ORDER BY ID DESC, LIMIT 1'
>
> And there you have just one result, the last (biggest) ID number.
>
>
> Niklas
>
>
> -Original Message-
> From: hugh danaher [mailto:[EMAIL PROTECTED]]
> Sent: 18. tammikuuta 2002 7:37
> To: Php-General
> Subject: [PHP] Getting the last record in a mysql table
>
>
> Help!
> I thought this would be easy but it ain't. What I want is the id
> number of the last record in a table. I've tried a number of
> variations to the following but am getting no where! Any help will be
> greatly appreciated. Hugh
>
>
> $results=mysql_query(" SELECT last_insert_id() FROM MY_TABLE ");
> $row=mysql_fetch_assoc($results); while
> ($row=mysql_fetch_row($results))
> {
> print "";
> foreach($row as $field)
>{
>if ($field=="")
> {
> $field=" ";
> }
>print "".$field."";
>}
> print "";
> }
> print "";
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED] To
> contact the list administrators, e-mail: [EMAIL PROTECTED]
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED] To
contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP] Getting the last record in a mysql table FINALLY!!
Also, PHP has a built in function for finding the ID of the last insert
query. ill show some brief code.
$query = ("insert into tbl_blah (fld_blargh) values ('$roar')");
$result = mysql_query($query) or die (mysql_error());
$last_id = mysql_insert_id();
echo $last_id;
this should print out whatever the primary key # of the last insert query
performed.
This help at all?
>From: Niklas Lampén <[EMAIL PROTECTED]>
>Reply-To: <[EMAIL PROTECTED]>
>To: "Php-General" <[EMAIL PROTECTED]>
>Subject: RE: [PHP] Getting the last record in a mysql table FINALLY!!
>Date: Fri, 18 Jan 2002 10:05:35 +0200
>
>Well, ofcourse you have to have the table + field names right. ;)
>
>
>Niklas
>
>-Original Message-
>From: hugh danaher [mailto:[EMAIL PROTECTED]]
>Sent: 18. tammikuuta 2002 9:38
>To: [EMAIL PROTECTED]
>Cc: Php-General
>Subject: Re: [PHP] Getting the last record in a mysql table FINALLY!!
>
>
>
>Niklas,
>I needed to change the statement slightly, but it did put me on the
>right track. Thanks again, Hugh
>
>$result=mysql_query("SELECT id FROM my_table ORDER BY id DESC, id limit
>1"); $id=mysql_result($result,0);
>
>- Original Message -
>From: Niklas Lampén <[EMAIL PROTECTED]>
>To: Php-General <[EMAIL PROTECTED]>
>Sent: Thursday, January 17, 2002 10:29 PM
>Subject: RE: [PHP] Getting the last record in a mysql table
>
>
> > If you have ID that is a incrementing number, you could just query
> > like
> > this:
> > 'SELECT ID FROM MY_TABLE ORDER BY ID DESC, LIMIT 1'
> >
> > And there you have just one result, the last (biggest) ID number.
> >
> >
> > Niklas
> >
> >
> > -Original Message-
> > From: hugh danaher [mailto:[EMAIL PROTECTED]]
> > Sent: 18. tammikuuta 2002 7:37
> > To: Php-General
> > Subject: [PHP] Getting the last record in a mysql table
> >
> >
> > Help!
> > I thought this would be easy but it ain't. What I want is the id
> > number of the last record in a table. I've tried a number of
> > variations to the following but am getting no where! Any help will be
>
> > greatly appreciated. Hugh
> >
> >
> > $results=mysql_query(" SELECT last_insert_id() FROM MY_TABLE ");
> > $row=mysql_fetch_assoc($results); while
> > ($row=mysql_fetch_row($results))
> > {
> > print "";
> > foreach($row as $field)
> >{
> >if ($field=="")
> > {
> > $field=" ";
> > }
> >print "".$field."";
> >}
> > print "";
> > }
> > print "";
> >
> >
> > --
> > PHP General Mailing List (http://www.php.net/)
> > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED] To
> > contact the list administrators, e-mail: [EMAIL PROTECTED]
> >
>
>
>--
>PHP General Mailing List (http://www.php.net/)
>To unsubscribe, e-mail: [EMAIL PROTECTED]
>For additional commands, e-mail: [EMAIL PROTECTED] To
>contact the list administrators, e-mail: [EMAIL PROTECTED]
>
>
>--
>PHP General Mailing List (http://www.php.net/)
>To unsubscribe, e-mail: [EMAIL PROTECTED]
>For additional commands, e-mail: [EMAIL PROTECTED]
>To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
_
Chat with friends online, try MSN Messenger: http://messenger.msn.com
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
