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 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] 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 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 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
Archived
This topic is now archived and is closed to further replies.