Web Wiz - Solar Powered Eco Web Hosting

  New Posts New Posts RSS Feed - Geting/updating data from 2 tables
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Geting/updating data from 2 tables

 Post Reply Post Reply
Author
dj air View Drop Down
Senior Member
Senior Member
Avatar

Joined: 05 April 2002
Location: United Kingdom
Status: Offline
Points: 3627
Post Options Post Options   Thanks (0) Thanks(0)   Quote dj air Quote  Post ReplyReply Direct Link To This Post Topic: Geting/updating data from 2 tables
    Posted: 09 June 2004 at 6:38am

hi guys,

i am making my tv guide and login manager applications conpatible with WWF V7 + V8

and i was going to make it work by  getting the user configuration details from the tv/login manager and login/usercode etc details from the forum table.

my question is. is there an easy way to get the user details from the forum database and the configuration details from my applications.

so when you are logged in to the applications (using forum Usercode).., your username showed in the tv guide/login manager is actually from the forum table

From forum table
- Username, Password, salt, usercode, email address

from the other tables would be the configuration details for the user.

 

i know i could use 2 queries etc.. but i want to think about performance.

also i will need to update the password etc from the tv/login manager applications into the forum table

hope that makes sense

thanx in advanced

Back to Top
ljamal View Drop Down
Mod Builder Group
Mod Builder Group


Joined: 16 April 2003
Status: Offline
Points: 888
Post Options Post Options   Thanks (0) Thanks(0)   Quote ljamal Quote  Post ReplyReply Direct Link To This Post Posted: 09 June 2004 at 10:24am
Are you using Access or MSSQL?
Either way you could use a join to return the info in one query.

If using Access updates would have to be done seperately.
With MSSQL, you can append SQL statement together with a ";" and they can be sent to be executed with one trip. Or you could use a stored procedure with the update.
Back to Top
dj air View Drop Down
Senior Member
Senior Member
Avatar

Joined: 05 April 2002
Location: United Kingdom
Status: Offline
Points: 3627
Post Options Post Options   Thanks (0) Thanks(0)   Quote dj air Quote  Post ReplyReply Direct Link To This Post Posted: 10 June 2004 at 8:22am

thanx mate, i will be using both database types as my applications are access and SQL,

but that should help.

Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.07
Copyright ©2001-2024 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Policy

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2024 Web Wiz Ltd. All rights reserved.