RE: [PHP] Any clever ideas on how to find some random records?

2005-04-26 Thread David Tucker
[OP] I have a MySQL database with about a million records. I'd like to use the SQL command order by RAND() but my ISP won't let me: whenever the server gets spidered, Google overloads their MySQL server because of all the overhead of that command. I can't just cloak the spiders because I need them

RE: [PHP] how to read a specific cell

2005-04-26 Thread David Tucker
I would do it like this : if (mysql_data_seek($result, $rownum)) $a_row = mysql_fetch_row($result); echo $a_row[$column_int]; --Codefox -Original Message- From: Sebastien Pahud [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 26, 2005 5:52 PM To: php-general@lists.php.net