• Member Avatar for Szabi Zsoldos
    Szabi Zsoldos

    Replied To a Post in MySQL query getting too complex

    Can you post an sqlfiddle ?
  • Member Avatar for Szabi Zsoldos
    Szabi Zsoldos

    Replied To a Post in REGEXP or Select Replace then GROUP BY

    Never have known about this simple LIKE usage in this form! Great input diafol!!!
  • Member Avatar for Szabi Zsoldos
    Szabi Zsoldos

    Marked Solved Status for REGEXP or Select Replace then GROUP BY

    Hey guys, I am having some difficulties regarding a select query logic. Then I have a table with products and it has a column -> submodel with all kind of …
  • Member Avatar for Szabi Zsoldos
    Szabi Zsoldos

    Replied To a Post in REGEXP or Select Replace then GROUP BY

    Got it solved :) SELECT CONCAT(SUBSTRING_INDEX(i.submodel, '(', 1), '', SUBSTRING_INDEX(i.submodel, ')', -1)) AS model FROM products.items as i WHERE i.vendor_name LIKE '%(Product_SH)' GROUP BY 1 ![f3a468a094655ec9d09f858762daffea](/attachments/small/2/f3a468a094655ec9d09f858762daffea.png "align-left")
  • Member Avatar for Szabi Zsoldos
    Szabi Zsoldos

    Edited REGEXP or Select Replace then GROUP BY

    Hey guys, I am having some difficulties regarding a select query logic. Then I have a table with products and it has a column -> submodel with all kind of …
  • Member Avatar for Szabi Zsoldos
    Szabi Zsoldos

    Edited REGEXP or Select Replace then GROUP BY

    Hey guys, I am having some difficulties regarding a select query logic. Then I have a table with products and it has a column -> submodel with all kind of …
  • Member Avatar for Szabi Zsoldos
    Szabi Zsoldos

    Edited REGEXP or Select Replace then GROUP BY

    Hey guys, I am having some difficulties regarding a select query logic. Then I have a table with products and it has a column -> submodel with all kind of …
  • Member Avatar for Szabi Zsoldos
    Szabi Zsoldos

    Created REGEXP or Select Replace then GROUP BY

    Hey guys, I am having some difficulties regarding a select query logic. Then I have a table with products and it has a column -> submodel with all kind of …
  • Member Avatar for Szabi Zsoldos
    Szabi Zsoldos

    Began Watching REGEXP or Select Replace then GROUP BY

    Hey guys, I am having some difficulties regarding a select query logic. Then I have a table with products and it has a column -> submodel with all kind of …
  • Member Avatar for Szabi Zsoldos
    Szabi Zsoldos

    Replied To a Post in PHP Dropdown List Populated from MySQL

    well you have campus_name not company_name, check that please.
  • Member Avatar for Szabi Zsoldos
    Szabi Zsoldos

    Replied To a Post in PHP Dropdown List Populated from MySQL

    Put these two lines at the top of your file and tell us what errors does it give to you. <?php error_reporting(E_ALL); ini_set("display_errors", 1); ?> Again read my first post …
  • Member Avatar for Szabi Zsoldos
    Szabi Zsoldos

    Replied To a Post in PHP Dropdown List Populated from MySQL

    just saw that i forgot a ' in $array['yourField1']
  • Member Avatar for Szabi Zsoldos
    Szabi Zsoldos

    Began Watching PHP Dropdown List Populated from MySQL

    I am trying to populate a select box from my database. The value chosen must be the id of the item, and the text shown the name of the item …
  • Member Avatar for Szabi Zsoldos
    Szabi Zsoldos

    Replied To a Post in PHP Dropdown List Populated from MySQL

    Something is not right in your logic. $company_id = $_POST['company_id']; $company_name = $_POST['company_name']; // What do you do with these post`s ? You do not close your <select> form A …
  • Member Avatar for Szabi Zsoldos
    Szabi Zsoldos

    Began Watching Image Zoom Jquery

    Hi , I'm developing a HTML page in which user have an option to zoom image two time in the same frame same as [goo.gl/PZweZ9](http://www.goo.gl/PZweZ9) , I search alot but …
  • Member Avatar for Szabi Zsoldos
    Szabi Zsoldos

    Replied To a Post in Image Zoom Jquery

    it is almost like asos.com :))

The End.