I want to make a consult from two tables, but I have a little problen doing it...
$consult = "SELECT FROM CAPITULOS INNER JOIN AUTOR ON CAPITULOS.ID_autor = AUTOR.ID_autor WHERE CAPITULOS.ID_tipo LIKE '$ary_tipo->ID_tipo*' LIMIT $offset, $limit";
$query = mysql_query($consult, $link);
while ($ary = mysql_fetch_array($query)) {
// html code
}
...the problem is that if I don´t use LIKE, it returns some results, but if I use it, it doesn't return anything.
Can somebody tell me what I´m doing wrong?
