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 wOOdy-Soft 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 CadMonkey
-
Alternating Row Colors
$color1 = '#CCFFCC';" Should read, I think: $color1 = "#CCFFCC"; Variable has to equal something that must be Opened (by " ), Closed (by " ) and then ended (by ; ). Thats my simple understanding of it anyway. -
LIMIT in SELECT not working as planned
You spotted it, many many thanks. Especially for the quick reply! -
LIMIT in SELECT not working as planned
Using a defined start point for the rows and an offset. The script only returns 11 when I requested 12. I know I have more than 11. I tried the SELECT query in phpMyAdmin it works fine so it must be somehting to do with the way I'm using the code. I can't spot it. Can anybody have a read... -
LIMIT not working correctly?
I'm running a query such as: SELECT * FROM table ORDER BY field ASC LIMIT 0,10 to get the first 10 rows back. I'm gonna keep the 0 in this because it will change later. It keeps omitting the first row. I'm sure I've done it right. I've checked the query in phpMyAdmin and it works fine. Any...- CadMonkey
- Thread
- Replies: 1
- Forum: Microsoft SQL Server: Programming
