mysql and tcl help please :D

2007-08-26T01:18:31-04:00

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

Statistics: Posted by YooHoo — Sun Aug 26, 2007 1:18 am

mysql and tcl help please :D

2007-08-25T23:17:00-04:00

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:

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

Statistics: Posted by whittinghamj — Sat Aug 25, 2007 11:17 pm

egghelp/eggheads community

mysql and tcl help please :D

mysql and tcl help please :D