This Day in History database retrieval
Posted 21 August 2006 - 07:57 PM
id, content, day, month, year
The content field holds the descrip of what happened that day. The other fields are self-explanatory. I want to add a field that will tag each event to a certain team, so I can display the results to have a "this Day in Tigers History" page and "Yankees" and so on... Some events might be fit more than one team. How can I create a field that has an identifier for both teams? For example, if it's an event I want to have on both the Tigers and Yankees pages, can I put "DET" and "NYY" in one field separated by a space? How do I retrieve it? I've tried LIKE and CONTAINS and neither works. Is there a way to do it that I'm overlooking?
Any help is appreciated.
Posted 21 August 2006 - 09:00 PM
then you can use an inner join to match up the events and the teams while keeping the database manageable.
Posted 21 August 2006 - 09:03 PM
This would be a work around until someone who knows what they're talking about replies.
Posted 21 August 2006 - 09:05 PM
Posted 21 August 2006 - 09:26 PM
Posted 22 August 2006 - 01:03 AM
window.location="http://www.yourdomain.com<?php print $_SERVER['REDIRECT_URL']; ?>.html";
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users