phpHtmlLib: Databases » get last row

Members

Help

Home

Home » General » Databases » get last row

Show: Today's Messages :: Show Polls :: Message Navigator

E-mail to friend

get last row

Mon, 31 January 2005 14:11

UweBaumann
Messages: 9
Registered: March 2004

Newbie

From: *dip0.t-ipconnect.de

I have make a Viewer for work with Database. One action is insert a new row in the table. How can i get the last row where insert in database ?

// insert a new row

$realQuery = INSERT INTO c_Kunde (Name,Vorname)
VALUES ('baumann','Achim');
$this->_datasource->_query = $realQuery;
$this->_datasource->do_query();

// ----------------------------------------------------

Thanks for your help

Uwe Baumann

Report message to a moderator

Re: get last row

Mon, 31 January 2005 15:13

phphtmllib
Messages: 776
Registered: September 2002
Location: Cool, CA

Senior Member
Administrator

From: adsl-66-159-224-128.dslextreme.com

that is a very strange way to do an insert. Why are you using the datalistsource class to try and hack an insert?

Report message to a moderator

Re: get last row

Tue, 01 February 2005 12:59

UweBaumann
Messages: 9
Registered: March 2004

Newbie

From: *dip0.t-ipconnect.de

I want search, change, insert and delete data. The search area from class 'DefaultGUIDataList' is a good Possibility for search a Data - Row. I would like to illustrate the remaining functions as follows.

1) update data:
1.1) open the data (enable update fields)
1.2) save the data to database
1.3) display the actual data row (enable create Fields)

2) delete data:
2.1) remove data from database
2.2) display next data row (enable create fields)

3)insert Data
3.1) create new data row (enable update Fields)
3.2) save update fields to Database
3.3) display the actual data row (enable create Fields)

In the appendix I deposited the program example.