473,545 Members | 1,649 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

webmail mysql table question

joe
I am writting a webmail client using mysql as the backend. I wrote the
scripts using a table for each separate user. I am thinkig about putting
all users in one table. the table structure now is
pk, msg, folder. i am thinking about adding a separate field called user
are there any advantages or disadvanges for doing this.
I think some disadvantages could be larger/file table size and need of
locking tables for updates, and probably less security.
the advantages would be to have all the data in one table, and no need to
setup a table for each user.
i am new to my sql i aprreciate some feedback. this is the link for
the demo of the webmail. username demo password password. i am planning on
adding and address book, and bcc and cc fields for new messages. Right now
i get the address from a search feature but most email clients have
addressbook, so i figured i should add one too.
www.wittyadmin.com/demo.html
Jul 20 '05 #1
2 1673
joe wrote:
pk, msg, folder. i am thinking about adding a separate field called user
are there any advantages or disadvanges for doing this.


That is exactly how I would do it and this is how databases are ment to
be done. I hope you ment that you add a field where you have userid
value, and you have a separate table called "user" where you have id,
name and other information about that users.
Jul 20 '05 #2
joe wrote:
pk, msg, folder. i am thinking about adding a separate field called user
are there any advantages or disadvanges for doing this.


That is exactly how I would do it and this is how databases are ment to
be done. I hope you ment that you add a field where you have userid
value, and you have a separate table called "user" where you have id,
name and other information about that users.
Jul 20 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

11
15168
by: Bruce A. Julseth | last post by:
Newbie Question: Is there a way to import MS Access into MySQL? Maybe create a CSV or something. If so, what would be the SQL to do this? Thanks... Bruce
2
4885
by: Bob Kersten | last post by:
Hi, I'm looking for a PHP webmail system that can read mail from a POP3 interface and stores the retrieved messages in a MySQL database. Does anyone know of such system and where to get it? Cheers, Bob.
19
8676
by: Westcoast Sheri | last post by:
To keep track of how many fruits my visitors buy, I use a mySQL database (2 columns: "fruit" and "quantity")....so can we make these following mySQL queries work somehow? (visitor buys 5 apples): replace into fruit_database set fruit = 'apple' , quantity = quantity + 5; (visitor buys 7 apples): replace into fruit_database set fruit =...
8
4476
by: Tony Clarke | last post by:
Hi, Just a quick question about performance with MySQL & PHP. If I had a table in a MySQL database with about 100,000 records in it and I need to find the last record is there a quick way to do this, other than going through the whole database to find the last record? Would the amount of records in the table cause major performance...
0
1213
by: Google Mike | last post by:
I have a friend interested in a Linux PHP intranet web app for webmail, calendaring, and departmental websites, all tied into a single-signon. If it comes with features such as discussion areas, public folders, web-based file storage, live chat (via Shockwave or Java applet, I guess), or anything else -- that would be perks we'd like to know...
6
3547
by: jacob nikom | last post by:
I would like to create data model for a group of stores. All stores in this group are very similar to each other, so it is natural to allocate one MySQL database per store. Each database is going to have very similar set of tables with content related to a particular store. Let's suppose each store has multiple departments which are also...
0
414
by: joe | last post by:
I am writting a webmail client using mysql as the backend. I wrote the scripts using a table for each separate user. I am thinkig about putting all users in one table. the table structure now is pk, msg, folder. i am thinking about adding a separate field called user are there any advantages or disadvanges for doing this. I think some...
2
5692
by: anna | last post by:
Firefox Mozilla Browser Fonts / Format / rich text / webmail question I have Comcast. They do not support Firefox so they won't help me. When I use Mozilla firefox browser to access my web mail like comcast webmail, I cannot change fonts, underline, bolden words. I cannot see the icons. I think I have the same problem using Yahoo and...
15
4570
by: Cheryl Langdon | last post by:
Hello everyone, This is my first attempt at getting help in this manner. Please forgive me if this is an inappropriate request. I suddenly find myself in urgent need of instruction on how to communicate with a MySQL database table on a web server, from inside of my company's Access-VBA application. I know VBA pretty well but have never...
7
4178
by: Randy | last post by:
Folks: We have a web-based app that's _really_ slowing down because multiple clients are writing their own private data into a single, central database. I guess the previous programmer did things this way because it made things easy. Well, I'm the person that has to put up with the long-term headache. Anywho, someone at work wants things...
0
7459
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
7393
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
7653
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
0
7803
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
0
7749
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
0
4942
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
0
3444
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
1
1871
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
1
1012
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.