<br />// configure your database settings<br />$host = "localhost"; // Server Name<br />$user= "***"; // Username<br />$password= "***"; // Password<br />$database="***"; // Photopost database name or forum database name<br /><br />// Connecting, selecting database<br />$link = mysql_connect ("$host", "$user", "$password") or die ('I cannot connect to the database.');<br />mysql_select_db ("$database")or die("Could not select database $database");<br /><br />$query = "SELECT id,cat,title,bigimage,medsize FROM {$pp_prefix}photos WHERE userid = {$UBBTuser} ORDER BY date DESC LIMIT $page,16";<br />$result = mysql_query($query);<br />$sth = $dbh -> do_query($query);<br />$numrows = $dbh -> total_rows($sth);<br /><br />$host = "localhost"; // Server Name<br />$user= "***"; // Username<br />$password= "***"; // Password<br />$database= "***"; // Threads database name or forum database name<br /><br />$link = mysql_connect ("$host", "$user", "$password") or die ('I cannot connect to the database.');<br />mysql_select_db ("$database")or die("Could not select database $database");<br /><br />if ( $numrows < 16 ) $nextpage = 0;<br />