My query is resulting in error....why ?

[jd2007]

select $this->id, $this->title, $this->thumbnail from $this->table order by 'select $this->past from $this->table2'

 

the above is my query....what's wrong ? this is the error:

 

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 'from flash order by 'select past from awards'' at line 1

[AndyB]

... and this gives what error?

[jd2007]

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 'from flash order by 'select past from awards'' at line 1

[pranav_kavi]

echo the query so to check if it s valid.

[jd2007]

i want to take three columns from a table, one of the column is related to another table.

 

column title, id, thumb is in table 1,

column id, past, title is in table 2,

 

i want title, id, thumb from table 1 ordered by past in table 2.

[pranav_kavi]

can u post the the section of ur db code?

[jd2007]

its valid

 

 

function latestSubmissionAwards($ext="")
{
	if ($ext=="")
	{
     $this->que="select $this->id, $this->title, $this->thumb from $this->table order by $this->past desc limit 5";
	 $this->res=mysql_query($this->que);
     $this->showSubm(); 
    }
    else
    {
      $this->table2=$ext;
	  $this->que="select $this->id, $this->title, $this->thumbnail from $this->table order by 'select $this->past from $this->table2";
	  $this->res=mysql_query($this->que);
     $this->showSubm(); 	
	}
}

[pranav_kavi]

try adding a single quote at the end of the query bfore u close the double quotes.

$this->que="select $this->id, $this->title, $this->thumbnail from $this->table order by 'select $this->past from $this->table2'";

[zgkhoo]

wat is this "->" symbol for?

[jd2007]

it still doesn't work.

 

wat is this "->" symbol for?

 

it used for reference in oop.

[pranav_kavi]

in which part of the code r u printing out the table values?

[Illusion]

ORDER BY clause expect a column name next to that not the values.

 

..............order by  $this->table2.$this->past ;