Select * from ALL Tables

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
RootKit
Forum Newbie
Posts: 2
Joined: Wed Apr 19, 2006 7:52 am

Select * from ALL Tables

Post by RootKit »

i have 2 problem.

1) I want to designe a link counter. when you click the link the number should increase and be writen to the table at mysql

2) How can I list the informations at ALL TABLES at Mysql that order by the most clicked 100? and how can I list the 20 last inserted data??

what can i do ?
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

  1. That would be a "specially" crafted UPDATE query. We've had many examples of this on the forum. I can remember one recently being asked. Poke around for a bit.
  2. A UNION can be used to select from multiple tables somewhat independantly of other queries in it. Why would there be multiple tables that contain the same information though? I fail to see a use for this.
Post Reply