Oh, I thought you started this threat because everyone on the old thread wanted you to do some work and show your code so they could help you improve it.
But all you were asking for was completed code.
It might also help if you explained why you wanted help on this, what is the project for? It really does look like a school project to me.
If you are using MYSQL then LIMIT <offset>, <rowcount> is your friend.
If your page can accept a page number via GET or POST, not forgetting that the initial call to the page is unlikely to have this parameter, then you can use that page number to alter the <offset> and <rowcount> values that you add to your SELECT statement.
I hope that I have given you enough pointers here to enable you to complete your web page.
None of these 'solutions' get over the fact that you are deleting records from an invoice table. In the UK this would be considered unauditable and you would be unable to get these deletions past SOX or JSOX compliance.
Deleting records in your accounting trail is, at least unwise; certainally stupid and probably a criminal act.
It would probably be better, especially for audit trails etc, to leave the current IDENTITY column intact and add another column to show if the row is active or deleted.
Then your users can make their current allocation of errors and just tag the record as deleted. The VAT / TAX man will be happy because your invoice table won't have gaps in it. And your accountants / auditors will also be happy that they can see all of the errors your data entry people make.
Sorry Ramy but you have some way to go before you become a fully skilled DBA. From reading your posts you have learned the fundamentals very well. You now need to get into a company position with an older, more experienced, DBA to mentor you to refine those skills.
I must say that I write this comment with trepidation. You have helped a large number of poeple with your posts on this site, far more that I have. I do not wish to discurage you assistance here.
You're a TECHNOPHOBE doing a DEGREE course with a large COMPUTING involvement and you want US (who are TECHNOPHILES and [mostly] have finished our degrees) to do this work for you. Is that correct?
If the answer to the above is YES and this is for a COMPUTING module, please post your School / College / Uni name & address and your Tutors name and I'll see if he too thinks that you should fail.
If the answer to the above is YES and this is for a BUSINESS module then you are a back stabbing, plagerising b**tard and will most probably get a 'first'.
If the answer to the above is NO then please rewrite your question a LOT more clearly.
Well, to help a malnourished ex-colonial :cheesy: heres my input.
1K chicken livers 1 standard tin chopped tomatoes 2 mid to large onions 2 tablespoons tomatoe puree 8 oz rice Olive oil Garlic cloves or minced
serves 4.
put 1 1/2 pints of water into a 2 pint pot, put on to boil. Peel and coursely chop onions, cover and fry gently in olive oil until browned. Cut chicken livers into small cubes and add to onions when they are ready. Stir in and keep frying until livers are seared. Add garlic to taste. Add chopped tomatoes (take out of tin first), add tomatoe puree. leave simmering slowly, stir regularly. when water boils add rice bring back to the boil and then simmer until rice has just softened. put on kettle to boil 2 pints of water.
When rice is ready and kettle is boiling. drain rice into collander, then rince with boiling water from kettle. serve rice onto plates forming a ring aroung the edge of the plate.
