hi all, i'm reposting cos it is getting frustrating for a beginner like me...
i have this problem wif converting mySQL to oracle using PHP....
My code:
$sql = "INSERT INTO USER_TRACK
VALUES(\"$user_id\", \"$sel_item\", \"$sel_item_title\",
\"$sel_item_qty\", \"$sel_item_price\", \"$sel_item_totalprice\",
\"$date_added\")";
$sql_result = mysql_query($sql,$connection)
or die ("Couldn't insert record!");
$item_count = "SELECT SUM(SEL_ITEM_QTY) FROM USER_TRACK
WHERE USER_ID = \"$user_id\"";
$item_result = mysql_query($item_count)
or die("Couldn't get count");
$item_count_total = mysql_result($item_result,0,"SUM(SEL_ITEM_QTY)");
what are the corresponding Oracle commands?
I tried OCIParse -->> OCIExecute -->> OCIFetchInto but it doesn't work
