Page 1 of 1

Is this Possible with Mysql??

Posted: Thu Nov 24, 2005 8:42 am
by dude81
Is Binding a database variable possible in mysql??
like we do it with oracle

Code: Select all

$query="BEGIN BEGIN WEB_UTILS_PKG.UPDATE_EVENT_RESERVATION ('$company','$xyz,'$ev_id',TRUNC(TO_DATE('$ev_date', 'DD-MON-YY')),'$ev_no','Y','Y',:V_RESERVATION_STATUS,:V_SEAT_NUMBER); END; END;"

Code: Select all

OCIBindByName($stmt, ":V_RESERVATION_STATUS", $RESERVATION_STATUS, 1);
OCIBindByName($stmt, ":V_SEAT_NUMBER", $SEAT_NO, 6);
Thanks
Dude