I assume you want to display the information on in a HTML document.
Simply have a table that includes the staff members name and the pathname of the photograph.
eg table called staff has columns Name and picpath
create a query string
$query = "SELECT name , picpath FROM staff";
$result = mysql_query($query);
Loop through each entry in turn and process the data
while ($staff_row = mysql_fetch_array ($result)) {
$name = $staff_row("name");
$picpath = $staff("picname");
/ put your processing here /
}
Hope this helps
K Gabs wrote:
I am working on a database adn i was wondering if it was possible to use an sql statement to retrieve all staff name and their photographs at the same time.Photographs were stored on the databse as text and just the name of the jpg was stated in the database
