MySql

[firedance]

Hello I have started with mysql and I want to make a string 'mysql-safe'

I use:

Code: Select all

mysqlsel $MySql "SELECT Reply FROM `$table` WHERE Text LIKE '$text'" -list

and I have tryes [list $text].
$text is the thing that the users can type themself.

Then I have another problem that i tought i would post in the same topic...

I need a command that takes all chars etc and that can be split into two like

Code: Select all

!moo "hello hello" "hello \" moo"

, this is supposed to give me like a string with

Code: Select all

hello hello

and one with

Code: Select all

hello " moo

[strikelight]

If you are using mysqltcl, there is a command called 'mysqlescape' which makes your data mysql-safe.

[firedance]

ok, thanks