fabiangarga

I asked to a person that knows a lot more than me and found me a solution to my problem. I dont know how big is this forum comunity, or if mysql is not the most popular topic, but thanks to requinix for the answers. The query was solved using CONCAT SELECT pc.id, p.product_id, p.price, pc.Description FROM table1 p, table2 pc WHERE pc.Description like concat('%price=', p.product_id, '%') Hope that someone found this answer useful

It will be ugly c: I'm gonna try doing on php, will post the answer later. Thanks!

My bad, in the description also i have somewhere in the test a string with {id="product_id"} and this one is unique, what could happen is that one article on the description has more than one product_id, but i think it will not screw my future php code. I cant alter the table, because it will mess up the e-commerce, i dont know if this could be done with mysql, probably yes, but it will require a lvl of mysql that i dont have, i was thinking solve it using php and , like having 2 multi arrays with each tables, and then with php, serch into the second table and make a third array with the data i need. If i could make it in one sql query it will be fantastic.

Hi guys, im new on this forum, i found it browsing for a few sql problems. I am Fabian and i have 21 years old, i work as freelance Website development. My main language is Spanish, but i try my best writing on english. I been working since 1 years on the wesbite world, my main programing laguage is javascript, using a lot of jquery library, also php and xml. I made a few tipical html websites but for most of them i use wordpress. A few years ago i also developped a few administrative apps on c# and some test with phyton and c++. Im not a genius when programing refers but i really enjoy building, learning and improving my knowledge.

Im working with a joomla data base, one table is from a e-commerce plugin and the other is from the article description wich contains in some part the price of the product. I dont need to insert, i need to select and get a feedback with the id_product, ID of the article wich contains the price of the product on the description and the price. The price, and id of the product i can get it easly from the table of the e-commerce plugin, but i need to get on the same feedback the ID of the article wich contains the price. This is an example of the 2 tables The feed will be something like this:

Hi guys, im new on this forum. I have a little problem with a SQL query, im trying to get a query feedback but im lost. I got 2 tables Table 1: ID_product , price Then have a second table Table 2: ID, Description On the second table, the column description contains a string, and somewhere in the string it has this text "{price = A}", the price is the same from the table 1. What im trying to figure out, is how i can display ID_product, price,from table 1, and also the ID from the row that contains the same price as the table 1 in the string. Im not sure if im clear, im not really good writing and less in english. I will apreciate the help, thanks!