switched the > and < signs to >= and <=, and it works.
Doh. Solved.
Search found 5 matches
- Wed Sep 26, 2007 5:04 am
- Forum: Databases
- Topic: FROM_UNIXTIME is not returning full date range
- Replies: 1
- Views: 309
- Wed Sep 26, 2007 1:24 am
- Forum: Databases
- Topic: FROM_UNIXTIME is not returning full date range
- Replies: 1
- Views: 309
FROM_UNIXTIME is not returning full date range
$monthStart = mktime(0, 0, 0, date("m")-$count, 1, date("Y")); $monthEnd = mktime(23, 59, 59, date("m")-$count+1, 0, date("Y")); $query = mysql_query("SELECT * FROM `expenses` WHERE `date` > FROM_UNIXTIME($monthStart) AND `date` < FROM_UNIXTIME($monthEnd...
- Fri Dec 05, 2003 6:22 pm
- Forum: PHP - Code
- Topic: How do I keep the table from stretching out?
- Replies: 5
- Views: 696
- Fri Dec 05, 2003 6:10 pm
- Forum: PHP - Code
- Topic: How do I keep the table from stretching out?
- Replies: 5
- Views: 696
The tagboard is located at http://www.static2k.com/php/tagboard/index.php for anyone who needs to see what I am talking about.
- Fri Dec 05, 2003 6:08 pm
- Forum: PHP - Code
- Topic: How do I keep the table from stretching out?
- Replies: 5
- Views: 696
How do I keep the table from stretching out?
I wrote a PHP/MySQL script for a tagboard on my website, nothing wrong with it, but when someone types in a long word like "oooooohhhhhhhhhhhhhhh" or a link, it will stretch the table out. I have thought of a few solutions - in the php code, check to see if they have entered a word longer ...