Jump to content

Archived

This topic is now archived and is closed to further replies.

rahenkamp

I try to count and PHP pukes

Recommended Posts

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



Share this post


Link to post
Share on other sites
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]

Share this post


Link to post
Share on other sites
hm... I must say, I've never heard of that particular acronym :D

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.