convert mysql to mysqli
Hey Ray
Just trying to convert this old mysql to mysqli
<?php
$_GET['OptionGroupID'] = $row_ProductDetail["ProductID"];
$colname_OptionGroups = "-1";
if (isset($_GET['OptionGroupID'])) {
$colname_OptionGroups = $_GET['OptionGroupID'];
}
mysql_select_db($database_PowerCMSConnection, $PowerCMSConnection);
$query_OptionGroups = sprintf("SELECT * FROM optiongroups WHERE OptionProductID = %s", GetSQLValueString($colname_OptionGroups, "int"));
$OptionGroups = mysql_query($query_OptionGroups, $PowerCMSConnection) or die(mysql_error());
$row_OptionGroups = mysql_fetch_assoc($OptionGroups);
$totalRows_OptionGroups = mysql_num_rows($OptionGroups);
?>
So far I have
<?php
$OptionGroups = new WA_MySQLi_RS("OptionGroups",$DBConnection,0);
$OptionGroups->setQuery("SELECT * FROM optiongroups WHERE OptionProductID = ?");
$OptionGroups->bindParam("i", "".$_GET['OptionGroupID'] ."", "-1"); //colname
$OptionGroups->execute();
?>
but am a little stuck in finishing it off.....
Cheers
Jamie