i have created a table to store the number of a count which i need for some subtraction at a later date. when i try to get the information out of the table instead of getting the number 5 i am getting resource id # 5.
the table has been set up like this
$sql="CREATE TABLE IF NOT EXISTS `email_count` ( `id` INT NOT NULL AUTO_INCREMENT, `sent_messages` INT not null, primary key (id) )"; mysql_query($sql) or die (mysql_error());
selecting the information out of the table looks like this
$query = "SELECT sent_messages FROM email_count"; $result=mysql_query($query)or die(mysql_error()); $sent_mail = $results;
how can i get it to just display the number?