profmysd
Posts: 3
|
| Posted: 07/13/2005, 12:29 AM |
|
I'm having a problem on retrieve database value.
Table:work_request
Field:req_id, req_no, req_date,...
How am I going to retrieve the req_id last record value? req_id is a primary key for this table.
When I used, retrieve control value it just take the first value in the record???
Please, need help. Thanks.
_________________
profmysd |
 |
 |
dsafar
|
| Posted: 07/13/2005, 4:57 AM |
|
If you are using mysql use this php function - mysql_insert_id (use the
after insert event) . If you're using other databases, google it with
database name and last inserted record..
"profmysd" <profmysd@forum.codecharge> wrote in message
news:542d4c2f51152b@news.codecharge.com...
> I'm having a problem on retrieve database value.
>
> Table:work_request
> Field:req_id, req_no, req_date,...
>
> How am I going to retrieve the req_id last record value? req_id is a
> primary
> key for this table.
>
> When I used, retrieve control value it just take the first value in the
> record???
>
> Please, need help. Thanks.
> _________________
> profmysd
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
|
