egghelp/eggheads community

Count msyql output

2010-04-30T14:56:50-04:00

correct

the command applies to random between 0 and limit-1, so if limit is 100, the max value is 99, sorry.

Statistics: Posted by raider2k — Fri Apr 30, 2010 2:56 pm

Count msyql output

2010-04-30T13:22:22-04:00

raider2k:
Please re-read the documentation for rand:

rand
Returns: a random integer between 0 and limit-1
Module: core

Statistics: Posted by nml375 — Fri Apr 30, 2010 1:22 pm

Count msyql output

2010-04-30T12:44:00-04:00

Code:

SELECT COUNT(*) FROM `news`

is most probably the best idea since selecting all rows, putting them into list and then incr every entry is a waste of data and also takes longer

about rand: the syntax is [rand ?maximum?] which means a random number between 0 and ?maximum? is being chosen

Statistics: Posted by raider2k — Fri Apr 30, 2010 12:44 pm

Count msyql output

2010-04-28T14:15:14-04:00

0 through n-1, where n is the first argument on the command line.

Statistics: Posted by nml375 — Wed Apr 28, 2010 2:15 pm

Count msyql output

2010-04-28T13:54:54-04:00

ok ty, working with mysql::result. Now i have another doubt.

Using rand function like this:

set n [rand 5]

what's the range for the rand? 1-5? 1-4?

Statistics: Posted by MUSUL — Wed Apr 28, 2010 1:54 pm

Count msyql output

2010-04-28T13:28:54-04:00

Either use the COUNT() SQL-function in your query to return the number of matching records, or consider using the ::mysql::result command with the "rows" option

Statistics: Posted by nml375 — Wed Apr 28, 2010 1:28 pm

Count msyql output

2010-04-28T13:21:28-04:00

Hello,

How can count all the results from a sql query? Im trying this:

Code:

set sql "SELECT id FROM news"set query [mysql::query $db_handle $sql]if {[set row [mysqlnext $query]] != ""} { incr n 1 }putquick "PRIVMSG #test:$n news registered."

Statistics: Posted by MUSUL — Wed Apr 28, 2010 1:21 pm