short and sweet

[JakesSA]

I posted this in the general section forum of this site, but didnt come right with an answer.......so if one can help me I would appriciate it alot.

Ive got 2 problems with a script of mine...

1.Firstly my searchs in my mysql DB is case sesitive. How can I make this insensitive to searchs?

2.The second problem is that, im my script I define the number of results I want to display:

<?PHP define(ROWS, 10) ?>

This works fine under Apache Server, but as soon as I move it under IIS the following token error is passed:

Parse error: parse error, unexpected T_STRING in C:\Inetpub\wwwroot\website\test.php on line 32

🙁

Thank you

[Traduim]

About the first question: "1.Firstly my searchs in my mysql DB is case sesitive. How can I make this insensitive to searchs? "

Simply fix your queries using LOWER()

SELECT fields FROM table WHERE lower(field) LIKE '%lower(value)%'