what does the code look like ammended
Here are the three sections of code can you please show me how to amend the query string.
{
mysql_select_db($database_PowerStoreConnection, $PowerStoreConnection);
$query_OptionValues = sprintf("SELECT ps3_options.OptionID, OptionName FROM ps3_options INNER JOIN ps3_optiongroups ON ps3_optiongroups.OptionGroupID = ps3_options.OptionGroupID WHERE ps3_options.OptionGroupID = %s ", GetSQLValueString($OGIDParam_OptionValues, "int"));
$OptionValues = mysql_query($query_OptionValues, $PowerStoreConnection) or die(mysql_error());
$row_OptionValues = mysql_fetch_assoc($OptionValues);
$totalRows_OptionValues = mysql_num_rows($OptionValues);
}
{ mysql_select_db($database_PowerStoreConnection, $PowerStoreConnection);
$query_OptionValues = sprintf("SELECT ps3_options.OptionID, OptionName FROM ps3_options INNER JOIN ps3_optiongroups ON ps3_optiongroups.OptionGroupID = ps3_options.OptionGroupID WHERE ps3_options.OptionGroupID = %s ", GetSQLValueString($OGIDParam_OptionValues, "int"));
$OptionValues = mysql_query($query_OptionValues, $PowerStoreConnection) or die(mysql_error());
$row_OptionValues = mysql_fetch_assoc($OptionValues);
$totalRows_OptionValues = mysql_num_rows($OptionValues);}
{ mysql_select_db($database_PowerStoreConnection, $PowerStoreConnection);
$query_OptionValues = sprintf("SELECT ps3_options.OptionID, OptionName FROM ps3_options INNER JOIN ps3_optiongroups ON ps3_optiongroups.OptionGroupID = ps3_options.OptionGroupID WHERE ps3_options.OptionGroupID = %s ", GetSQLValueString($OGIDParam_OptionValues, "int"));
$OptionValues = mysql_query($query_OptionValues, $PowerStoreConnection) or die(mysql_error());
$row_OptionValues = mysql_fetch_assoc($OptionValues);
$totalRows_OptionValues = mysql_num_rows($OptionValues);}
Thanks