I have quesion on which fetch statement to display the queries from Oracle. There ocifetch, ocifetchinto, ocifecthstatment.
Here is the code example using ocifetchinto. I want to display the column attribute of every tuples fetch. Is this the correct way? Also on $rows['Title'], do you apostrophe or quoation aroun the word title; in my example I put an aprostrophe, which way is correct, I seem other use quoatiation mark and apostrophe?
$query = "SELECT * FROM CART C, ITEMS I
WHERE C.SKU = I.SKU AND C.COOKIE_ID = getCartID()".
ORDER BY I.NAME ASC";
$stmt = ocipasrse($conn, $query);
ociexecute($stmt);
while (ocifetchinto($stmt, $rows, OCI_ASSOC))
{
.
.
.
.
print $rows['TITLE'];
}