Now that I feel like a complete idiot

[TonyRosen]

If my database has 1 row, everything is flawless. If it has more than 1 row, I get errors.

Basically, I want to open my database, select the LAST entered row (highest "id"), and use that id ...

What I have:
---------------------------------------
$query = "SELECT * FROM my_register ORDER BY id DESC";
$result = mysql_query($query) or die('Query failed: ' . mysql_error());
while ($row = mysql_fetch_assoc($result)) {
$lastid = mysql_result($result,"id");
}
mysql_free_result($result);

---------------------------------------

What am I doing wrong?

 

[ingresman]

Can you post some errors ?
Just a thing if you get an error with more than 1 row are you hitting a duplicates not allowed thing ?

 

[ericbrunson]

I can't decipher your methods, by why don't you try:

select id from my_register order by id descending limit 1;

or, perhaps:

select max(id) from my_register;

 

[sleipnir214]

You shouldn't be invoking mysql_result at all. You've already fetched the data with mysql_fetch_assoc().

And if you only want one record from the table, then only fetch one record:

$query = "SELECT * FROM my_register ORDER BY id DESC LIMIT 1";
$result = mysql_query($query) or die('Query failed: ' . mysql_error());
$row = mysql_fetch_assoc($result));
mysql_free_result($result);
$lastid = $row['id'];




Want the best answers? Ask the best questions!

TANSTAAFL!!