SitePoint Sponsor

User Tag List

Page 2 of 2 FirstFirst 12
Results 26 to 28 of 28
  1. #26
    SitePoint Member
    Join Date
    Jun 2011
    Posts
    17
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    hi,

    1/yeah the link building does definately need looking into, maybe build a function? but i will remove them from the loops first
    2/ the regexp stuff is because the filmDepartment field holds several ids which the film is part of ie "810778 1255766 76655 9987665" and im trying to match a single id ie "810778 = would not work like not sure i know "LIKE '%810778%'" doesnt work because if there was a number in the field say 77658107786 it would return that item although the id is not matched, maybe just "LIKE '810778'" would work? havent tested it for some reason but the regexp defo works... will look into the LIKE option
    3/thats a good idea would make sence to do this

    thanks mate appreciate the time youve spent looking through my rubble lol

  2. #27
    From Italy with love silver trophybronze trophy
    guido2004's Avatar
    Join Date
    Sep 2004
    Posts
    9,501
    Mentioned
    163 Post(s)
    Tagged
    4 Thread(s)
    2/ That sounds like your database hasn't been completely normalized. A filmDepartment table with two columns (filmID and departmentID) would resolve that problem.

  3. #28
    SitePoint Member
    Join Date
    Jun 2011
    Posts
    17
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    ah thats true, at first i didnt think it was necessary but the further i've got into my project it seems more and more like a good idea thanks


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •