Search:

Type: Posts; User: TheWhiteKnight

Search: Search took 0.01 seconds.

  1. Sticky: Ok, I got this thing to 100% work and I am SOOOO...

    Ok, I got this thing to 100% work and I am SOOOO happy.

    If you go in and set up the categories through the Admin panel (which I HIGHLY SUGGEST) then you will only have to modify 3 tables in the...
  2. Sticky: Just as an FYI, I emptied the data set in the...

    Just as an FYI, I emptied the data set in the sheet for you, you'll have to fill in the data, and the pricing, images and stuff, but the coding works (only for the products page) You need to write...
  3. Sticky: FYI, I got it to work :) This is NICE and fast....

    FYI, I got it to work :) This is NICE and fast.

    Remember when doing this you have to set it up a few times for different tables. Once for the products table, once for the product_description...
  4. Sticky: Yes, I was looking at that. The more and more I...

    Yes, I was looking at that. The more and more I am looking at the table structure of the DB the more I am rrealizing it is going to be more and more involved, but SO worth it in the end.

    From...
  5. Sticky: OMG, I can't believe that I was doing that. To...

    OMG, I can't believe that I was doing that. To my credit it was late last night when I was working on this, but still.... I'm one STUPID individual. ::ops

    Ok, now I'm on to make my INSERT INTO...
  6. Sticky: Also, if you follow Juxi's instructions, you have...

    Also, if you follow Juxi's instructions, you have to play with the Excel sheet a little bit, but I have this formula modified to automatically put the ' around the product_model that is read out of...
  7. Sticky: Ok, It's taking the SQL statement, but its...

    Ok,

    It's taking the SQL statement, but its giving me this:

    UPDATE products SET products_model = 'GM2359TB' WHERE products_id =1 LIMIT 1 ;

    ~~> # MySQL returned an empty result set (i.e....
  8. Sticky: Holy crap, I just saw that. I couldn't see it at...

    Holy crap, I just saw that. I couldn't see it at all in the excel spreadsheet or the PHPMyAdmin here. I would have enver even seen it if I hadn't recieved the email that there was a response for...
  9. Sticky: I've tried rewriting the SQL Statement to have it...

    I've tried rewriting the SQL Statement to have it put quotes around the GM59* and also the first "1" in the [1 LIMIT 1] section coding. I still get the error. I'm checking my SQL statements but...
  10. Sticky: Yup, I get the exact same error. My SQL...

    Yup, I get the exact same error.

    My SQL statement is this:

    UPDATE products SET products_model = GM2359TB WHERE products_ id = 1 LIMIT 1;

    The error is this:

    #1064 - You have an error in...
  11. Sticky: Juxi, ok I followed the instructions and it...

    Juxi,

    ok I followed the instructions and it didn't take much to figure everything out. Just a few minor questions. I PM'd you but after diving in the SQL coding I figured it out (Almost)

    Is...
Results 1 to 11 of 11
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR