Welcome to the new platform of Programmer's Heaven! We apologize for the inconvenience caused, if you visited us from a broken link of the previous version. The main reason to move to a new platform is to provide more effective and collaborative experience to you all. Please feel free to experience the new platform and use its exciting features. Contact us for any issue that you need to get clarified. We are more than happy to help you.
How do I return the product from only using the first three letters?
I have a MySQL database, which is accessed via php, one of the tables is named products, within the table is a field named products_model, which contains all the products used for the application. Some start with DVD, some with VHS, others with DJ, SE, etc. What i am wanting to do is to select and display only certain items, where I can use the first two or three characters to filter for displaying.
All products_model have up to 8 alpha-numeric characters.
I know this is basic, however I am just learning. The section marked in red is what I am trying to figure out how to code that.
Any help is appreciated.
here is the line I want to modify:
$products_new_query_raw = "select p.products_id, pd.products_name, p.products_image, p.products_price, p.products_tax_class_id, p.products_date_added, m.manufacturers_name" . $new_fields . " from " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on (p.manufacturers_id = m.manufacturers_id), " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1'" . SHOW_PRODUCTS_NEW_SINCE2 . [red]"and p.products_model = "[/red] . " and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "'" . $order_by;
0 · ·