mysql error 1064 can some help solve?
Posted: Thu Sep 04, 2003 11:41 am
Can some one help solve this one
MySQL error 1064
You have an error in your SQL syntax near 'Resident AS qf5,PMEtable0.PO Address AS qf6,PMEtable0.Allot No AS qf7,PMEtable0.' at line 1
phpMyEdit error: invalid SQL query jkl1
SELECT PMEtable0.ID AS qf0,PMEtable0.fname1 AS qf1,PMEtable0.relation1 AS qf2,PMEtable0.lname1 AS qf3,PMEtable0.fname2 AS qf4,PMEtable0.Distrect of Resident AS qf5,PMEtable0.PO Address AS qf6,PMEtable0.Allot No AS qf7,PMEtable0.Id no AS qf8,PMEtable0.Acct No AS qf9,PMEtable0.Date of Death AS qf10,PMEtable0.Probate no AS qf11,PMEtable0.sex AS qf12,PMEtable0.Birth date AS qf13,PMEtable0.Tribe AS qf14,PMEtable0.Degree of Blood AS qf15,PMEtable0.Marital Status AS qf16,PMEtable0.Father AS qf17,PMEtable0.father AL or ID No AS qf18,PMEtable0.spouse1 AS qf19,PMEtable0.spouse1 AL or ID No AS qf20,PMEtable0.spouse2 AS qf21,PMEtable0.spouse2 AL or ID No AS qf22,PMEtable0.Mother AS qf23,PMEtable0.Mother AL or ID No AS qf24,PMEtable0.Remarks AS qf25,PMEtable0.date entered AS qf26,PMEtable0.FirstName AS qf27,PMEtable0.lname2 AS qf28,PMEtable0.relation2 AS qf29,PMEtable0.fname3 AS qf30,PMEtable0.lname3 AS qf31,PMEtable0.relation3 AS qf32 FROM card AS PMEtable0 ORDER BY PMEtable0.ID,PMEtable0.fname1 LIMIT 0,1560.256 miliseconds
/*
* Main list_table() query
*
* Each row of the HTML table is one record from the SQL query. We must
* perform this query before filter printing, because we want to use
* mysql_field_len() function. We will also fetch the first row to get
* the field names.
*/
$query = $this->query_make($qparts);
$res = $this->myquery($query, __LINE__);
if ($res == false) {
$this->error('invalid SQL query jkl1', $query);
return false;
}
$row = @mysql_fetch_array($res, MYSQL_ASSOC);
/* FILTER {{{
*
* Draw the filter and fill it with any data typed in last pass and stored
* in the array parameter keyword 'filter'. Prepare the SQL WHERE clause.
*/
if ($this->fl) {
// Filter row retrieval
$fields = false;
$filter_row = $row;
if (! is_array($filter_row)) {
unset($qparts['where']);
$query = $this->query_make($qparts);
$res = $this->myquery($query, __LINE__);
if ($res == false) {
$this->error('invalid SQL query jkl2', $query);
return false;
}
$filter_row = @mysql_fetch_array($res, MYSQL_ASSOC);
}
also I did notice the __LINE__ entry in several commands but cant find any documentation on the way to solve.
From A poor one man IT department with 150 stations
:->
_________________
Milamber; The Ancient Huge Red Dragon;
I Like My meat well done!!
MySQL error 1064
You have an error in your SQL syntax near 'Resident AS qf5,PMEtable0.PO Address AS qf6,PMEtable0.Allot No AS qf7,PMEtable0.' at line 1
phpMyEdit error: invalid SQL query jkl1
SELECT PMEtable0.ID AS qf0,PMEtable0.fname1 AS qf1,PMEtable0.relation1 AS qf2,PMEtable0.lname1 AS qf3,PMEtable0.fname2 AS qf4,PMEtable0.Distrect of Resident AS qf5,PMEtable0.PO Address AS qf6,PMEtable0.Allot No AS qf7,PMEtable0.Id no AS qf8,PMEtable0.Acct No AS qf9,PMEtable0.Date of Death AS qf10,PMEtable0.Probate no AS qf11,PMEtable0.sex AS qf12,PMEtable0.Birth date AS qf13,PMEtable0.Tribe AS qf14,PMEtable0.Degree of Blood AS qf15,PMEtable0.Marital Status AS qf16,PMEtable0.Father AS qf17,PMEtable0.father AL or ID No AS qf18,PMEtable0.spouse1 AS qf19,PMEtable0.spouse1 AL or ID No AS qf20,PMEtable0.spouse2 AS qf21,PMEtable0.spouse2 AL or ID No AS qf22,PMEtable0.Mother AS qf23,PMEtable0.Mother AL or ID No AS qf24,PMEtable0.Remarks AS qf25,PMEtable0.date entered AS qf26,PMEtable0.FirstName AS qf27,PMEtable0.lname2 AS qf28,PMEtable0.relation2 AS qf29,PMEtable0.fname3 AS qf30,PMEtable0.lname3 AS qf31,PMEtable0.relation3 AS qf32 FROM card AS PMEtable0 ORDER BY PMEtable0.ID,PMEtable0.fname1 LIMIT 0,1560.256 miliseconds
/*
* Main list_table() query
*
* Each row of the HTML table is one record from the SQL query. We must
* perform this query before filter printing, because we want to use
* mysql_field_len() function. We will also fetch the first row to get
* the field names.
*/
$query = $this->query_make($qparts);
$res = $this->myquery($query, __LINE__);
if ($res == false) {
$this->error('invalid SQL query jkl1', $query);
return false;
}
$row = @mysql_fetch_array($res, MYSQL_ASSOC);
/* FILTER {{{
*
* Draw the filter and fill it with any data typed in last pass and stored
* in the array parameter keyword 'filter'. Prepare the SQL WHERE clause.
*/
if ($this->fl) {
// Filter row retrieval
$fields = false;
$filter_row = $row;
if (! is_array($filter_row)) {
unset($qparts['where']);
$query = $this->query_make($qparts);
$res = $this->myquery($query, __LINE__);
if ($res == false) {
$this->error('invalid SQL query jkl2', $query);
return false;
}
$filter_row = @mysql_fetch_array($res, MYSQL_ASSOC);
}
also I did notice the __LINE__ entry in several commands but cant find any documentation on the way to solve.
From A poor one man IT department with 150 stations
:->
_________________
Milamber; The Ancient Huge Red Dragon;
I Like My meat well done!!