Jump to content

using SELECT __ FROM table Where to get FileName from a table?


prallen

Recommended Posts

okay, my table looks something like this

ID      UniqueID            FileName         

1      nCSoHUaDMz    nCSoHUaDMz.jpg

2      XXXXXXXXXX    XXXXXXXXXX.jpg

3      XXXXXXXXXX    XXXXXXXXXX.jpg

 

I am trying to get the FileName based on the UniqueID.  This is what I am trying:


ShowRandomPic();

function ShowRandomPic(){
mysql_connect("localhost", "db_user", "db_password") or die ('Error: ' . mysql_error());
mysql_select_db ("db_pictures");
$sql = "SELECT * FROM table Where UniqueID = 'nCSoHUaDMz'";
$result = mysql_query($sql);
$row = mysql_fetch_array($result);
$filename =  $row['FileName'];
        print $filename;
}

 

Nothing is outputting, any Ideas or suggestions?

 

Thanks a lot,

    Pat

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.