sa incep cu exact ce as avea nevoie: la www.knicksonline.as.ro/0304/schedule.php am creat programul meciurilor din sezon 2003-04 am folosit urmatorul cod:
CODE | <?echo ' <div align=center><span class=headline>2003-04 Schedule</span></div><p>'; echo ' <center><table width=100% border=0 cellpading=1 cellspacing=0><tr><td bgcolor=003399 colspan=7><font color=ffffff><b>Knicks Schedule 2003-04</b></font></td></tr><tr> <td bgcolor=ff8800 width=9%><font color=003399><b>Game</b></font></td> <td bgcolor=ff8800 width=25%><font color=003399><div align=center><b>Date</b></div></font></td> <td bgcolor=ff8800 width=27%><font color=003399><b>Opponent</b></font></td> <td bgcolor=ff8800 width=16%><font color=003399><b>Result</b></font></td> <td bgcolor=ff8800 width=15%><font color=003399><b>Record</b></font></td> <td bgcolor=ff8800 width=8%><font color=003399></font></td> </tr>'; $sql = 'SELECT * FROM kol_recaps WHERE val=1 ORDER BY date'; $query = mysql_query($sql); while($row = mysql_fetch_array($query)) { echo " <tr> <td>".$row['id']."</td> <td><div align=center>".$row['date']."</div></td> <td>".$row['opponent']."</td> <td>".$row['result']."</td> <td>".$row['record']."</td> <td><a href=recap.php?date=".$row['date'].">Recap</a></td> </tr>"; } $sql = 'SELECT * FROM kol_recaps WHERE val=0 ORDER BY date'; $query = mysql_query($sql); while($row = mysql_fetch_array($query)) { echo " <tr><td>".$row['id']."</td><td><div align=center>".$row['date']."</div></td><td>".$row['opponent']."</td><td>".$row['result']."</td><td>".$row['record']."</td><td></td></tr>"; }
echo"</table></center>"; ?>
|
as avea nevoie de un form prin care sa pot modifica in tabel, si sa adaug result, record, plus un articol
targetul acestui form va fi postrecap.php
CODE | <?php include "db.php"; $date=$_POST['date']; $opponent=$_POST['opponent'];
$query="INSERT INTO $kol_recaps (date, opponent, result, record, name_recap, recap, val) VALUES ('$date', '$opponent', '$result', '$record', '$name_recap', '$recap', '$val')"; $result=mysql_query($query) or die (mysql_error());
mysql_close(); header("Location: addrecap.php"); ?>
|
se pricepe cineva ?
--------------------
X
KNICKSONLINE.COM
|