Posted by Nicholas on 07/10/07 06:41

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

[Back to original message]