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 gkittelson 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
I just took away the curly brackets and it still works! do you think I can get away with getting rid of any more here?? I dont know where I picked up the habit from??? Why will itr still work with them all there?? -
mysql_fetch_array(): argument is not a valid
Well I cant believe that I wasted 3 maybe 4 hours burning my eyes when all i missed was 'mysql_query' from the sql query!!! I posted the same question in 2 other forums too!!! WOW!! how one can miss the most obvious thing! Ben -
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?
Thankyou very very much! that worked a treat and taught me a great deal! -
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...
