= '3' AND comment_status = 'active' ORDER BY comment_date DESC LIMIT $num,$num2 ";
$sentencia_coment = $pdo->prepare($sql);
$sentencia_coment->bindParam(':iniciar', $iniciar, PDO::PARAM_INT);
$sentencia_coment->bindParam(':paginacion', $paginacion, PDO::PARAM_INT);
$sentencia_coment->execute(array($num,$num2));
$result_coment = $sentencia_coment->fetchAll();
//$result = mysql_query($sql) or die(mysql_error());
$result = mysqli_query($conexion,$sql) or die(mysql_error());
//if ( mysql_num_rows($result) > 0 ){
if ( mysqli_num_rows($result) > 0 ){
// while ( $row = mysql_fetch_array( $result ) ){
while ( $row = mysqli_fetch_array( $result ) ){
$reviewSite = $row['reviewSite'];
$comentador_id = $row['persons_id'];
$guest_name = $row['guest_name'];
$comment_date = $row['comment_date'];
$visit_date = $row['visit_date'];
$product_evaluation = $row['product_evaluation'];
$comment = $row['comment'];
$comment_reply = $row['comment_reply'];
$review_url = $row['review_url'];
//RECOGEMO LA INFROMACION DE LA PERSONA QUE COMENTA ------------------------------------------
$sql2 = "SELECT * FROM persons WHERE persons_id = '$comentador_id'";
//$result2 = mysql_query($sql2) or die(mysql_error());
$result2 = mysqli_query($conexion,$sql2) or die(mysql_error());
// if ( mysql_num_rows($result2) > 0 ){
if ( mysqli_num_rows($result2) > 0 ){
//while ( $row2 = mysql_fetch_array( $result2 ) ){
while ( $row2 = mysqli_fetch_array( $result2 ) ){
$guest_title = $row2['title'];
//$guest_name = $row2['name'];
$guest_lastname1 = $row2['lastname1'];
$guest_lastname2 = $row2['lastname2'];
}}
?>
REVIEW BY:
Business reply: