[Resolved] How to echo last inserted record?

[aepstar]

I searched but could not find a thing.

this code doesnot work for me:

$query = mysql_query("SELECT MAX(id) FROM celebs");
query_result = mysql_fetch_row("$query");
echo $query_result;

[yousaf931]

A quite boring code but it helps

$query = "SELECT * FROM celebs";
$result = mysql_db_query($db_name,$query, $connection);
while($row = mysql_fetch_array($result)){
       $id_max=   $row["id"]; 

}

echo " Last Id " . $id_max;

Not a good technique but it works.

Cheers,
yousaf FAYYAZ.

[aepstar]

Originally posted by yousaf931
A quite boring code but it helps

$query = "SELECT * FROM celebs";
$result = mysql_db_query($db_name,$query, $connection);
while($row = mysql_fetch_array($result)){
       $id_max=   $row["id"]; 

}

echo " Last Id " . $id_max;

Not a good technique but it works.

Cheers,
yousaf FAYYAZ. [/B]

thanks, but i want the technique that uses MAX(id). because it is safer that way!

[drawmack]

SELECT * from celebs order by id desc

then the first record returned is the one with max id and it's no less safe then using max id but it is one less database call.

[yousaf931]

hI,

max() returns the numerically highest of the parameter values.

If the first parameter is an array, max() returns the highest value in that array. If the first parameter is an integer, string or float, you need at least two parameters and max() returns the biggest of these values. You can compare an unlimited number of values.

If one or more of the values is a float, all the values will be treated as floats, and a float is returned. If none of the values is a float, all of them will be treated as integers, and an integer is returned.

sEE IT is written in the manul atleast 2 parameters and u r giving only one.

Cheers,
yousaf FAYYAZ.

[aepstar]

Originally posted by yousaf931
hI,

max() returns the numerically highest of the parameter values.

If the first parameter is an array, max() returns the highest value in that array. If the first parameter is an integer, string or float, you need at least two parameters and max() returns the biggest of these values. You can compare an unlimited number of values.

If one or more of the values is a float, all the values will be treated as floats, and a float is returned. If none of the values is a float, all of them will be treated as integers, and an integer is returned.


sEE IT is written in the manul atleast 2 parameters and u r giving only one.


Cheers,
yousaf FAYYAZ.

please help me! i just want to print the max value of my id field which is tiny int.

[yousaf931]

Read the manual the other code which i have written is the next possible option for you.

u have to give a max 2 vaule if it is interger.

Other wise have to convert the result in to array as it did in the code.

Cheers,
yousaf FAYYAZ.

[drawmack]

okay, since you didn't see my post above

<?php
//connection string omitted
$query = "SELECT id FROM celebs ORDER BY id DESC";
$results = mysql_query($sql);

if(mysql_num_rows($results) > 0) {
    echo "Max id: " . mysql_result($result,0,0);
} else {
    echo "No data in celebs table";
}
?>

you can make this into a function like this

<?php
function get max_id($server = 'localhost',$dbname,$username,$password,$id_field,$table) {
    $db_conn = mysql_connect($server,$username,$password);
    mysql_select_db($dbname);
    $sql = "SELECT " . $id_field . " FROM " . $table . " ORDER BY " . $id_field . " DESC";
     $query = mysql_query($sql);
     if(mysql_num_rows($query) > 0) {return mysql_result($query,0,0);}
    else {return 0;}
} //end get max
?>

[aepstar]

finally it works.

thanks for wasting your time :p

[aepstar]

drawmack, thanks, i already have it working :p :p :p :p :p