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 through 10

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

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: 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) { tr td File 1/td tdThis is the file/td tdDelete/td /tr }else{ tr tdFile1/td td/td tdAdd/td /tr } } What is the

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