[jonnekke]

Hi there.. I got this query in my website.. but I think I made a program fault somewhere...
Is there something wrong in the way I wrote it? Because even when I'm 100% sure there
should be a match nothing shows up in the query..

PHP Code:

if($type == ""){

    $type = "[[:alpha:]]";                                                        

}



if($plaats == ""){

    $plaats = "[[:alpha:]]";                                                        

}

                                                                                                    

$trainingenindezecat = mysql_query("SELECT * FROM trainingen WHERE                                                             

(soort='$categorieid') AND  

(plaats REGEXP '$plaats') AND                                                             

(datum BETWEEN '$fromdate' AND '$todate') AND 

(type REGEXP '$type') AND 

(kosten BETWEEN '$prijsvan' AND '$prijstot')                                                         

ORDER BY type, titel") or die(mysql_error()); 

[Nico]

I'm not terribly familiar with POSIX regular expressions, but try this:

PHP Code:

'^[a-z0-9]+$' 

... rather than:

PHP Code:

'[[:alpha:]]' 

Also, echo your SQL string to make sure it really contains the expected values.