6DV8 Posted November 10, 2002 Posted November 10, 2002 In any product category my products are listed 1 each line (odd line shaded-even line clear) I have an image of the product, the Name, the model, and the price. To see a description you have to click on a product. I WOULD LOVE TO HAVE AT LEAST THE FIRST 5-10 WORDS DESCRIPTION TO ENTICE THE CUSTOMER TO HAVE A CLOSER LOOK!!!!. e.g. This product has fantastic qualities due to the................more info. What do you think - do-able????[/i]
Paul_C Posted November 10, 2002 Posted November 10, 2002 There are a couple contributions that do this. Short Description in Product Listing 1.2 - puts it all on the same row Description in Product Listing v.2 - adds a new row for the description (with product image spanning both lines, if applicable) "It's a damn poor mind that can only think of one way to spell a word." -- Andrew Jackson
6DV8 Posted November 10, 2002 Author Posted November 10, 2002 :lol: Great - they sound just like what I need. Thanks again paul
6DV8 Posted November 10, 2002 Author Posted November 10, 2002 I've downloaded and read readme.txt. Changing the PHP files I can quite easily do - but uh! run SQL?? Is running a SQL Queery easy enough to do. Looking inside my database I see the files that are mentioned. But I'm not sure how to execute what it is asking - ie. running SQL queery. Is this beyond me - keeping in mind that 2 weeks ago I had no idea how to mess with code and now I can.
Paul_C Posted November 10, 2002 Posted November 10, 2002 I recommend using phpmyadmin for handling sql. "It's a damn poor mind that can only think of one way to spell a word." -- Andrew Jackson
6DV8 Posted November 10, 2002 Author Posted November 10, 2002 That is what I've got (it came with my server). Where it says------ Run the following two SQL queries on your database: The first is to enable the display of Products Description in the Listing 0 = No 99 = Yes INSERT INTO `configuration` (`configuration_id`, `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`) VALUES ('', 'Display Product Description', 'PRODUCT_LIST_DESCRIPTION', '99', 'Set to 0 to disable, set to 99 to enable.', '8', '11', '', '', NULL, NULL); I'm not sure what to do - But I can click on "configuration" and I see 'configuration ID - Configuration Title in the table - - Do I set some parameter here. I really am appreciative of your advice!!
6DV8 Posted November 10, 2002 Author Posted November 10, 2002 I'm thinking out loud here- But because I hav'nt actually copied over the php files yet there is not entry in "configuration" that I can see that this is referring too - right! And so if I copied the files over I'd go to php myadmin and click on configuration and set the parameters to "0" or 99" then. Does this sound right? Am I gettin' closer???
Paul_C Posted November 10, 2002 Posted November 10, 2002 In phpmyadmin choose your database then click SQL (or find whereever you need to be to run an sql query, it depends on the version) and copy, paste, and run both queries INSERT INTO `configuration` (`configuration_id`, `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`) VALUES ('', 'Display Product Description', 'PRODUCT_LIST_DESCRIPTION', '99', 'Set to 0 to disable, set to 99 to enable.', '8', '11', '', '', NULL, NULL); INSERT INTO `configuration` (`configuration_id`, `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`) VALUES ('', 'Length of Truncated Product Description', 'PRODUCT_LIST_DESCRIPTION_LENGTH', '350', 'How many characters would you like to display? ', '8', '12', '2002-03-16 18:51:26', '2002-03-16 18:51:26', NULL, NULL); The reason there is nothing under "Configuration>Product Listing" yet is because you haven't run the sql queries. Hope this helps! "It's a damn poor mind that can only think of one way to spell a word." -- Andrew Jackson
Paul_C Posted November 10, 2002 Posted November 10, 2002 Oh yeah... And so if I copied the files over I'd go to php myadmin and click on configuration and set the parameters to "0" or 99" then. Does this sound right? Am I gettin' closer??? This number you'll set in your osCommerce administration under "Configuration>Product Listing". "It's a damn poor mind that can only think of one way to spell a word." -- Andrew Jackson
6DV8 Posted November 10, 2002 Author Posted November 10, 2002 Paul_C - Hey my man- I didn't click on the databse -Bingo there it is "run mysql". Thanks. I have the confidence now to copy over those php files then I'll run the SQL queery and Voila - I'll have what I want (I bloody hope so after all this) This Forum is so great! I have learnt so much about codes and databases and stuff right here. Who needs college (I did). To Paul_C - Thanks.
Paul_C Posted November 10, 2002 Posted November 10, 2002 You're welcome :D I hope it works out for you. I highly recommend doing as much of the hacking on a development server first and backing up everything (including your database) before making changes to a live site. "It's a damn poor mind that can only think of one way to spell a word." -- Andrew Jackson
6DV8 Posted November 10, 2002 Author Posted November 10, 2002 :( Spoke too Soon! MySQL said: You have an error in your SQL syntax near '`configuration` (`configuration_id`, `configuration_title`, `configuration_key`,' at line 1 Does this mean anything? This was run queery 1
Paul_C Posted November 10, 2002 Posted November 10, 2002 Make sure you didn't cut off INSERT INTO If you like I can set up the tables for you. "It's a damn poor mind that can only think of one way to spell a word." -- Andrew Jackson
6DV8 Posted November 10, 2002 Author Posted November 10, 2002 I tried it again with the other version (returns description on same line). That is I returned alll the files back then copied over the other version of php files I ran these queeries: INSERT INTO `configuration` (`configuration_id`, `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`) VALUES ('', 'Display Product Description (0=disable; 1=enable)', 'PRODUCT_LIST_DESCRIPTION', '1', 'Do you want to Display a truncated Product Description?', '8', '11', '2002-03-16 12:22:22', '2002-03-16 12:22:22', NULL, NULL); INSERT INTO `configuration` (`configuration_id`, `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`) VALUES ('', 'Length of Truncated Product Description', 'PRODUCT_LIST_DESCRIPTION_LENGTH', '50', 'How many characters would you like to display? ', '8', '12', '2002-03-16 18:51:26', '2002-03-16 18:51:26', NULL, NULL); And both returned syntax errors line 1 again (Sigh)
6DV8 Posted November 10, 2002 Author Posted November 10, 2002 How would you set up the tables for me (sounds very kind)?
Paul_C Posted November 10, 2002 Posted November 10, 2002 Email me the address of your phpmyadmin and any login info at [email protected] and I'll be happy to give a shot. "It's a damn poor mind that can only think of one way to spell a word." -- Andrew Jackson
6DV8 Posted November 10, 2002 Author Posted November 10, 2002 I had to take you up on your offer. Did you get my email. You are very generous. By the way - Did you do the Iron Orchid site - WOW!.
Paul_C Posted November 10, 2002 Posted November 10, 2002 Sorry for the delay, I just got back in.. long night. I just entered the tables into your database, I trust things are working (let me know if otherwise). I put in the info for version 2 of the mod (it's the one I wrote so it's really the only one I feel comfortable supporting thoroughly). I ended up entering the tables into the database by hand. For those interested (having similar problems), the code phpmyadmin echoed back to me for each query was: INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('', 'Display Product Description', 'PRODUCT_LIST_DESCRIPTION', '99', 'Set to 0 to disable, set to 99 to enable.', '8', '11', '2002-11-10 21:34:48', '2002-11-10 21:34:48', NULL, NULL); and INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('0', 'Length of Truncated Product Description', 'PRODUCT_LIST_DESCRIPTION_LENGTH', '500', 'How many characters would you like to display?', '8', '12', '2002-11-10 21:49:33', '2002-11-10 21:49:33', NULL, NULL); I did the setting up, modification, and theme for ironorchid.com but it is based on phpnuke. Eventually I'll make my own CMS, but www.ironorchid.com is, so far, functioning just fine as is (still looking for more writers though, if anyone is interested just pm me) I think I'll leave it be for now (I don't own the site, just co-administer it). "It's a damn poor mind that can only think of one way to spell a word." -- Andrew Jackson
6DV8 Posted November 10, 2002 Author Posted November 10, 2002 It was like the "Tooth Fairy had visited me and left without me even knowing. This is really great Paul. Above and beyond the call of duty. I'm still not sure what you do - are you the PC fairy, do you work for Oscom or do just help people out???? I wonder.................. Can I change the size of the font to the description characters. At the moment I have set the Product name as a Heading style and the description has copied that. Again that was some nice work paul. By the way uhhhh- did you kinda notice my other post about the drop down box by any chance. Just asking!!!!
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.