Re: [PHP] Looping information into a table

2006-04-04 Thread Georgi Ivanov
Sorry . The correct SQL should be: $query ="select * from cforum cf INNER JOIN scforum ON cforum.id=scforum.cfid"; :) On Tuesday April 4 2006 11:58, Georgi Ivanov wrote: > A little OT but i think it is important : > I really would not write this code like this . > You are making too many que

Re: [PHP] Looping information into a table

2006-04-04 Thread Georgi Ivanov
A little OT but i think it is important : I really would not write this code like this . You are making too many queries to the database . If u have 100 rows in first table and 200 rows returned from second query , you make 100*200 queries to the database ! Try using SQL Joins. Like this :

Re: [PHP] Looping information into a table

2006-04-03 Thread tedd
i am creating a forum and i am having trouble getting the database information in to an html table i believe it has somthing to do with the placement of the while loops because they repeat the segment of code over untill the statment returns false, thus adding extra html.. you guys are the ex

Re: [PHP] Looping information into a table

2006-04-02 Thread Chris
benifactor wrote: i am creating a forum and i am having trouble getting the database information in to an html table i believe it has somthing to do with the placement of the while loops because they repeat the segment of code over untill the statment returns false, thus adding extra html.. y