ok, is there some command that i can just use that will find out how many rows i have in a table, or should i just use a while statment. I'll need to find out how many rows thousands of times daily and the database is considerably large.
peace sean
Sean
do a query like select id from table
then do a mysql_num_rows
that'll tell you how many records there are
Its not pretty but it does the job !
Gary Mailer
ugly does not even begin to define it :-)
Why not just run
SELECT count(*) AS cnt FROM table;
then fetch the first row of the results and you are done.
is there any way you can do something like rand(1,25);
but then exclude numbers 3 and 6. in the code the 3 or 6 would just be vairbles.
What exactly do you mean?
