Re: Misunderstandings about SQL

2002-10-16 Thread Michael T. Babcock
The section below should be in a loop if you expect it to happen more than once ... John Chang wrote: > > > $row_Recordset1['V_ID']; ?> > $row_Recordset1['40K']; ?> > > > SQL ... -- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock ---

RE: Misunderstandings about SQL

2002-10-15 Thread John Chang
ve the GenreID from the control. You then >pass this to the query, which would read something like this: > >SELECT VideoTitle, TitleID FROM Titles >INNER JOIN TitleGenres ON Titles.GenreID = Genres.GenreID >WHERE Titles.GenreID = 3 > >Hope this helps. > >For a search page th