> I CAN'T FOR THE LIFE OF ME FIGURE OUT > WHERE TO PUT THE "SELECT" OR "WHERE" STATEMENTS > & THEN HOW TO USE IT SO THAT I CAN GET THE DATA > I WANT FROM THE DB TO APPEAR WHERE I WANT IT TO. > > so fed up with this.
certainly does appear that way you are *so* ready for coldfusion ;o) > Now, say you have a HTML page with two HTML tables on it - > if you wanted to have the "Details" for row 12 appear in the first > HTML table & then in theother HTML table have the "Details" of > row 26 - how would you code that? this is actually easier than it sounds that's called "two up" layout -- down the first table, back up, then down the second table the other way is records 1 and 2 in the first row, records 3 and 4 in the second row, and so on (not sure what that's called) anyhow, to go down, back up, and down again, that's pretty easy suppose you could generate a line of html for every row in the table that line would be <tr><td>#details#</td></tr> (coldfusion uses hashes to delimit variables, i think ASP uses percents? dollar signs? whatever) anyhow, the key point is, you are generating a one-column row now, here's how to get your "two-up" layout you will nest two tables inside a bigger table, and the bigger table will have just one row, two cells, each with a table in it start the outer table, and also the first nested table: <table><tr><td><table> next, generate half the rows with the row html shown above finish the first nested table, and start the second in the next cell: </table></td><td><table> generate the other half of the rows finally, wrap up by closing the second nested table and the outer table </table></td></tr></table> done the only really tricky part is knowing how many rows you have that's ASP's RecordCount variable (at least, that's what i think it's called) divided by two your page http://www.kidzklub.ie/cms/index.asp looks like a three-up layout, so divide by three and adjust the above steps accordingly does this help? the sql isn't really as hard as you make out, is it? rudy ____ � The WDVL Discussion List from WDVL.COM � ____ To Join wdvltalk, Send An Email To: mailto:wdvltalk-join@;lists.wdvl.com Send Your Posts To: [EMAIL PROTECTED] To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub ________________ http://www.wdvl.com _______________________ You are currently subscribed to wdvltalk as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
