| trufla 2004-08-26, 12:18 pm |
| Could someone help, I am using php/ mysql and I have been creating recordsets
to display dynamic text in a webpage .
I have a table in a db called issues (eg: comics). a record contains fields of
info like release date, genre, title.
I display the latest 5 issues at a time in a webpage. I do this by creating 5
rs's and specifying the rs filter the primary key by the entered value 1,2,3,4
and 5, sorted descending.
I want to be able to update the db by means of a form in the web page that you
log into (say an administrator).
This way you need never go into the database (cms).
The problem is I do not know how I would go about inserting 5 records at once
(so they do not overwrite each other but overwrite the latest 5) and specifying
that the latest 5 be displayed in the webpage.
I have only inserted a single record up to now and specified the newest record
be displayed in the webpage.
Any help appreciated!
trufla
|