How do I fetch the last posted?

Jarba

New troubles...

In my database one of the fields is an Auto_increment field.
When the user has entered his/her data (through the dropdown menues and textfields), I want to present what has been entered! How can I fetch the last entered row in the database?

It is the UniqueNumber which is the auto-increment field, and I guess it would be the most simple thing to do something like:

$result = mysql_query("SELECT * FROM UniqueDocNbr WHERE UniqueNumber = ' ' ",$db);

and just fetch the last auto incremented number and then print them. Is this possible?

All help is very much appreciated :-)

             / Åsa

IceD

There are two ways to do this:
1. $result = mysql_query("select from UniqueDocNbr where UniqueNumber = " . mysql_insert_id(), $db);
2. $result = mysql_query("select from UniqueDocNbr order by UniqueNumber desc limit 1", $db);

Jarba

I´ve tried your suggestion (code below)! The thing is that now when the data is presented to the user all printf's present the first option so the list that need to look like this:
I find it strange that it prints out the country option in all cases.

Country: Ireland
Location: Ireland
Year: Ireland
Department: Ireland
Description: Ireland
UniqueNumber: Ireland
Textfield: Ireland
Owner: Ireland
Filelocation: Ireland

When I want it to look like this:

Country: Ireland
Location: Dublin
Year: 02
Department: QIC
Description: Proc
UniqueNumber: 1
Textfield: Utevcklingsprocess
Owner: Asa Karlsson
Filelocation: cvs/dpt/processfiles

The code:

$result = mysql_query("select * from UniqueDocNbr order by UniqueNumber desc limit 1", $db);

printf("Country: %s \n", mysql_result($result,"Country"));
printf("Location: %s \n", mysql_result($result,"Location"));
printf("Year: %s \n", mysql_result($result,"Year"));
printf("Department: %s \n", mysql_result($result,"Department"));

printf("Description: %s \n", mysql_result($result,"Description"));

printf("UniqueNumber: %s \n", mysql_result($result,"UniqueNumber"));

printf("Textfield: %s \n", mysql_result($result,"Textfield"));
printf("Owner: %s \n", mysql_result($result,"Owner"));
printf("Filelocation: %s \n", mysql_result($result,"Filelocation"));

I am very greatful for any suggestions and corrections on this!! Thanks again for the help I got so far 🙂

IceD

[man]mysql_result[/man]! Second parameter is int, not string. The better way to do this is [man]mysql_fetch_assoc[/man].

Jarba

Thanks IceD for your help so far!

Starting to feel a bit stupid...

I have tried to use the

mysql_fetch_assoc function instead of mysql_result in the printf statement.

According to the specification of mysql_fetch_assoc, it returns either an array or false.

I cant get straight how to use this function, I have tried several options but I keep getting the error message that the
function is undefined.

I have tried to save the fetched array in an variable and then o print that out but it gets wrong all the time. I will keep on trying to find a solution. But if you have any tips & trix I would be very happy!

IceD

[man]mysql_fetch_assoc[/man] - (PHP 4 >= 4.0.3). Which version of PHP do you use?

Of course, it's possible to use [man]mysql_fetch_array[/man]. Here is an example:

$result = mysql_query("select * from UniqueDocNbr order by UniqueNumber desc limit 1", $db);
$row = mysql_fetch_array($result, MYSQL_ASSOC);
echo $row["Country"] . "<br>";
echo $row["Location"] . "<br>";

Of course, you need to add error-checking code, such as if ($row != null) etc. BTW, the better way is to use mysql_insert_id() - imagine the situation, when two users have inserted records in one moment - both will get the same record.

Jarba

I realised i'm working with PHP3 so there's the reason for the
mysql_fetch_assoc problem 🙂

Thanks a lot for your patience and help!
I will work on the error checking parts!

Best regards / Åsa

Incubator

i´m not sure, but there might ne another way: you say you have a field docnr in your db, wich should be your primary key, right?
well, you could try this:
select (insert your fields here)
from db
having docnr = (select max(docnr from db);

just a thought 😉