Recent content by JimJx

Since the DB already has the first letter of all of the keywords capitalized, I went with UCFIRST Not an ideal solution, but I will have to live with it for now.....

No need to apologize.... You are just covering all of the bases. But that still begs the question: What is going on here? Have I stumbled across a bug or what???

CREATE TABLE `valley` (\n `Category` varchar(25) NOT NULL default '',\n `Name` varchar(50) NOT NULL default '',\n `Description` varchar(250) default NULL,\n `Contact` varchar(30) NOT NULL default '',\n `Phone` varchar(10) NOT NULL default '',\n `Fax` varchar(10) default NULL,\n `Address`...

Honestly, I don't remember where I got that create table from, it has been a while.... But, I integrated your suggestions into the table. Actually, I deleted the table and recreated it. I was hoping that that would get rid of the case sensitiveness... No joy.... Anyway, here is the way that...

Always interested in improvements/suggestions.....

CREATE TABLE valley ( `Category` VARCHAR(25) not null , `Name` VARCHAR(50) not null , `Description` TEXT , `Contact` VARCHAR(20) not null , `Phone` TEXT(10) not null , `Fax` TEXT(10) , `Address` VARCHAR(25) , `City` VARCHAR(25) , `State` VARCHAR(2) , `ZipCode` MEDIUMINT , `Email` VARCHAR(50) ...

Hi all, I know that searches in MySQL are supposed to be case insensitive so this is driving me nutz... Quick run down... 1 table, 13 columns. Columns 1 - 12 are type text collation is latin1_swedish_ci Column 13 Set to mediumint autoincrement, primary key collation is...

When I use that snippet of code, I will get any matches from 'keywords' but nothing from category, even though I know there is a category with the var in it.... Example: If the form passes 'auto' and I have an entry in keywords for 'auto dealers' and a category for 'auto repair', I will get the...

From me, of course! :) Just means not working correctly. An old fighter pilot term that meant they hadn't spotted the enemy even though they were told the enemy was around.....

Hi all, I have what I hope is a simple question.... I have a table with several columns, the 2 I am concerned with at the moment are Category and Keywords. I need to search both of these columns for a word or short phrase that I get from a form. For example, the search can be 'Antiques' or...

That took care of it, excellent, thanks! Jim

One more thing..... I am pulling the data from the db and getting it into 2 columns. But, the data is turning out like this: Notice the double entries.... I am using the routine from above with some minor changes.... for (my $i = 0; $i < $per_page && $i < @{$tbl_ref}-1; $i++) { # get...

Yes, the complete code for that line is FROM valley where name REGEXP '^[[:digit:]]' So I have the complete query as $query = sprintf ( "SELECT name, address, city, phone FROM valley where name REGEXP '^[[:digit:]]' ORDER BY name LIMIT %d,%d", $start - 1, $per_page + 1)...

Good catch on the eq, I completely blew that one.... And this is MySQL, so the regex command is REGEXP '^[[:digit:]]' to match any number. Thanks for the help guys, greatly appreciated. Jim

Hi all, I have what seems to me to be a strange problem.... I have the script below: <code> if ($type eq 'alpha') { $query = sprintf ( "SELECT name, address, city, phone FROM valley where name like '$search%' ORDER BY name LIMIT...