Member Avatar for namratashukla

i want to design a database for cricket game where players will be selecting their players and while live cricket is goin on i want all user data base to get updated when the specefic player in his team hits.so i just want to know how to do this updation in data base where there will be large no of users having atleast 14 players. so how it is possible to update all the entry in all the tables

  • 3 Contributors
  • 2 Replies
  • 108 Views
  • 1 Month Discussion Span
  • Latest Post Latest Post by nikesh.yadav
Member Avatar for petr.pavel

Hi Namratashukla, I don't see a problem in updating a large number of records in database tables. You ask how - the answer is using UPDATE or INSERT statement.

I'm not sure if you're new to SQL (then google for "sql tutorial" or "sql reference") or if you didn't provide enough information. Why do you think that updating the db will be a problem? If you have many db tables then maybe your database design is bad and you should use less db tables (e.g. not one db table for each player).

Member Avatar for nikesh.yadav

hi namrata ,
Their should not be any problem in updating database.u should update database by simple update query.

I think u should use ajax so that on hit run by any user will update record of all user.

try and u get many peoples help u.but u should try

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.