Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by overyde
-
Vote Count
ingresman... This is just an "abbreviated" version of the database and tables there is various other fields that have been omitted for simplicity sake. The multiple vote situation has been identified and solved. The database is for a facebook app and one of the fields is the user's unique... -
Vote Count
r937... You're a ***ROCKSTAR*** Thanks! Reality is built on a foundation of dreams. -
Vote Count
Hey, I have a voting system for images for a competition a client is holding. I have 2 tables: entry and votetrail. I need to know the statement to be able to count who has the highest votes at any particular date/time in the past. My tables look like this: Entry... -
Array Loop
Feherke...thanks mate! Legendary. Really helped me out of a pickle there ;) Reality is built on a foundation of dreams. -
Array Loop
Just a quickie... you have: if ($last) echo "</tr>\n"; what does if ($last) actually mean. Does that test if $last has been set. I've never seen if used by itself without the {}. Reality is built on a foundation of dreams. -
Array Loop
The data comes from a dbase. Not really sure how I would set it up that whilst retrieving the data if the event id is the same then I would just add to the existing key/eventid and if it were different then set up a new key. Reality is built on a foundation of dreams. -
Array Loop
Hi, For some reason this has me stumped. Basically I'm calling data from a db and placing it in an array. How do I get the array to write a <tr> for every different "eventid" not evry entry? i.e. Basically the data below should have 2 rows in the table with <td> cells for each of the start dates... -
Select entries that fall in date range (part 2)
Let me try rephrase it: I’m trying to make an events calendar that can span over a user defined period. i.e. 3months, 6 months, 12 months etc. If there is an event happening the calendar day(table cell) background changes colour. Problem is this: ID 2 starts on the 25-03-09 and ends on the... -
Select entries that fall in date range (part 2)
Hmmm...that could be a problem. My stored procedure knowledge is pretty dismal :( Reality is built on a foundation of dreams. -
Select entries that fall in date range (part 2)
Hey, Another issue has raised its ugly head. Man I hate working with date ranges!!!! I originally had the query: SELECT * FROM calendar WHERE (startdate < '2009-05-01' AND enddate > '2009-05-30'); And this is some of the data in my database: id-------startdate----------enddate------- 1... -
start date and end date problem
Jpadie...as always...you're a wealth of knowledge mate. Thx ;) Reality is built on a foundation of dreams. -
Select entries that would fall in a date range
sorry mate...misread your reply. Thank you! Reality is built on a foundation of dreams. -
Select entries that would fall in a date range
Okay... For future reference: SELECT * FROM table WHERE (start_date < end_of_range AND end_date > start_of_range); Someone...quick...gimme a star ;) Reality is built on a foundation of dreams. -
Select entries that would fall in a date range
That won't work either as this relies on the data to have an entry actually in May. I have events that run ove a few months ie. Startdate 2009-04-02 Enddate 2009-06-22 So the event runs all the way through the month of May but is not entered into the dbase as May. Reality is built on a... -
Select entries that would fall in a date range
Hi Towerbase - Unfortunately no records are called as there is no actual entry for May (even though the event runs through May - it neither starts nor ends in May). Reality is built on a foundation of dreams.
