im sure its more of a database related question rather than ASP question
i dont need help with displaying i just gave the code above to give u some info on how it is currently looking, so my goal is instead of using:
' Select from Animals
' Getting pet infos using a outer DO WHILE
' Select from pictures
' Getting Pet Images using a inner DO WHILE
it would look something like that :
' Select from animals AND pictures
' Something like this:
sql = "SELECT a.FileID, a.Desc, p.FileName FROM Animals AS a LEFT OUTER JOIN pictures AS p ON p.UniqueNum = a.FileID WHERE a.AnimalType= 'dogs'"
' And now, do WHILE not EOF....
' Getting infos AND images
the problem i encounter with the code you gave me above is that it works only when there is 1 photo (p.UniqueNum field) for each pet, if there's more than 1 photo it will just display the first one it gets and ignore the rest
Well if there is no way of doing this without a 2nd SQL call then fine ill stay with 2, but if any1 got any idea of doing that with just 1 then i'd like to hear it
Thanks for the help