A different way [help]
Posted: Mon Oct 02, 2006 8:36 pm
Is there a better way I can do this that won't make such a massive amount of code to do the same thing?
any help is much appreciated, thanks!
Code: Select all
$data = mysql_query("SELECT * FROM gallery") or die(mysql_error());
while($row = mysql_fetch_array( $data ))
{
if ($row['user']==$user AND $row['gallery']==1)
{
if ($file1=="")
{
$file1="../userfiles/" . $row['folder'] . "/" . $row['photo'];
$comment[1]=$row['caption'];
}
elseif ($file2=="" AND $file1!="")
{
$file2="../userfiles/" . $row['folder'] . "/" . $row['photo'];
$comment[2]=$row['caption'];
}
elseif ($file3=="" AND $file2!="" AND $file1!="")
{
$file3="../userfiles/" . $row['folder'] . "/" . $row['photo'];
$comment[3]=$row['comment'];
}
elseif ($file4=="" AND $file2!="" AND $file1!="" AND $file3!="")
{
$file4="../userfiles/" . $row['folder'] . "/" . $row['photo'];
$comment[4]=$row['caption'];
}
elseif ($file5=="" AND $file2!="" AND $file1!="" AND $file3!="" AND $file4!="")
{
$file5="../userfiles/" . $row['folder'] . "/" . $row['photo'];
$comment[5]=$row['caption'];
}
elseif ($file6=="" AND $file2!="" AND $file1!="" AND $file3!="" AND $file4!="" AND $file5!="")
{
$file6="../userfiles/" . $row['folder'] . "/" . $row['photo'];
$comment[6]=$row['caption'];
}
elseif ($file7=="" AND $file2!="" AND $file1!="" AND $file3!="" AND $file4!="" AND $file5!="" AND $file6!="")
{
$file7="../userfiles/" . $row['folder'] . "/" . $row['photo'];
$comment[7]=$row['caption'];
}
elseif ($file8=="" AND $file2!="" AND $file1!="" AND $file3!="" AND $file4!="" AND $file5!="" AND $file6!="" AND $file7!="")
{
$file8="../userfiles/" . $row['folder'] . "/" . $row['photo'];
$comment[8]=$row['caption'];
}
elseif ($file9=="" AND $file2!="" AND $file1!="" AND $file3!="" AND $file4!="" AND $file5!="" AND $file6!="" AND $file7!="" AND $file8!="")
{
$file9="../userfiles/" . $row['folder'] . "/" . $row['photo'];
$comment[9]=$row['caption'];
}
}
}