RE: [PHP] MYSQL TABLES (One To Many Relationship)
Thanks Tedd, You're such an angel. I've tried it your way and it works perfectly well. (maybe I'll send you a return ticket to Nigeria when I organize the PHP conference). Hey Dan, help me amplify my thanks to Tedd. Alugo Abdulazeez www.frangeovic.com Date: Sun, 22 Mar 2009 14:38:01 -0400 To: defati...@hotmail.com; php-general@lists.php.net From: tedd.sperl...@gmail.com Subject: Re: [PHP] MYSQL TABLES (One To Many Relationship) At 5:04 PM +0100 3/22/09, abdulazeez alugo wrote: Hi guys, I need help on something I'm working on and its really eating me up so I'll appreciate any help I can get on it. I'm writing code for a site that posts a topic for discussion and accepts comments (Just like a parliament). There are different discussions for every day and the comments should be displayed along with the corresponding topics per day. Hi Alugo: I wrote a similar thing for my site, see here: http://sperling.com As you can see, on most pages people can add comment. Considering such, the most important part I found was designing the tables for the database. I used two tables, which follow showing fields: COMMENTS table Fields id -- auto-increment id for comments post_time -- time of this post poster_id -- the id from the POSTERS table page -- the page the poster commented on comment -- the actual comment made by the poster notify_me -- an option for the poster to select IF they want to be notified of additional posts approved -- option for me to use if I want the post to be displayed POSTERS table Fields id -- auto-increment id for posters time -- time of first post (i.e., registration) poster -- name of poster email -- email of poster (after confirmation of email address) ip -- ip of poster (taken from post) web_site -- web site of poster (if given) banned -- option for me to use if I want to ban this poster So as you can see, this is one table for posters and each poster can post many comments (i.e., a one to many relationship). Each time a post is made, the posting method checks the database for poster approval. Either the poster is approved, banned, or yet to be registered -- each path is followed accordingly. Note as each page is loaded the comments are pulled from the database and shown, or not, depending upon if the poster is approved OR if I have overridden the post. This allows me to ban the post, but not the poster. But in most cases, if the poster post something that I don't like, then the poster is also banned. HTH's tedd -- --- http://sperling.com http://ancientstones.com http://earthstones.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php _ News, entertainment and everything you care about at Live.com. Get it now! http://www.live.com/getstarted.aspx
Re: [PHP] MYSQL TABLES (One To Many Relationship)
At 5:04 PM +0100 3/22/09, abdulazeez alugo wrote: Hi guys, I need help on something I'm working on and its really eating me up so I'll appreciate any help I can get on it. I'm writing code for a site that posts a topic for discussion and accepts comments (Just like a parliament). There are different discussions for every day and the comments should be displayed along with the corresponding topics per day. Hi Alugo: I wrote a similar thing for my site, see here: http://sperling.com As you can see, on most pages people can add comment. Considering such, the most important part I found was designing the tables for the database. I used two tables, which follow showing fields: COMMENTS table Fields id -- auto-increment id for comments post_time -- time of this post poster_id -- the id from the POSTERS table page -- the page the poster commented on comment -- the actual comment made by the poster notify_me -- an option for the poster to select IF they want to be notified of additional posts approved -- option for me to use if I want the post to be displayed POSTERS table Fields id -- auto-increment id for posters time -- time of first post (i.e., registration) poster -- name of poster email -- email of poster (after confirmation of email address) ip -- ip of poster (taken from post) web_site -- web site of poster (if given) banned -- option for me to use if I want to ban this poster So as you can see, this is one table for posters and each poster can post many comments (i.e., a one to many relationship). Each time a post is made, the posting method checks the database for poster approval. Either the poster is approved, banned, or yet to be registered -- each path is followed accordingly. Note as each page is loaded the comments are pulled from the database and shown, or not, depending upon if the poster is approved OR if I have overridden the post. This allows me to ban the post, but not the poster. But in most cases, if the poster post something that I don't like, then the poster is also banned. HTH's tedd -- --- http://sperling.com http://ancientstones.com http://earthstones.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] MySql Tables
On Thursday 05 August 2004 08:51, DIFF FanneHH offered up the following tid-bit of information : How many records can be in a MyIsam table? Thanks I'm sure they could tell you on the MySQL mailing list. -- John C. Nichel ÜberGeek KegWorks.com 716.856.9675 [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] MySql Tables
On Thursday 05 August 2004 08:58, Jay Blanchard offered up the following tid-bit of information : [snip] How many records can be in a MyIsam table? [/snip] Bazillions. Only limited by your storage capacity and ability to manage large sets of records. Now wait a minute, my table hit a wall after a gazillion records. ;) -- John C. Nichel ÜberGeek KegWorks.com 716.856.9675 [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php