Cleaner Code

win98,localhost

i have another issue. in my database, i have:

a database named, let's say, gallery that contains a table named photogallery which contains these columns:
id, title, photo, linktofullphoto, numvotes, votes, rating
this table is for rating photos, as you know

i also have a database named login containing a table called user which contains these columns:
id, userid, password, fullname, email, notes
this table is for user authenication, as you know

it seems redundant to have these in two different databases when they are both used on the same site for an interrelated purpose. is it possible to tie these together somehow?

also, users need to be able to earn points by A.visiting the site(1) B. posting pics(5) C. Voting(3)

firstly in one of the tables, you will have to add an extra field to it, so that you can have a refrence point to another article. Your made it a bit difficut on yourself because they are in different databases. Best thing would be to have them in the same database.

ok. now i have put the two tables in the same database.
are you saying that i should put the gallery and the user authenication in same table or keep them separate?

different tables, same database.

Otherwise you will have to create two connections to two different databases, and i dont think you can join two different tables from two differerent databases.

ok, i put the info in the same database. would it be feasible to put all of the information in one table?

no have the two tables, just link them with an id or a refrence point.