How to insert same text in one field for 10,000 records table
|
what type of database is it?
|
In most databases, you should be able to run a query something like the following, to set the Approved field to Yes for every record in tablename.
Code:
UPDATE tablename SET Approved = 'Yes'; |
Hi trevelluk
Thank you for code. Now I have another question. Someone has helped me with this php code for displaying 20 rows per page. If I want to edit a particular info like email or name in that page, how do I add the code for this listing so I can edit? If possible, can you show me the modified version. Thanks. PHP Code:
|
Hi
Is it possible to include editing while showing a list of 20 records? Or do I need to write another php to do the editing? Thanks! |
(sorry for delay in responding)
PHP isn't really one of my strong points to be honest, so I can't really help you with this. Sorry. |
Hi
It is okay as I am just as new as you with PHP and MySQL. Anyone else out there has an idea how I can include the EDIT feature beside individual listing of 20 records to update? Thanks! |
All times are GMT -5. The time now is 05:24 PM. |