If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Data Access, Manipulation & Batch Languages > ANSI SQL > help me pleeease, im so confused

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 02-09-04, 20:41
purepersian786 purepersian786 is offline
Registered User
 
Join Date: Feb 2004
Posts: 6
help me pleeease, im so confused

ok i have a mysql database setup
i also have an image gallery setup on my site where people can upload their own pics after registering

in another section of my site i have a message forum where people can register to post messages
now heres the problem

what i wanna do is so that when someone signs up in the image gallery section they can use the same usernam and password to sign in to the forum and vise versa
i have no idea how to do this, its really bugging me

pleeeease help
Reply With Quote
  #2 (permalink)  
Old 02-09-04, 20:58
r123456 r123456 is offline
Registered User
 
Join Date: Sep 2003
Location: The extremely Royal borough of Kensington, London
Posts: 778
The solution depends on the complexity of your requirement.

If you do not require separate privelages for individual pages of the web site, then create a single users table.
__________________
Bessie Braddock: Winston, you are drunk!
Churchill: And Madam, you are ugly. And tomorrow, I'll be sober, and you will still be ugly.

Last edited by r123456; 02-09-04 at 21:07.
Reply With Quote
  #3 (permalink)  
Old 02-09-04, 21:03
purepersian786 purepersian786 is offline
Registered User
 
Join Date: Feb 2004
Posts: 6
how do i create a single user table?
im so sorry but im an absoloute beginner and have noo idea what that even means
Reply With Quote
  #4 (permalink)  
Old 02-09-04, 21:07
r123456 r123456 is offline
Registered User
 
Join Date: Sep 2003
Location: The extremely Royal borough of Kensington, London
Posts: 778
Simplified,

Create table users
(
username varchar2(15),
password varchar2(15)
);
__________________
Bessie Braddock: Winston, you are drunk!
Churchill: And Madam, you are ugly. And tomorrow, I'll be sober, and you will still be ugly.
Reply With Quote
  #5 (permalink)  
Old 02-09-04, 21:16
purepersian786 purepersian786 is offline
Registered User
 
Join Date: Feb 2004
Posts: 6
where do i type that?
Reply With Quote
  #6 (permalink)  
Old 02-09-04, 21:27
r123456 r123456 is offline
Registered User
 
Join Date: Sep 2003
Location: The extremely Royal borough of Kensington, London
Posts: 778
The MySQL Console.
__________________
Bessie Braddock: Winston, you are drunk!
Churchill: And Madam, you are ugly. And tomorrow, I'll be sober, and you will still be ugly.
Reply With Quote
  #7 (permalink)  
Old 02-09-04, 21:40
purepersian786 purepersian786 is offline
Registered User
 
Join Date: Feb 2004
Posts: 6
lol where is that?

maybe i should say this

i got the forum script from www.phpbb.com and the image script from http://www.4homepages.de

if that helps in anyway, i just uploaded them on to my subdomains and linked them to the mysql database i created in my hosting control panel
in the control panel theres no option for any console of any sort, all i can do is create new users and edit passwords
Reply With Quote
  #8 (permalink)  
Old 02-09-04, 21:45
r123456 r123456 is offline
Registered User
 
Join Date: Sep 2003
Location: The extremely Royal borough of Kensington, London
Posts: 778
If you need to execute DML statements then you need access to a "console" or "interface" that can accept the statements and pass them to the DBMS.

As an alternative consider editing the source code for both scripts, such that both access the same users table.
__________________
Bessie Braddock: Winston, you are drunk!
Churchill: And Madam, you are ugly. And tomorrow, I'll be sober, and you will still be ugly.
Reply With Quote
  #9 (permalink)  
Old 02-09-04, 21:56
purepersian786 purepersian786 is offline
Registered User
 
Join Date: Feb 2004
Posts: 6
i downloaded a program and am now editing the tables
i found this

4images_users

inside that i found these values:

column_____________type____________null

user_name varchar(255) no
user_password varchor(255) no9


do i change these? to the stuff u wrote up there?

thats for the image gallery
for the chat forum it has these settings phpbb_users

column __________type______________ null
username varchar(25) no
user_password varchar(32) no


please help me

Last edited by purepersian786; 02-09-04 at 22:00.
Reply With Quote
  #10 (permalink)  
Old 02-09-04, 22:58
r123456 r123456 is offline
Registered User
 
Join Date: Sep 2003
Location: The extremely Royal borough of Kensington, London
Posts: 778
Script A - Select * from userA
Script B - Select * from userB

userA
--------
username
password

userB
---------
username
password

users_AB
---------
username
password

A temporary solution may be,

Drop table userA;
Drop table userB;

Create view userA as select * from users_AB;
Create view userB as select * from users_AB;

I would recommend not using the scripts, instead write your own code specifically for your requirements. Furthermore the database tables can be designed according to your specifications.
__________________
Bessie Braddock: Winston, you are drunk!
Churchill: And Madam, you are ugly. And tomorrow, I'll be sober, and you will still be ugly.
Reply With Quote
  #11 (permalink)  
Old 02-09-04, 23:01
purepersian786 purepersian786 is offline
Registered User
 
Join Date: Feb 2004
Posts: 6
thats greek to me
forget it i give up

thanks very much for all ur help anyway, i appreciate it very much
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On