Select statement

[d99kg]

hi

i have a table... in it is as follows

prodID date numBought
1 xxx 1
2 xxx 2
1 xxx 2
3 xxx 1
1 xxx 3 <-- here
3 xxx 2

etc etc

Every time an item is bought, the numBought is incremented for the product with that ID.

How can I select the last instance of a prodID in the table,e.g.
where the arrow here points to for id=1 ??

[Aviezero]

im pretty new to php but maybe this can get you the last entry.
i might be totally off here but anyway if you cant find anything else you can mess with this code .
...

$query = "SELECT FROM carts
WHERE numBought = '".$prodID."')";
$result = mysql_query($query);
$num_results = mysql_num_rows($result); / sometimes this gives this: "Supplied argument is not a valid MySQL result resource" ( dont know why, hope not for you) */

$row = mysql_fetch_array($result);
echo "This should be your last entry: ";
echo htmlspecialchars (stripslashes($row["prodID"]));
echo "<br>Quantity: ";
echo htmlspecialchars (stripslashes($row["numBought"]));

...

[Aviezero]

you will have to edit the table name and database name. i pulled it from some code i had.