Php and mysql , Search button error

[dickitt]

Hello,

 

First of all i would like to mention that it's about a dating script and it installs perfectly and works fine except for one little problem.When i push the search button it gives me something like this :

 

SELECT Profiles.ID, Headline, Country, Occupation, City, Sex, Sex2, ProfileType, NickName, Children, MerchantPrice, LEFT( DescriptionMe, 180 ) AS DescriptionMe, LEFT( DescriptionYou, 100 ) AS DescriptionYou, DateOfBirth, DateOfBirth2, Pic_0_addon, Sound, (LastNavTime > SUBDATE(NOW(), INTERVAL 5 MINUTE)) as is_onl FROM Profiles WHERE Status = 'Active' AND (LookingFor = 'male' OR LookingFor = 'both') AND (IF('female'='both' or 'female'='couple',1,Sex='female')) AND (IF('female'='couple',ProfileType='couple',Profile Type!='couple')) AND (TO_DAYS(DateOfBirth) BETWEEN TO_DAYS('1931-02-12') AND (TO_DAYS('1989-02-12')+1)) ORDER BY Priority DESC, Priority DESC, Profiles.LastLoggedIn DESC LIMIT -10, 10

 

under it it writes some rectangle with "database acces" Error but the funny thing is that the data are all corect.it works for login, join form, and all functions even send mails and all, just this wouldn't work ... if anyone could please help with this one.may this be the cause that the database name is something like "nice_nice" inseatd of just "nice" ?

 

if anyone could please help me i would really apreciate it.if there is need i will also post the mysql table after a few opinions.thanks in advance.

[redarrow]

can we have the search page please cheers.