Fonction requete mysql

Version imprimable

Bonjour,

Pouvez vous me dire ce que ne va pas dans mon code svp ?

Et t'il possible de faire une fonction requete mysql ?

index.php

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
 
<?php
require("./fonction.php");
 
connectMaBase();
 
$parm1="SERVER";
$parm2="DATE_SERVER";
 
requete_select($parm1, $parm2);
 
while($resultat1 = mysql_fetch_array($query1))
{
echo $resultat1[0];
}
 
?>

fonction.php

Code:

1
2
3
4
5
6
 
function requete_select($parm1, $parm2)
{
$sql1 =("SELECT * FROM $parm1 ORDER BY $parm2 DESC LIMIT 10");
$query1 = mysql_query($sql1) or die('Erreur SQL !<br>'.$sql1.'<br>'.mysql_error());
}

Merci d'avance.

Bonjour,

Changes

Code:

1
2
 
$sql1 =("SELECT * FROM $parm1 ORDER BY $parm2 DESC LIMIT 10");

Code:

1
2
 
$sql1 ="SELECT * FROM $parm1 ORDER BY $parm2 DESC LIMIT 10";

J'ai une érreur :(

Merci pour ta réponse :

Citation:

Notice: Undefined variable: query1 in /var/www/html/site/index.php on line 71 Warning: mysql_fetch_array() expects parameter 1 to be resource, null given in /var/www/html/site/index.php on line 71
Code:

1 2 3 4 5 6 function requete_select($parm1, $parm2) { $sql1 ="SELECT * FROM $parm1 ORDER BY $parm2 DESC LIMIT 10"; $query1 = mysql_query($sql1) or die('Erreur SQL !<br>'.$sql1.'<br>'.mysql_error()); }
Code:

1 2 3 4 5 6 7 8 9 10 11 12 connectMaBase(); $parm1="SERVER"; $parm2="DATE_SERVER"; requete_select($parm1, $parm2); while($resultat1 = mysql_fetch_array($query1)) { echo $resultat1[0]; }

C'est normal, il ne connais pas $query1 dans ton code ...

Modifications

Code:

1
2
3
4
5
6
7
 
function requete_select($parm1, $parm2)
{
$sql1 ="SELECT * FROM $parm1 ORDER BY $parm2 DESC LIMIT 10";
$query1 = mysql_query($sql1) or die('Erreur SQL !<br>'.$sql1.'<br>'.mysql_error());
return($query);
}

Code:

1
2
3
4
5
6
7
8
9
10
11
12
 
connectMaBase();
 
$parm1="SERVER";
$parm2="DATE_SERVER";
 
$query1 = requete_select($parm1, $parm2);
 
while($resultat1 = mysql_fetch_array($query1))
{
echo $resultat1[0];
}

10/10/2012, 11h34
snorky94

ca fonctionne parfait merci !!!!!!!!!!!!! ;)