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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
curdate() minus int query
Hi, I have a problem when using this query: select * from arcade_takings where date = curdate() – 2; If i change the int at the end to "1" it works fine. like this: select * from arcade_takings where date = curdate() – 1; Anything over "2" it returns nothing at all even though data exists for... -
mysql_fetch_array(): argument is not a valid
Hello Can anyone tell me if the below php/mysql statement is wrong? When I run it on my server it gives me the error mysql_fetch_array(): supplied argument is not a valid MySQL result resource. I have googled this problem to find out that i can put the '@' sign in front of mysql_fetch_array... -
whats wrong with this query?
please can anyone tell me why this query brings back results that are outside of the specified dates? SELECT DISTINCT date FROM lehrbook_prices JOIN lehrbook ON lehrbook_prices.product = lehrbook.product_code WHERE date BETWEEN '2005-09-08' AND '2005-09-09' AND maker = 'Ben Taylor' OR...
