rahenkamp Posted June 18, 2006 Share Posted June 18, 2006 I am trying to count the number of records in a MySQL DB with: $sql = sprintf("SELECT COUNT(*) AS test FROM %s WHERE login = '%s' AND cc = '%s' AND schoolid= '%s'", 'classnotes', 'teacher', '0155', '0631'); $result = mysql_query($sql) or die(mysql_error());but this is thowing an error "No Database Selected"The same SQL statement works fine in PHPmyAdmin.What don't I see?Thanks in advance.d Quote Link to comment https://forums.phpfreaks.com/topic/12278-i-try-to-count-and-php-pukes/ Share on other sites More sharing options...
neylitalo Posted June 18, 2006 Share Posted June 18, 2006 Everyone, these are the Rules Of Engagement: Read the FAQs. Read the stickies. Read the manuals. And use Google. If those four fail, then make a post. Thanks.[a href=\"http://www.phpfreaks.com/forums/index.php?showtopic=95432\" target=\"_blank\"]http://www.phpfreaks.com/forums/index.php?showtopic=95432[/a] Quote Link to comment https://forums.phpfreaks.com/topic/12278-i-try-to-count-and-php-pukes/#findComment-46901 Share on other sites More sharing options...
Fyorl Posted June 18, 2006 Share Posted June 18, 2006 In short, STFW Quote Link to comment https://forums.phpfreaks.com/topic/12278-i-try-to-count-and-php-pukes/#findComment-46904 Share on other sites More sharing options...
neylitalo Posted June 18, 2006 Share Posted June 18, 2006 hm... I must say, I've never heard of that particular acronym :D Quote Link to comment https://forums.phpfreaks.com/topic/12278-i-try-to-count-and-php-pukes/#findComment-46918 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.