List:General Discussion« Previous MessageNext Message »
From:<ross Date:February 21 2007 9:03am
Subject:mysql problem
View as plain text  
 I have a database online and have a strange mysql problem.

When I connect remotely from my desktop (same browse_database.php page) I 
get over 1000 results with the query below but when I run the same page on 
the remoted server this value is almost halved to 520.

any ideas what is hapening?

$total_rows = mysql_num_rows(mysql_query("SELECT * FROM $table_name"));


It just seems to ignore them on the remote one as I am in under ross and 
ross2 and only one when I search for me.


R.
Thread
• multiple nistances at boot with mysqld_multi or otherChris McKeever20 Feb
  • mysql problemross21 Feb