subject:"\[PHP\] mySQL SQL Conversion"

Re: [PHP] mySQL SQL Conversion

2004-02-16 Thread Raditha Dissanayake

hi, this is a php message board. Logan McKinley wrote: I am using MySQL (4.0.17) and am getting errors with the following SQL statement originally writen for MS products. SELECT survey_questions.Question_ID, First(survey_questions.Question_Text) AS FirstOfQuestion_Text, <== this line returns err

[PHP] mySQL SQL Conversion

2004-02-16 Thread Logan McKinley

I am using MySQL (4.0.17) and am getting errors with the following SQL statement originally writen for MS products. SELECT survey_questions.Question_ID, First(survey_questions.Question_Text) AS FirstOfQuestion_Text, <== this line returns errors i believe it is the AS Avg(survey_responses.Response)