Posted by Captain Paralytic on 07/10/07 08:46

On 10 Jul, 07:41, Nicholas <Nicholas.A...@gmail.com> wrote:
> thanks.
>
> it was that I had commented the mysql dll from the ini.
>
> I know this may be a mysql question but was hoping someone might know
> what was what.
>
> As previously mentioned am running Apache service and php 5 binaries
> in Windows w/ mysql 5
>
> my queries were working fine under mysql 5 until I upgraded to php 5
> which is why I suspect it may be due to this although I was previously
> unware of the left join and comma syntax which I have rewritten.
>
> I receive an error Unknown column 'feature' in 'where clause'
>
> which I first suspected was mysql 5 left join syntax
>
> the line it refers to is located below.. but (this is interesting)
> when I change the column name from feature to another column in the
> table the query works.
>
> //page voronoi.php
> include connect.php //connection to database
>
> function Voronoi($featureType){
> /*Search for the feature based on name
> returns an array of point coordinates (x,y)
> */
> $featureCoordinates = array();
> $counter=0;
> $query = "select * from features where feature LIKE '".
> $featureType."'";
>
> which is included in the index page
>
> incidentally the query which uses the left join is below. I call this
> page using javascript via ajax http_request which does the job fine
> but when I include the file(below) I get the error above?
>
> include "perth_special.php" //database connect
>
> function search(&$tree, $table, $word){
> //RECURSIVE SEARCH:-for each matching synset retrieve its 'derived'
> word, store in an array and repeat procedure on resulting word.
> $query = "select t.synset_id_2, s.word from (wn_synset AS s, $table
> AS t) LEFT JOIN $table t ON (s.synset_id = t.synset_id_1) where
> s.synset_id='".$word."' and s.ss_type='n'";
>
> so I am trying to isolate the problem..
>
> thanks in advance Nicholas

Can you post a dump of the table schema (the CREATE TABLE command that
comes out of PMA would be great.

[Back to original message]