mysql and tcl help please :D

[whittinghamj]

hi guys ok i am writing a mysql search / storage system and need a wee bit of help on this one.

I am going to be searching on EXACT LIKE% and LIKE% in that order. I have the following sql lines that i know work fine

Code: Select all

set countrls [mysqlsel $mysql "SELECT COUNT(*) FROM pre WHERE rls = '$text2'" -list]

set countrls [mysqlsel $mysql "SELECT COUNT(*) FROM pre WHERE rls LIKE '$text2%'" -list]

set countrls [mysqlsel $mysql "SELECT COUNT(*) FROM pre WHERE rls LIKE '%$text2%'" -list]

what i am not sure how to do is run the first one - if nothing found then try the second one, if nothing still move onto the forth one, if still nothing then report nothing found.

i know its to do with "if" and elseif but just not sure of the code - anyone able to help me please.

cheers

[YooHoo]

try this link to Johoho's Beginners Guide To Tcl. It has extremely useful information on the basics of tcl.