I'm working on code for listing pictures from database.
I got the listing, in next step I want to create link "edit info"
for each of the listed items.
What should I put in editing.php so it will edit each picture?
Here is my code for listing
Code: Select all
$result2 = mysql_query("SELECT * FROM tbl_usr_gal_pic where usr_email ='$email1' ");
while($row2 = mysql_fetch_array($result2) )
{
echo "
<TABLE BORDER=0 CELLPADDING=2>
<TR>
<TH ROWSPAN=8 BGCOLOR='#99CCFF'>"; echo '<img src =\'' . $row2[4] .'\' width="140" height="140" border="0" >'; echo "</TH>
<td></td>
<TD><p style='font-size:small; font-weight:bold;'>"; echo $row2[2]; echo "</p> </TD> <TD> </TD> <TD><p style='font-size:x-small;'>";?> <a href='editing.php'> <?php echo " Edit Information</a></p></TD>
</TR>
<TR>
<td></td>
<TD>";
if ( $num4 == "1" ) {
echo $num4;echo "$nbsp photo";}
else {
echo $num4;echo "$nbsp photos"; }
echo " <br> created on "; echo $row2[7]; echo" </TD> <TD> </TD>
</TR>
<TR>
<td></td>
<TD> </TD>
<TD> </TD>
</TR>
<TR>
<td></td>
<TH rowspan=4><p style='font-size:small; font-weight:bold;'> some text will be here</p> <p style='font-size:small; font-weight:normal;'>Statement will be here</p> </TH>
<TD></TD>
<td></td>
</TR>
<br>
</TABLE>
Thanks