•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MySQL section within the Web Development category of DaniWeb, a massive community of 422,412 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 5,052 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MySQL advertiser: Programming Forums
Views: 382 | Replies: 1 | Solved
![]() |
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
selecting the information out of the table looks like this
how can i get it to just display the number?
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?
![]() |
•
•
•
•
•
•
•
•
DaniWeb MySQL Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Similar Threads
- Harddrive failure and 100% CPU under Win2K, Help Needed! (Windows NT / 2000 / XP / 2003)
- XP PRO iis help needed (Windows NT / 2000 / XP / 2003)
- CWS. help needed (Viruses, Spyware and other Nasties)
- are all these needed (Windows NT / 2000 / XP / 2003)
- help much needed !! (OS X)
Other Threads in the MySQL Forum
- Previous Thread: Get Row Length?
- Next Thread: query results


Linear Mode