charismaarts

Thanks to everyone for the help...finally got it figured out... I had to apply the trim in 2 different places and also correct a querystring but it is working well now... All the best, Gerard

Thank you very much; that definitely was the problem. But it has exposed another problem. I am using gravity forms to have new vaues inputed and then passing with a query string to the next page where the count occurs; and somewhere along the line an extra space is being inserted into the beginning of the field...so I am trying to figure out why; I tried to use that trim function but it did not seem to help; but i may have coded it wrong; I will be checking this alll out and let you know... Thanks! Gerard

Hello: Thanks for getting back with me. I am new to all this and have never done an "export" so I do not know the best way to do it. Hopefully this is what you requested. I did an export and left all defaults selected and it printed out this: -- phpMyAdmin SQL Dump -- version 2.11.11.3 -- http://www.phpmyadmin.net -- -- Host: 50.63.244.142 -- Generation Time: Jul 29, 2012 at 10:34 PM -- Server version: 5.0.92 -- PHP Version: 5.1.6 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; -- -- Database: `db2012gman` -- -- -------------------------------------------------------- -- -- Table structure for table `charismos` -- CREATE TABLE `charismos` ( `userid` int(11) NOT NULL auto_increment, `username` longtext, `email` varchar(75) NOT NULL default 'a', `avatar` varchar(11) default NULL, `zenscore` varchar(11) NOT NULL default '0', PRIMARY KEY (`userid`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=59 ; -- -- Dumping data for table `charismos` -- INSERT INTO `charismos` VALUES(1, 'firstuser', '[email protected]', '1', '1'); INSERT INTO `charismos` VALUES(2, 'second user', '[email protected]', '2', '23'); INSERT INTO `charismos` VALUES(3, 'gerard is the third', '[email protected]', '3', '55'); INSERT INTO `charismos` VALUES(4, 'fourhguy', '[email protected]', '4', '55'); INSERT INTO `charismos` VALUES(5, ' will it work', '[email protected]', '2', '10'); INSERT INTO `charismos` VALUES(57, ' gerard_again', ' [email protected] ', '3', '2300'); INSERT INTO `charismos` VALUES(58, ' textuser', ' ', '3', '0');

Hello: I am having a weird problem with my mysql database that I simply cannot figure out what is wrong. I have a database setup and I am trying to do a "select count" query on the column called "username". this column contains text values. I got this php code from somewhere and at first I thought it was working fine: $sql = mysql_query(" SELECT count(*) FROM charismos WHERE username = 'will it work' ") or die(mysql_error()); $results = mysql_result($sql, "0"); it was counting them fine but then I realized it was only working on the first four rows; no matter what if I try and have it search for a username that is in fifth row or beyond it comes back with '0'; I changed my search to instead search on a "number" column and that works fine beyond the fourth row all he way to the end of the DB. So I have no idea why the searches for text values are failing beyond the fourth row. Has anyone seen anything like this before or have any idea what could cause this? Thanks so much, Gerard