| |
Warrington, Cheshire
The Warrington and district part of our collection consists of images dating from c.1900 to approx 1930 with the majority being c.1910. We sell hand-printed photographs, carefully reproduced from vintage photographs, glass-negatives and old photographic postcards. |
| |
Stockist : Borders |
Links : Cheshire Index |
| |
   |
|
| |
|
Viewing the photographs.
Please browse the images below by clicking on the 'view' button.
|
|
<%
strConn = "DRIVER={MySQL};SERVER=localhost;DATABASE=picturesdb;"
' *** create variables for login details
strUser = "pictures"
strPassword = "arquinton"
'*** create the connection object then open it passing your login details.
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open strConn, strUser, strPassword
'*** create the sql string
stSQL = "SELECT * FROM pictures WHERE category LIKE '%Warrington%'"
'*** create the recordset object (one of many methods)
Set mRS = conn.Execute (stSQL)
'*** no rows returned, set a message otherwise loop through the recordset
if mRS.EOF then
stresult = stresult & "| Sorry - no items currently available in this category | "
else
do while not mRS.EOF
' write item ref
Response.Write "| " & mRS.fields(0) & " | " & vbcrlf
' write title
Response.Write "" & mRS.fields(1) & " | " & vbcrlf
' write link button
Response.Write ""
Response.Write " | " & vbcrlf
mRS.movenext
loop
Response.Write "| " & stresult & " | "
end if
set mRS = nothing
set conn = nothing
%>
|
| There are likely to be more images of this location available in our collection. Please contact us for details.
|
|
|