Jump to content

Guldstrand

Members
  • Posts

    53
  • Joined

  • Last visited

Everything posted by Guldstrand

  1. What is the best way to store a few formats/types on different mass media? Like "vhs", "dvd", "blu-ray" for movies or "lp", "cassette", "cd" etc for music. Is it ok with an ENUM field with all types / formats or should I have a separate table just for these? (I already have a table with all genres.)
  2. How can i show/list all categories with subcategories in a good way? PARENT1 --child1 --child2 PARENT2 --child1 --child2 I have the following columns: `catID` int(10) UNSIGNED NOT NULL, `catPARENT` int(10) UNSIGNED NOT NULL, `catNAME` varchar(50) NOT NULL, `catICON` varchar(50) NOT NULL, `catTEXT` text NOT NULL
  3. Thanks for your reply. I can't use UNION cause the tables or different, as i wrote in my first post.
  4. How can I do a keyword search in two completely different tables? In one table you search for "movie title" and in the other table "actor name".
  5. I'm trying to parse multiple rss feeds and only show and save items from the last month, but i can't get it to work. All works fine, exept the part when i can't limit the data to only show last month. I've tried this: $pubdate = date("Y-m-d", strtotime($item->pubDate)); if (date($pubdate, strtotime(" -1 month")))
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.