No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
I have written a small query. I want to create link on my php site which on click will run this script automatically and export results to an excel file. I dont want to create a page to view the results. Any help to this new bie will be very … |
|
I have these two queries which i want to run together and not one by one. How can i do that? Or can it be modified to be one query. [CODE] UPDATE runquery.table1, runquery.table2 SET runquery.table1.`Column1` = (runquery.table2.`Col1`/runquery.table2.`Col2`*100) Where runquery.table2.`itemid` = 3 and runquery.table1.`Userids` = runquery.table2.`userid`; UPDATE runquery.table1, runquery.table2 SET … |