Re: [php_mysql] How to get last inserted ID in MYSQL table

Wed, 25 Oct 2006 00:27:10 -0700 

in pear?
what do you mean?

  ----- Original Message ----- 
  From: kray blue 
  To: [email protected] 
  Sent: Wednesday, October 25, 2006 6:02 AM
  Subject: Re: [php_mysql] How to get last inserted ID in MYSQL table


  how about the last insert id in PEAR?

  ~kray | 418871
  learn the rules so you know how to break them properly -unknown

  ----- Original Message ----
  From: Bocean Marius <[EMAIL PROTECTED]>
  To: [email protected]
  Sent: Monday, 23 October, 2006 4:34:55 PM
  Subject: Re: [php_mysql] How to get last inserted ID in MYSQL table

  hello

  $num=mysql_num_ rows("select id from your_table") ;

  $query=mysql_ query("select id from your_table limit $num-1, $num");

  $id=mysql_result. .....

  hth

  toto

  ----- Original Message ----- 

  From: edgardo catorce 

  To: [EMAIL PROTECTED] s.com ; [EMAIL PROTECTED] ps.com ; [EMAIL PROTECTED] 
s.com ; [EMAIL PROTECTED] ps.com ; phpandmysql@ yahoogroups. com ; [EMAIL 
PROTECTED] s.com ; [EMAIL PROTECTED] s.com 

  Sent: Monday, October 23, 2006 4:13 AM

  Subject: [php_mysql] How to get last inserted ID in MYSQL table

  Good day again guys!

  May I know how to retrieve the last inserted

  autoincrement ID in a mysql table? Thanks alot!

  ____________ _________ _________ _________ _________ __

  Do You Yahoo!?

  Tired of spam? Yahoo! Mail has the best spam protection around 

  http://mail. yahoo.com 

  [Non-text portions of this message have been removed]

  <!--

  #ygrp-mlmsg {font-size:13px;font-family:arial,helvetica,clean,sans-serif;}
  #ygrp-mlmsg table {font-size:inherit;font:100%;}
  #ygrp-mlmsg select, input, textarea {font:99% 
arial,helvetica,clean,sans-serif;}
  #ygrp-mlmsg pre, code {font:115% monospace;}
  #ygrp-mlmsg * {line-height:1.22em;}
  #ygrp-text{
  font-family:Georgia;
  }
  #ygrp-text p{
  margin:0 0 1em 0;
  }
  #ygrp-tpmsgs{
  font-family:Arial;
  clear:both;
  }
  #ygrp-vitnav{
  padding-top:10px;
  font-family:Verdana;
  font-size:77%;
  margin:0;
  }
  #ygrp-vitnav a{
  padding:0 1px;
  }
  #ygrp-actbar{
  clear:both;
  margin:25px 0;
  white-space:nowrap;
  color:#666;
  text-align:right;
  }
  #ygrp-actbar .left{
  float:left;
  white-space:nowrap;
  }
  .bld{font-weight:bold;}
  #ygrp-grft{
  font-family:Verdana;
  font-size:77%;
  padding:15px 0;
  }
  #ygrp-ft{
  font-family:verdana;
  font-size:77%;
  border-top:1px solid #666;
  padding:5px 0;
  }
  #ygrp-mlmsg #logo{
  padding-bottom:10px;
  }

  #ygrp-vital{
  background-color:#e0ecee;
  margin-bottom:20px;
  padding:2px 0 8px 8px;
  }
  #ygrp-vital #vithd{
  font-size:77%;
  font-family:Verdana;
  font-weight:bold;
  color:#333;
  text-transform:uppercase;
  }
  #ygrp-vital ul{
  padding:0;
  margin:2px 0;
  }
  #ygrp-vital ul li{
  list-style-type:none;
  clear:both;
  border:1px solid #e0ecee;
  }
  #ygrp-vital ul li .ct{
  font-weight:bold;
  color:#ff7900;
  float:right;
  width:2em;
  text-align:right;
  padding-right:.5em;
  }
  #ygrp-vital ul li .cat{
  font-weight:bold;
  }
  #ygrp-vital a {
  text-decoration:none;
  }

  #ygrp-vital a:hover{
  text-decoration:underline;
  }

  #ygrp-sponsor #hd{
  color:#999;
  font-size:77%;
  }
  #ygrp-sponsor #ov{
  padding:6px 13px;
  background-color:#e0ecee;
  margin-bottom:20px;
  }
  #ygrp-sponsor #ov ul{
  padding:0 0 0 8px;
  margin:0;
  }
  #ygrp-sponsor #ov li{
  list-style-type:square;
  padding:6px 0;
  font-size:77%;
  }
  #ygrp-sponsor #ov li a{
  text-decoration:none;
  font-size:130%;
  }
  #ygrp-sponsor #nc {
  background-color:#eee;
  margin-bottom:20px;
  padding:0 8px;
  }
  #ygrp-sponsor .ad{
  padding:8px 0;
  }
  #ygrp-sponsor .ad #hd1{
  font-family:Arial;
  font-weight:bold;
  color:#628c2a;
  font-size:100%;
  line-height:122%;
  }
  #ygrp-sponsor .ad a{
  text-decoration:none;
  }
  #ygrp-sponsor .ad a:hover{
  text-decoration:underline;
  }
  #ygrp-sponsor .ad p{
  margin:0;
  }
  o {font-size:0;}
  .MsoNormal {
  margin:0 0 0 0;
  }
  #ygrp-text tt{
  font-size:120%;
  }
  blockquote{margin:0 0 0 4px;}
  .replbq {margin:4;}
  -->

  Send instant messages to your online friends http://uk.messenger.yahoo.com 

  [Non-text portions of this message have been removed]



   

[Non-text portions of this message have been removed]



The php_mysql group is dedicated to learn more about the PHP/MySQL web database 
possibilities through group learning.  
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/php_mysql/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/php_mysql/join
    (Yahoo! ID required)

<*> To change settings via email:
    mailto:[EMAIL PROTECTED] 
    mailto:[EMAIL PROTECTED]

<*> To unsubscribe from this group, send an email to:
    [EMAIL PROTECTED]

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/

Reply via email to