RE: [PHP] looping through a database

2008-06-17 Thread Ford, Mike
On 16 June 2008 21:58, Richard Kurth advised: > I am looping through a database of files that are numbers 1 through 10 > if number 1 is in the database I what to print out the first table > below if it is not then print the else section below. Then > loop through > the database to see if 2 throug

Re: [PHP] looping through a database

2008-06-16 Thread paragasu
i am not sure what u want to do, for this case you need to tell us about your database table structure. i quess you have table like this.. assume the table name is table1 and there are ten column in it file1..file10 respectively |table1 | |member_id | |file1| |file2

Re: [PHP] looping through a database

2008-06-16 Thread Wolf
Richard Kurth wrote: Wolf wrote: Richard Kurth wrote: Could you please give me an idea where to start looking while($row=mysql_fetch_array($sql_result)){ if ($row["number"]==1) { File 1 This is the file Delete }else{ File1 Add } } What is the query being executed? This is the

Re: [PHP] looping through a database

2008-06-16 Thread Richard Kurth
Wolf wrote: Richard Kurth wrote: I am looping through a database of files that are numbers 1 through 10 if number 1 is in the database I what to print out the first table below if it is not then print the else section below. Then loop through the database to see if 2 through 10 are there and

Re: [PHP] looping through a database

2008-06-16 Thread Wolf
Richard Kurth wrote: I am looping through a database of files that are numbers 1 through 10 if number 1 is in the database I what to print out the first table below if it is not then print the else section below. Then loop through the database to see if 2 through 10 are there and do the same t