|
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
| ||||||||||||||||||||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
ok, Iv acheaved a basic forum and now i want to add Avatars/Display pictures alowing the user to choose there own from a list of ones i have created. Iv been searching all over the joint and racking my head how i could do this. here are my tables.
tblUsers ID User_Name User_Paswd Country Avatar (a small display picture URL) tblPosts ID Topic_ID User_Name (same value as tblUsers, this is how they are linked) Comments (the body) now currently on my display page in my forum im just using tblPosts to show the username and then the comment then MoveNext. The Topic ID for the posts come through in a Query string so im using a "WERE ""& TopicID &""" in my record set to Display the right posts like so..... Do While not rsForum.EOF Response.Write ("<table width='500' align='center' cellpadding='3' cellspacing='0' bordercolor='#C6E2FF' border='1'>") Response.Write ("<tr height='5'><td background='TRBG2.gif'>") Response.Write ("<font face='verdana' size='2' color='#3D59AB'><img src='PostBox.gif'> Posted By: <font face='verdana' size='2' color='green'>"+rsForum("PUser_Name")) Response.Write ("</td></tr>") Response.Write ("<tr><td><table cellpadding='10'><td>") Response.Write ("<font face='verdana' size='2' color='#3D59AB'><b>"+rsForum("Comments")) Response.Write ("</td></table></td></tr>") Response.Write ("</table>") Response.Write ("<br>") 'Move to the next record in the recordset rsForum.MoveNext Loop NOW how do i access a different recordset in the middle of that, connect both the user_Names up then desplay the avatr URL? thanks.. =] |
![]() |
| Viewing: ASP Free Forums > Programming > Visual Basic Programming > Eeek Help me guys! |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|
|