From: "antonio bernabei" <tonibern@xxxxxx> > I need to make a join between two tables. And I can use the mysql_query > function: this is ok. > The problem arises because I need to apply a user defined function to a > field of one of the two tables and the rule for the join is WHERE > table1.filed1=function(table2.field2). > But I receive a lot of errors: it seems like is not allowed to put such a > function in the text of the query. Or there is a possibility? You should be able to do this.. you're just doing a comparison. Although it'll negate any indexes you have and make for a very slow join. We are talking about a MySQL function, right... and not a PHP one?? ---John Holmes... -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
