Current location: Hot Scripts Forums » Programming Languages » PHP » getting data

getting data

Reply
  #1 (permalink)  
Old
Wannabe Coder
 
Join Date: Jul 2010
Posts: 137
Thanks: 2
Thanked 0 Times in 0 Posts
getting data

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
Reply With Quote

Featured Marketplace Scripts (view more)

Reply

Bookmarks


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Forum Jump


All times are GMT -5. The time now is 04:38 PM.
vBulletin® Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.