< ?php
include("header.php");
require("connexion.php");
$connexion = mysql_connect($nom,$motdepasse,$base,$serveur);
$abc = $_GET[´abc´];
$query = " SELECT * FROM phpbb_posts WHERE forum_id=´6´";
$result = mysql_query($query);
while ( $val = mysql_fetch_array($result)) {
$post_id = $val["post_id"];
$post_subject = $val["$post_subject"];
$requete = " SELECT * FROM phpbb_posts_text WHERE post_id=´$post_id´";
$resultat = mysql_query($requete);
$data = mysql_fetch_array($resultat);
$post_subject = $data[´post_subject´];
$lettre = substr($post_subject, 0, 1);
if ( $abc==$lettre)
{
if ( !$post_subject==´´)
{
echo"$post_subject";
}
}
else
{
echo"Il n´y a rien qui commence par la lettre $abc";
}
}
include("footer.php");
? >