[williamh26]

hi guys i have the following queries that i need to fix it....

here passing variables using get method

PHP Code:

echo"<a href=\"index.php?content=escritura&cat=$capitulo_id&libro_id=$libro_id\">$capitulo</a>"; 

getting the variables in a new page called escritura

PHP Code:

<?php

                  $capitulo_id = intval ($_GET['cat']);

                  $libro_id = intval ($_GET['libro_id']);





                 $query="SELECT  id, libro_id, capitulo_id, texto,versiculo from rv1960 where capitulo_id = $capitulo_id and libro_id= $libro_id ";

                 $result=mysql_query($query);

                 while($row=mysql_fetch_array($result,MYSQL_ASSOC))

                 {



                         $libro_id =$row['libro_id'];

                         $versiculo =$row['versiculo'];

                         $texto =$row['texto'];



                         echo "<h3>$versiculo -- $texto</h3><br>";

                         echo"<p>";

                 }

?>

this is the database I used to retrieve the data from table rv1960;
rv1960.jpg

This is what we are looking for: When user clicks
Antiguo Testament (Old testament) ---> We got all the books; Genesis, Exodus...ect
When user click Genesis for example, we got all the Chapters (capitulos) of Genesis, then
When user clicks Capitulo 1 Genesis(Chapter 1 Genesis), we got the vers(versiculo) and text (texto) contains in that particular Chapter(capitulo)
this is the picture of the explanation
untilnow.jpg

Everything is fine for Genesis book and its chapters with it corresponding texts, but when I click on Exodus or any other book, it does not retrieve the data from... Can you please help me with it... Thanks