So this:
<?php require_once('Connections/njMySQL.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
if (PHP_VERSION < 6) {
$theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
}
$theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);
switch ($theType) {
case "text":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "long":
case "int":
$theValue = ($theValue != "") ? intval($theValue) : "NULL";
break;
case "double":
$theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
break;
case "date":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "defined":
$theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}
}
mysql_select_db($database_njMySQL, $njMySQL);
$query_rsPRODFULL = "SELECT LEDid, LEDtitle, LEDproductcode, LEDtypeID, LEDwattage, LEDdimmable, LEDbeamangle, LEDprice, LEDimgtmb, LEDdelete FROM LEDprods WHERE LEDdimmable = 1";
$rsPRODFULL = mysql_query($query_rsPRODFULL, $njMySQL) or die(mysql_error());
$row_rsPRODFULL = mysql_fetch_assoc($rsPRODFULL);
$totalRows_rsPRODFULL = mysql_num_rows($rsPRODFULL);
?>
...needs to be in the include file? Does the repeat region code also need to be in there?
Considering that all of my recordsets are different, do you still recommend Framework Builder plugins?
Thanks Jason.
Regards
NJ