Nouveau WRInaute
Bonjour
Quand je veux afficher ma page, j’ai des erreurs comme cela
Voici le script:
merci d'avance pour la réponse
Quand je veux afficher ma page, j’ai des erreurs comme cela
Code:
Warning: mysql_result() [function.mysql-result]: Unable to jump to row 1 on MySQL result index 4 in C:\wamp\www\bible\BibleVersion.php on line 49
Warning: mysql_result() [function.mysql-result]: Unable to jump to row 1 on MySQL result index 7 in C:\wamp\www\bible\BibleVersion.php on line 49
Warning: mysql_result() [function.mysql-result]: Unable to jump to row 1 on MySQL result index 10 in C:\wamp\www\bible\BibleVersion.php on line 49
.
.
.
.
.
Warning: mysql_result() [function.mysql-result]: Unable to jump to row 1 on MySQL result index 13321 in C:\wamp\www\bible\BibleVersion.php on line 49
Fatal error: Maximum execution time of 30 seconds exceeded in C:\wamp\www\bible\BibleVersion.php on line 44[/quote]
Voici le script:
Code:
<?php
$sautdeligne=26;
$db=mysql_connect("localhost", "root", "") or die("<H1>Can't connect to database.</H1>");
mysql_select_db("bible", $db);
if ($_GET["version"]!="")
$version=$_GET['version'];
else $version="7lsg";
if ($version=="7lsg")
$version_titre="Version Louis Second 1910";
else if ($version=="7drb") $version_titre="Version John N. Darby 1885";
else if ($version=="7ost") $version_titre="Version J.F. Ostervald 1996";
else if ($version=="7cra") $version_titre="Version Augustin Crampon 1923";
else if ($version=="7mar") $version_titre="Version David Matin 1744";
print "<br /><br /><span style=\"font-size:8pt;\">
<a href=\"BiblePassage.php\">Recherche par Passage</a> |
<a href=\"BibleMotsCles.php\">Recherche par Mots clés</a><br />
<a href=\"BibleVersion.php?version=7cra\">Crampon</a> |
<a href=\"BibleVersion.php?version=7drb\">Darby</a> |
<a href=\"BibleVersion.php?version=7mar\">Martin</a> |
<a href=\"BibleVersion.php?version=7ost\">Ostervald</a> |
<a href=\"BibleVersion.php?version=7lsg\">Second</a>
</span>
<br /><br />
<span style=\"font-size:10pt;\"><b>$version_titre</b></span><br /><br />";
$book="Genèse";
$selected_book="Genèse";
$chapter=1;
$verse=1;
$selected_verse=1;
print "<span style=\"font-size:7pt;\"><b>".$book."</b><br />";
while ($book_number <= 66)
{
$check_next=mysql_query("select * from $version where booktitle='$book' and chapter='$chapter' and verse='$verse'");
$count=mysql_num_rows($check_next);
if ($count=="0")
{
$get_bookno=mysql_query("select book from 7titles where booktitle='$book'");
$book_number=mysql_result($get_bookno, "0");
$book_number++;
$sautdeligne=26;
$new_book=mysql_query("select booktitle from 7titles where book='$book_number'");
if (mysql_numrows($new_book)!=0)
{
$selected_book=mysql_result($new_book, "0");
$selected_chapter=1;
$chapter=1;
$selected_verse=1;
print "<br /><br /><b>".$selected_book."</b><br />";
$book=$selected_book;
}
}
else
{
print "<a href =\"index.php?version=$version&book=$selected_book&chapter=$chapter&verse=$selected_verse\">".$chapter."</a> ";
$chapter++;
if ($chapter==$sautdeligne)
{$sautdeligne=$sautdeligne+25;
if ($book!="Genèse" or $chapter<30){
print "<br/>";
}
}
}
}
print "<br/><br />";
?>
merci d'avance pour la réponse