When Insert .. but what when Update ?

[prokhaled]

In this code:
$Sql = "INSERT INTO Subject (ReplyNo) VALUES ('0')";
$Result = mysql_query($Sql);
Echo mysql_insert_id();

I use ( Echo mysql_insert_id(); ) to echo the the current ID that Inserted

but what can I use to know the current ID that updated ??

I try that
$Sql = "UPDATE Main SET tt='$tt' WHERE MainID=$MainID";
$Result = mysql_query($Sql);
Echo mysql_update_id();

but give me error that (there is not any function like that (mysql_update_id();)

[TheGoldenShogun]

I'm not sure there is a function for that. There is a function mysql_affected_rows() which returns how many records were updated/deleted. If you were doing an update with just one record, you could make sure it went through alright, you could use this to check it.

[prokhaled]

Thank you too much TheGoldenShogun !! that is what I need..

[filburt1]

Also, if you don't want to add a duplicate row, you can use:

REPLACE table...

[Iamryan2002]

I would honestly do it like this:


$query = "SELECT * FROM table";
$result = mysql_query($query, $connect);

while($curr_id = mysql_fetch_array($result))
{
$id_count = $cur_id[id]; // This is the long way...
}
// $id_count is equal to the last id in the db!

[filburt1]

How about:

SELECT id FROM table ORDER BY id ASC LIMIT 1

[Iamryan2002]

that would work also, I like to take all my data out, because I usually it...