mysqli syntax
Hey Jason
Am trying to convert
<?php
$_GET["GalleryContent"] = "gallery_".$row_PageContents['ProductContentsID'];
$colname_Gallery = "-1";
if (isset($_GET['GalleryContent'])) {
$colname_Gallery = $_GET['GalleryContent'];
}
mysql_select_db($database_PowerCMSConnection, $PowerCMSConnection);
$query_Gallery = sprintf("SELECT * FROM gallery WHERE GalleryPage = %s ORDER BY GalleryOrder ASC", GetSQLValueString($colname_Gallery, "text"));
$Gallery = mysql_query($query_Gallery, $PowerCMSConnection) or die(mysql_error());
$row_Gallery = mysql_fetch_assoc($Gallery);
$totalRows_Gallery = mysql_num_rows($Gallery);
?>
into mysqli
So far I have managed to put together
<?php
$Gallery = new WA_MySQLi_RS("Gallery",$DBConnection,1);
$Gallery->setQuery("SELECT * FROM gallery WHERE GalleryPage = ? ORDER BY GalleryOrder ASC");
$Gallery->bindParam("s", "".$_GET['GalleryContent'] ."", "-1"); //colname
$Gallery->execute();
?>
I just dont know how (or where) the mysql line $_GET["GalleryContent"] = "gallery_".$row_PageContents['ProductContentsID']; gets added in the mysqli
cheers
Jamie