PHP experts - Custom Field and Listing Orders

-- url of the page with the problem -- : www.apli.movil-plus.com
-- HikaShop version -- : 2.0.0
-- Joomla version -- : 3.1.5

Good afternoon ,

Request help to display a custom field ( table "item" ) in the list of orders ( listing.php ) .

My PHP skills are scarce, manuals have searched the net and the most I 've gotten is to show the contents of the entire table in the list of orders, however, my only desire is to show the contents of the custom field based on logged user .

By using the following code:





The result in each row of the column shows ALL records shown in the screenshot , I just like to put the associated order number shown .

I hope someone help me with this problem took a long time and can not find solution.

Greetings and thanks in advance.

The line:
$registros=mysql_query("SELECT imei2 FROM jos_hikashop_order_product",$conexion) or
die("Problemas en el select:".mysql_error());
is not correct.
You would need instead something like that:
$registros=mysql_query("SELECT imei2 FROM jos_hikashop_order_product WHERE order_id="(int).$row->order_id,$conexion) or
die("Problemas en el select:".mysql_error());

Hi, thanks for the reply,


I changed the line you and not charge you indicate page is completely blank.

Turn on the debug mode and error reporting options of the joomla configuration and try again. You should see an error message telling you what's wrong.

Hi Nicolas,

This is the error:


Parse error: syntax error, unexpected T_INT_CAST in /hosting/www/movil-plus.com/apli/templates/rt_paradigm/html/com_hikashop/order/listing.php on line 143

And the line number 143:

$registros=mysql_query("SELECT imei2 FROM jos_hikashop_order_product WHERE order_id="(int).$row->order_id,$conexion) or die("Problemas en el select:".mysql_error());



Thx

Hi,

Using the code tag is better for code display.
At this moment you will see that there was a point between the (int) and the $row->order_id.

Code fixed:
Regards,

Perfect!!

Thank you!, This part was essential for my project.

Really, thanks for your attention and speed in the solution.