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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
ASP + MySQL... Need help for tricky select...
Damn..I get: Microsoft OLE DB Provider for ODBC Drivers (0x80040E14) [MySQL][ODBC 3.51 Driver][mysqld-4.0.18-nt]You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT DISTINCT pid FROM VOTES)' at line 1...- ossiandk
- Post #3
- Forum: Microsoft: ASP (Active Server Pages)
-
ASP + MySQL... Need help for tricky select...
Hi... I'm making a "Hot or Not" system in asp and MySQL, and I'm having problems selecting posts that people have not voted for earlier. I hope this info is enough... I got two tables: PICTURES - Fields: pid (picture id) | gender (gender of the person on the picture) VOTES - Fiels: vid...- ossiandk
- Thread
- Replies: 8
- Forum: Microsoft: ASP (Active Server Pages)
