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 ?
Select * from ALL Tables
Moderator: General Moderators
- feyd
- Neighborhood Spidermoddy
- Posts: 31559
- Joined: Mon Mar 29, 2004 3:24 pm
- Location: Bothell, Washington, USA
- 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.
- 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.