Search results

  1. slasher

    Parse XML nodes into mysql

    I'm trying to insert nodes into mysql Trying to loop through each node & I think the foreach section is wrong getting the info repeated Thanks in advance <?xml version="1.0" encoding="UTF-8"?> <GetCategorySpecificsResponse xmlns="urn:ebay:apis:eBLBaseComponents">...
  2. slasher

    Am i the only one not disappointed by IB?

    Stockists will have them by Friday at the earliest, but they "can not" sell them until Sunday 29th..... that's the official word
  3. slasher

    mysql GROUP_CONCAT update select help

    Perfect.....many thanks Rob, understand it now :)
  4. slasher

    mysql GROUP_CONCAT update select help

    Sorry had to go away family issues :( Thanks for all of the replies Trying to update from 1 table to another with a sub select query update test, atributes set test.spec=(SELECT GROUP_CONCAT(CONCAT_WS('','<li><span class="spec">', atributes.FriendlyName3, '</span>'...
  5. slasher

    mysql GROUP_CONCAT update select help

    Thanks for all of the repies Trying to format in this way (see below) This query works but would like to be able to put some li span tags like below I know concat_ws allows formatting to this extent but group_concat doesn't Code | name | value...
  6. slasher

    mysql GROUP_CONCAT update select help

    sorted it.....concat not group_concat Many Thanks again
  7. slasher

    mysql GROUP_CONCAT update select help

    Thanks... I do appreciate your help Sorry I'm still learning :confused: .... is this what you mean't? doesn't work works perfectly but need the sub select to work Sorry for sounding :confused: I can't get my head around why if I break the above query down it works fine & the...
  8. slasher

    mysql GROUP_CONCAT update select help

    Hi anyone know why this doesn't work.... it doesn't update any rows even though narrowby table has all of the nby_pid values the above doesn't work then if I run this update with the sub query included it works (like below) same query but broken down without the sub-select ....which does...
  9. slasher

    SQL UPDATE 'where EXISTS' issue - 2 tables

    Perfect Many thanks ZombieFan
  10. slasher

    SQL UPDATE 'where EXISTS' issue - 2 tables

    Hi Wonder if someone can give me some pointers of what's wrong with this update statement Use MYSQL all the item but SQL is slightly different & just starting although they are similar update lists set lists.STOCKCODE = (select stock.STOCKCODE from stock...
  11. slasher

    MYSQL Help comparing 2 tables

    OK have removed all punctuation etc but this query doesn't return any values Select cameras.title, cameras.sku, cameras.price from cameras, cameras_digital where cameras.title REGEXP('%',cameras_digital.title,'%');
  12. slasher

    PHP e-commerce/shopping cart suggestions

    Interspire is good & you can tweak it but costs Magento is good but you will need a dedicated server to run it, as it can be very slow on shared hosting Zen cart is worth a look as it uses div instead of tables over oscommerce less code Oscommerce has more mods available than Zencart...
  13. slasher

    oscommerce help please

    This changes the border colour
  14. slasher

    oscommerce help please

    look in images/infobox/ all the gifs are the top of the boxes as for the box backgrounds & border look in the stylesheet.css default oscommerce stylesheet .infoBox { background: #b6b7cb; } .infoBoxContents { background: #f8f8f9; font-family: Verdana, Arial, sans-serif...
  15. slasher

    MYSQL Help comparing 2 tables

    Hi I looked at the REGEXP function, but could work out how to write the query, not used it before. Select cameras.title, cameras.sku, cameras.price from cameras, cameras_digital where cameras.title REGEXP('%',cameras_digital.title,'%'); returns no matches I had a...
  16. slasher

    oscommerce help please

    Hi If you want different boxes find the includes/classes/boxes.php Create a new class Create new style in the stylesheet add new css to the stylesheet look for the boxes folder & simply change the class created in the boxes.php file i.e. search.php If you only want to change the look...
  17. slasher

    MYSQL Help comparing 2 tables

    Need help comparing titles from 2 databases, looking for a match on the model number in the title, lots of different models eg closest match 500D 500-D (i.e. 500) S930 S 930 (i.e. 930) This query works only if the title is the exact same Select cameras.title, cameras.sku...
  18. slasher

    audio from mobo?

    Does this help?
  19. slasher

    64base encoded XML

    Perfect :) Big thanks again for your help
  20. slasher

    Laptop keeps turning itself off, help!

    Just my opinion... I would find it unlikely for the thermal properties of a heatsink to change unless clogged up with dust. Changing the heatsink would do nothing, unless it's actual shape had changed i.e. become concave or convex of which a new heatsink would solve the issue I would...
Back
Top Bottom