Which of the two ways should I use to insert tags into mysql?

Posted by ggfan on Stack Overflow See other posts from Stack Overflow or by ggfan
Published on 2010-05-14T03:27:44Z Indexed on 2010/05/14 3:34 UTC
Read the original article Hit count: 191

Filed under:

tags

|

php

|

mysql

For each ad, I allow users to choose up to 5 tags. Right now, in my database, I have it like...

Posting_id     TagID
    5            1
    5            2 
    5            3
    6            5
    6            1

But i was thinking if I should make it like...

    Posting_id     TagID
    5              1 2 3 
    6              5 1

Then first option is much easier to insert and retrieve data. But if I have 100 posts with 3 tags each, that's 300 rows...so ALOT more rows

The second option requires using explode() impode(), etc but it is much cleaner.

Which option should I do and why? thanks!

© Stack Overflow or respective owner

Related posts about tags

Strip tags (with tags inside attributes and nested tags) using javascript

as seen on Stack Overflow - Search for 'Stack Overflow'
What the fastest (in performance) way to strip strings from tags, most solution i've tried that uses regexp not resulting correct values for tags inside attributes (yes, i know it's wrong), example test case: var str = "<div data-content='yo! press this: <br/> <button type=\"button\"><i… >>> More
Website Title Tags For SEO - Creating Excellent Title Tags

as seen on Ezine Articles - Search for 'Ezine Articles'
What are title tags? One of the most basic, but important things you can do for your website (in terms of search engine optimisation - SEO), is to ensure that each and every page has its own unique, keyword rich title tag. The title tag can be found at the top of your source code within the and … >>> More
Inserting Ending Tags For Missing Tags In html.

as seen on Stack Overflow - Search for 'Stack Overflow'
How to insert the ending html tags where there are missing ending tags ? Like <tr> <td>Index No.</td><td>Name</td> <tr> <td>1</td><td>Harikrishna</td> Where two missing ending tags.That is "/tr".Now in this case how to Search where… >>> More
RegEx match open tags except XHTML self-contained tags

as seen on Stack Overflow - Search for 'Stack Overflow'
I need to match all of these opening tags: <p> <a href="foo"> But not these: <br /> <hr class="foo" /> I came up with this and wanted to make sure I've got it right. I am only capturing the a-z. <([a-z]+) *[^/]*?> I believe it says: Find a less-than, then Find… >>> More
Understanding WordProcessingML tags and avoid unnecessary tags

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I am using MS Word API to generate .docx which contains the data fetched from DB, in which i am applying the respective styles, fonts, symbols, etc. If the data fetched from the DB is quite huge, then there is a problem in displaying those data in the .docx file. I found that internally MS Word… >>> More

Related posts about php

Magento, NGINX, PHP-FPM, APC, MEMCACHED, 16gb Ram CentOS, Spiking PHP-FPM to 100% CPU

as seen on Server Fault - Search for 'Server Fault'
I have been trying to resolve my issue of spiking cpu caused by php-fpm processes. I've reduced the php-fpm config settings to: pm = ondemand pm.max_children = 12 pm.start_servers = 2 pm.min_spare_servers = 2 pm.max_spare_servers = 10 pm.max_requests = 500 php_admin_value[memory_limit] = 128M Problem… >>> More
PHP Pear Installation on CentOS

as seen on Server Fault - Search for 'Server Fault'
[root@ip ~]# yum install php-pear* Reducing CentOS-5 Testing to included packages only Finished Setting up Install Process Package 1:php-pear-1.8.1-2.el5.centos.noarch already installed and latest versio … >>> More
Apache configurations for php "AddType text/html php" or "AddType application/x-httpd-php php .php"

as seen on Server Fault - Search for 'Server Fault'
I am taking over an application server and discover that it contain the following settings: AddType text/html php Although it works, but my understanding is that it should set as following: AddType application/x-httpd-php php .php What are the key differences between the two settings?… >>> More
mod_rewrite settings causes server to throw HTTP 500 errors instead of 404

as seen on Server Fault - Search for 'Server Fault'
Hello. I have a server with VBulletin forum (working under Apache 2.2, CentOS). The default settings for it in .htaccess are as follows: RewriteEngine on RewriteCond %{HTTP_HOST} ^gsmforum\.ru RewriteRule (.*) http://www.gsmforum.ru/$1 [R=301,L] # If you are having problems or are using VirtualDocumentRoot… >>> More
Problems installing Memcache (PECL extension)

as seen on Server Fault - Search for 'Server Fault'
I have installed memcached fine, and now I will need to install PECL extension memcache. Im running RedHat x86_64 es5. The installation gives me this: downloading memcache-2.2.6.tgz ... Starting to download memcache-2.2.6.tgz (35,957 bytes) ..........done: 35,957 bytes 11 source files, building running:… >>> More