Salut Tig,
voila le echo de ma requête
select a.articleid as a_articleid, c.id as c_id, c.titre as c_titre, c.contenu as c_contenu from accueil a, contenus c where c.id=a_articleid
je vourdrais faire cela :
select a.articleid as a_articleid<----- ce a_articleid dans ma clause where comment faire ?
where c.id=a_articleid
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
| $sql = "select a.articleid as a_articleid, " .
"c.id as c_id, " .
"c.titre as c_titre, " .
"c.contenu as c_contenu " .
"from accueil a, contenus c " .
"where c.id=a_articleid";
echo $sql;
$req = mysql_query($sql);
$data= mysql_fetch_array($req);
$c_titre=$data["c_titre"];
$c_contenu=$data["c_contenu"];
echo " <table width=\"100%\" border=\"0\" cellspacing=\"2\">";
echo "<tr>";
echo "<td>" . $c_titre . " " . $c_contenu . "</td>";
echo "</tr>";
echo "</table>"; |
Partager