I am using php 4.3.10 and mysql 4.1.9 on Windows Server 2003
I can SELECT Update insert delete just fine but when I use the DISTINCT keyword it craps out saying "table 'table_#SQL_43_34' is read only" I have a feeling it has somethig to do with making a temporary table or possibly permissions...
I need to be able to order results based on several criteria.
I need to be able select all records where field:group = 'value given'
and display results sorted by these criteria
1) if field:company is not empty then display field:company asc
2) if field:company is empty then display...
I am trying to Upload a csv file then split it up into an an array and build a query to insert it into a mysql table I have succeeded in getting this to work with one exception when I come across a field seperated by commas and enclosed by double quotes if that field also contains double quotes...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.