Haggen
22 de Octubre del 2004

tengo un sitio desarrollado en PHP, y este tiene un buscador. Cuando se hace una busqueda y los resultados son desplegados en mas de 1 pagina, el link a la segunda pagina me avienta un error asi:

SQL/DB Error -- [You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIKE '%%' AND mnl_items.active='yes' GROUP BY]

--------------------------------------------------------------------
Aqui esta el codigo completo del php, por favor alguien sabra el error?

<?php

require ( "config.php" );

require ( "common.php" );

require ( "includes/mysql.php" );

require ( "includes/interface.php" );

require ( "includes/inc_reviews.php" );

require ( "global_config.php" );



global $db;

$search = $_POST['search'];

$search_type = $_POST['search_type'];



$limit = $CONFIG_VAR['num_records_display'];



$page = "search";



include_template ( $CONFIG_VAR['page_header_template'] );



$Prev = "Anterior";

$Next = "Siguiente";



// This creates the start of the main body table

echo "<!-- Start of main body table -->nn";



echo "<table width="" . $CONFIG_VAR['body_width_value'] . "" align="center" cellspacing="0" border="0" cellpadding="0">n";

echo "<tr>n";





// This creates the lefthand menu column

include_template ( $CONFIG_VAR['left_column_template'] );



// This creates the middle table

echo "<!-- Start of middle column -->nn";

echo "<td valign="top">n";



// This creates the breadcrumb trail


breadcrumbs( $page );

echo "<table class="txtwhite" bgcolor="061376" width="96%" align="center" cellpadding="0" cellspacing="0" border="0" class="tbodysmall"><tr><td width="25%">*<b>Titulo</b></td><td align="center" width="18%"><b>Calificación y Recomendación</b></td><td align="center" width="8%"><b>No. de Criticas</b></td><td width="45%" align="center"><b>Sinopsis</b></td></tR></table>n";

if ( empty ( $offset ) )

{

$offset = 0;

}



$query = "SELECT mnl_items.item_id,

mnl_items.item,

mnl_items.cat_id,

mnl_items.sub_cat_id,

mnl_items.description,

mnl_items.item_url,

mnl_items.url_click_through,

mnl_items.cost,

mnl_items.config_field_1,

mnl_items.config_field_2,

mnl_items.config_field_3,

mnl_items.config_field_4,

mnl_items.config_field_5,

mnl_items.config_field_6,

mnl_items.config_field_7,

mnl_items.config_field_8,

Count( mnl_reviews.review_id ) AS number_reviews,

IF(Avg( mnl_reviews.review_score ),Avg( mnl_reviews.review_score ),0) AS average_score,

SUM( mnl_reviews.review_score ) AS total_scores

FROM mnl_items

LEFT JOIN mnl_reviews ON mnl_items.item_id = mnl_reviews.item_id AND mnl_reviews.active='yes'

WHERE mnl_items." . $search_type . " LIKE '%$search%' AND mnl_items.active='yes'

GROUP BY mnl_items.item, mnl_items.item_id";



$result = $db->get_results ( $query );

$num_rows = $db->num_rows;



if ( $num_rows > 0 )

{

// run the query again with the limiter

$query .= " LIMIT " . $offset . "," . $limit;

$result = $db->get_results ( $query );

foreach ( $result as $val )

{

$cat_id = $val->cat_id;

$sub_cat_id = $val->sub_cat_id;

item_summary ( "summary", $val->item_id, $val->item, $val->description, $val->item_url, $val->url_click_through, $val->cost, $val->number_reviews, $val->average_score, $val->total_scores, $val->config_field_1, $val->config_field_2, $val->config_field_3, $val->config_field_4, $val->config_field_5, $val->config_field_6, $val->config_field_7, $val->config_field_8 );

}

}

else

{

print_message ( "No se encontro ninguna " . $CONFIG_VAR['item_type'] . " en nuestra base de datos", "Por favor regrese con su navegador." );

die;

}



$pages = intval ( $num_rows/$limit );

$url = "<a href="search.php?search=" . $search . "&sort=" . $sort;



if ( $num_rows % $limit)

{

$pages++;

}



echo "<table width="80%" border="0" cellpadding="5" cellspacing="1" align="center">n";

echo "<tr>n";

echo "<td class="mnlpagination" align="center">Página n";





for ( $i = 1;$i <= $pages;$i++ )

{

$newoffset=$limit*($i-1);

echo $url . "&offset=" . $newoffset . "">$i</a>n";

}





if ( $offset > 1 )

{

$prevoffset = $offset - $limit;

echo $url . "&offset=" . $prevoffset . "">$Prev</a>n";

}





if ( $num_rows > ( $offset + $limit ) )

{

$nextoffset = $offset + $limit;

echo $url . "&offset=" . $nextoffset . "">$Next</a>n";

}



echo "</tr>n";

echo "</table>n";



//This creates the main menu along the bottom of the main column

bottom_menu( "yes" );



echo "</td>n";

echo "<!-- End of middle column -->nn";



// This creates the right hand menu column

include_template ( $CONFIG_VAR['right_column_template'] );



// This ends the main body table

echo "</tr>n";

echo "</table>n";



//This creates the page footer

include_template ( $CONFIG_VAR['page_footer_template'] );

?>