Printable Version of Topic

<?php

if(isset($_POST['modifier']))

{
include("../include/config.php");

$news_id = $_POST["liste_news"];

$connection = mysql_connect("$db_host","$db_login","$db_pass");

mysql_select_db($db_name) or die ("pas de connection");

$sql = "SELECT news_auteur,news_titre,news_contenu FROM site_news WHERE news_id='$news_id'";
mysql_query($sql);
echo"essai";

mysql_close();

}


?>

<P><u><H5>Veuillez sélectionner la news a modifier :</H></u></p><br><br>


<P ALIGN="CENTER">
<select name="liste_news">

<?php
echo'<FORM method="post" action="' .$_SERVER['PHP_SELF']. '">';

$connection = mysql_connect($db_host,$db_login,$db_pass);

// test la connection

if ( ! $connection )

die ("connection impossible");

mysql_select_db($db_name) or die ("pas de connection");

$sql = 'SELECT news_titre,news_id FROM site_news';

$req = mysql_query($sql) or die('Erreur SQL !<br />'.$sql.'<br />'.mysql_error());

while($data = mysql_fetch_assoc($req))

{

echo"
<option value=".$data['news_id'].">".$data['news_titre']."</option>
";

}
echo"</form>";

mysql_close();

?>
</select></p><br><br>
<P ALIGN="CENTER"><INPUT name="modifier" type="submit" value="Modifier">
<INPUT name="supprimer" type="submit" value="Supprimer">
</p>