Getting Data

[Barand]

In the links for Genesis the id_libro values are 1. When you list the links for Exodus the id_libro in the link needs to be 2 and so on. You get the libro values from your database as you are creating the links.

[williamh26]

exactly... but why it does not show.... do i hve to do another link?

[williamh26]

This show that it picks the exact id from the database but it does not retrieve the text

 

http://www.youtube.com/watch?v=Pqqh5sUonQc

Edited November 2, 2012 by williamh26

[Barand]

Each chapter/capitulo has one link

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

 

When you list those for Genesis, the id_libro value in the links will be 1

 

When you list those for Exodus, the id_libro value in the links will be 2

 

and so on

[williamh26]

actually not i was looking in a wrong part.. according with the database exodo starts a id_libro where link id =2

 

the id=2 starts in id number 1534...

 

 

[williamh26]

i understant that and it supposed to be like that, however when i click exodus--> chapter 1 --> does not show the text....

[Barand]

View the page source and check the values in the links

[williamh26]

in the link perhaps shoud i put the id field

like this:

<a href=\"index.php?content=escritura&cat=$id=id&$capitulo_id&libro_id=$libro_id\">

 

and the code will get

<?php

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

			 $query="SELECT  * from rv1960 where capitulo_id = $capitulo_id and libro_id= $libro_id and id=$id";
			 $result=mysql_query($query);
			 while($row=mysql_fetch_array($result,MYSQL_ASSOC))
			 {
				    $id =$row['id'];
					 $libro_id =$row['libro_id'];
					 $versiculo =$row['versiculo'];
					 $texto =$row['texto'];
					 echo "<h3>$versiculo -- $texto</h3><br>";
					 echo"<p>";
			 }
?>

 

But i dont know in the select query if it is rigth to put two "and"

 

i try it.. and i got this result:

 

Undefined variable: id in C:\wamp\www\Iglesia viviente\includes\capitulo.inc.php

[Barand]

If you put the id in the query you will limit the results to a single row.

 

You want all the rows for libro/capitulo.

 

Did you check the links in the page source?

[williamh26]

yes

it looks fine... maybe some modification in the sql query.?

 

Source code:

 

<?php

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

			 $query="SELECT * 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>";
			 }
?>

Edited November 2, 2012 by williamh26

[Barand]

What was the output from that ?

[williamh26]

It shows only the chapters from Genesis and when I click Exodo nothing happens

[Barand]

I'm sure we've explained enough to you about how it should work, but we cannot debug it for you. That's down to you - we can't see the code or the output.