Avis aux programmeurs en mysql:
Ma page
/videos.php affiche des bugs:
Citation:
[phpBB Debug] PHP Notice: in file /homepages/39/d215458661/htdocs/videobourse/videos.php on line 8: mysql_query() [function.mysql-query]: Unable to save result set
[phpBB Debug] PHP Notice: in file /homepages/39/d215458661/htdocs/videobourse/videos.php on line 8: mysql_fetch_array(): supplied argument is not a valid MySQL result resource
[phpBB Debug] PHP Notice: in file /homepages/39/d215458661/htdocs/videobourse/videos.php on line 15: mysql_fetch_array(): supplied argument is not a valid MySQL result resource
Il me réffert donc aux lignes 8 et 15 qui sont les suivantes dans le code source de ma page:
8:
Code:
$date = mysql_fetch_array(mysql_query("SELECT * FROM video ORDER BY date DESC"));
15:
Code:
$nombreVideos = mysql_fetch_array(mysql_query("SELECT COUNT(*) AS nbVideos FROM video ORDER BY date DESC"));
C'est donc apparement un problème qui est déclenché lorsque j'utilise la fonction "FROM video ORDER BY date DESC".
Ce qui est bizarre c'est que ça ne me le fait pas sur les deux autres pages qui reprennent pourtant la même logique de code
http://www.videobourse.fr/video-analyse.php et
http://www.videobourse.fr/reportage.phpVoici les codes entiers:
Pages videos (qui bug):
Code:
<?php
include("phpBBCode.php");
include('connec.php');
$videoParPages = 80;
$req = mysql_query("SELECT * FROM video ORDER BY date DESC");
$date = mysql_fetch_array(mysql_query("SELECT * FROM video ORDER BY date DESC"));
$recent = $date['date'];
$page = $_GET['page'];
if(empty($page))
$page = 1;
$nombreVideos = mysql_fetch_array(mysql_query("SELECT COUNT(*) AS nbVideos FROM video ORDER BY date DESC"));
$nbVideos = $nombreVideos['nbVideos'];
$nbPages = ceil($nbVideos / $videoParPages);
$firstVideo = ($page - 1) * $videoParPages;
?>
page analyses:
Code:
<?php
include("phpBBCode.php");
include('connec.php');
$videoParPages = 30;
$req = mysql_query("SELECT * FROM video
WHERE (idCat IN (SELECT idFils FROM categories, peres
WHERE categories.id = peres.idFils
AND idPère IN (SELECT idFils FROM categories, peres
WHERE categories.id = peres.idFils
AND idPère = 1))
OR idCat IN (SELECT idFils FROM categories, peres
WHERE categories.id = peres.idFils
AND idPère IN (SELECT idFils FROM categories, peres
WHERE categories.id = peres.idFils
AND idPère IN (SELECT idFils FROM categories, peres
WHERE categories.id = peres.idFils
AND idPère = 1))))
ORDER BY date DESC");
$date = mysql_fetch_array($req);
$recent = $date['date'];
$page = $_GET['page'];
if(empty($page))
$page = 1;
$nombreVideos = mysql_fetch_array(mysql_query("SELECT COUNT(*) AS nbVideos FROM video
WHERE (idCat IN (SELECT idFils FROM categories, peres
WHERE categories.id = peres.idFils
AND idPère IN (SELECT idFils FROM categories, peres
WHERE categories.id = peres.idFils
AND idPère = 1))
OR idCat IN (SELECT idFils FROM categories, peres
WHERE categories.id = peres.idFils
AND idPère IN (SELECT idFils FROM categories, peres
WHERE categories.id = peres.idFils
AND idPère IN (SELECT idFils FROM categories, peres
WHERE categories.id = peres.idFils
AND idPère = 1))))
AND idCat <> 21
ORDER BY date DESC"));
$nbVideos = $nombreVideos['nbVideos'];
$nbPages = ceil($nbVideos / $videoParPages);
$firstVideo = ($page - 1) * $videoParPages;
?>
Page reportages:
Code:
<?php
include("phpBBCode.php");
include('connec.php');
$videoParPages = 30;
$req = mysql_query("SELECT * FROM video
WHERE (idCat IN (SELECT idFils FROM categories, peres
WHERE categories.id = peres.idFils
AND idPère IN (SELECT idFils FROM categories, peres
WHERE categories.id = peres.idFils
AND idPère = 2)))
OR idCat IN (SELECT idFils FROM categories, peres
WHERE categories.id = peres.idFils
AND idPère IN (SELECT idFils FROM categories, peres
WHERE categories.id = peres.idFils
AND idPère IN (SELECT idFils FROM categories, peres
WHERE categories.id = peres.idFils
AND idPère = 2)))
ORDER BY date DESC");
$date = mysql_fetch_array($req);
$recent = $date['date'];
$page = $_GET['page'];
if(empty($page))
$page = 1;
$nombreVideos = mysql_fetch_array(mysql_query("SELECT COUNT(*) AS nbVideos FROM video
WHERE (idCat IN (SELECT idFils FROM categories, peres
WHERE categories.id = peres.idFils
AND idPère IN (SELECT idFils FROM categories, peres
WHERE categories.id = peres.idFils
AND idPère = 2)))
OR idCat IN (SELECT idFils FROM categories, peres
WHERE categories.id = peres.idFils
AND idPère IN (SELECT idFils FROM categories, peres
WHERE categories.id = peres.idFils
AND idPère IN (SELECT idFils FROM categories, peres
WHERE categories.id = peres.idFils
AND idPère = 2)))
ORDER BY date DESC"));
$nbVideos = $nombreVideos['nbVideos'];
$nbPages = ceil($nbVideos / $videoParPages);
$firstVideo = ($page - 1) * $videoParPages;
?>
Je précise que ces messages d'erreurs sont apparus du jour au lendemain sans que je ne touche au code et que mon hébergeur est 1and1.
Merci par avance pour votre aide.