"Warning" error PHP

Question

I need help with this:

 $query="SELECT productos.id_producto, productos.nombre, productos.precio, 
 ci.quantity, ci.quantity * productos.precio AS subtotal  
        FROM productos p  
            LEFT JOIN cart_items ci 
                ON ci.id_producto = productos.id_producto"; 
 $com = mysqli_query($cnx, $query);
 $row = mysqli_fetch_assoc($com);

Warning: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, string given in "XXXXX" on line 34

In this case is line = 6.

Sorry if this is "simple php" error.

I'm learning PHP.

you're mixing different mysql apis here – Funk Forty Niner Dec 28 '17 at 00:05 — Funk Forty Niner, Dec 28 '17 at 00:05

score 1 · Answer 1 · answered Dec 28 '17 at 00:08

You have an error on your SQL statement. You've given an alias to your table productos as p but your calling the fields using the table name itself. Try to remove the alias name and you're good to go.

$query="SELECT productos.id_producto, productos.nombre, productos.precio, 
 ci.quantity, (ci.quantity * productos.precio) AS subtotal  
        FROM productos  
            LEFT JOIN cart_items ci 
                ON ci.id_producto = productos.id_producto";

I can't see how this partial answer could get an upvote. – Funk Forty Niner Dec 28 '17 at 00:19 — Funk Forty Niner, Dec 28 '17 at 00:19

"Warning" error PHP

1 Answers1