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!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. AllenGarner

    SELECT DISTINCT error message

    Windows perms and folder perms should be ok I created the table in phpmyadmin and the code is the following function get_mysql_result($dbsql,$rstype) { $result = mysql_query($dbsql); //-- initial value -- $iRows = 0; $iCols = 0; $iRows = mysql_num_rows($result); $iCols =...
  2. AllenGarner

    SELECT DISTINCT error message

    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...
  3. AllenGarner

    Order By

    Thanks guys, I found a solution. I just selected all into an array and did some nifty array work. All is well, thanks for your help.
  4. AllenGarner

    Order By

    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...
  5. AllenGarner

    Parsing coomma delimited csv files

    unfortunately sometimes there are commas inside these quotes so as this works for the one situation it throws of the column count if there are any commas I need solution for both
  6. AllenGarner

    Parsing coomma delimited csv files

    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...

Part and Inventory Search

Back
Top