show uploaded files name from database

[Jaswinder]

<div style="width:100%; height:auto; background-color:#000; color:#FFF; text-align:center;">
 <table align="center" width="100%" border="1" style="color:#FFF;">
 <tr><th>Pdf</th><th>Video</th><th>Images</th></tr>
<?php
$email=$_GET['email'];
include_once ('host.php');
$c="select * from upload where email_id=$email";
$sq=mysql_query($c) or die(mysql_error());
$r=mysql_num_rows($sq);
if($r>=0)
{
    while($f=mysql_fetch_array($sq));
    {?>
   
    
    <tr><td><? echo $f['pdf']; ?></td><td><? echo $f['video']; ?></td><td><? echo $f['images']; ?></td></tr>
 
    <?php
    }
}
else
    {
        echo "You do not uploaded anything yet";    
    }
    
?>
<tr><td colspan="3" style="background-color:#F00;"><a href="upload.php">Back</a></td></tr>
</table>
</div>

 

 

error

 

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '@s.com' at line 1

                                 

                                       Pdf                                        Video                                       Images

 

 

Where email id is a@s.com

[DaveyK]

and you expect anyone to know what you need?

[Jaswinder]

i want to make it work as person  with same email id.. whatever he uploaded either images/pdf or videos...  it should display those all of same paerson

[Love2c0de]

In that case, I would create another table where you insert the images by whichever user, but you also insert a unique id of that user at the same time. This will allow you to select only the images with that certain id.

 

Kind regards,

 

L2c.