how to put my images in a row, let's say 3 images in a row by using php

[kang jia]

hi, if i use mysql_fetch_array, i can only fetch one row at a time and thus only retrieve one filename in database, thus show one image in the row of this filename.
my current code is like following:

 
$getName = $_GET['name'];
    if (isset($getName)){
        $selPaint = "SELECT * from images where artist ='".$getName."'";
    }
    else{
        $selPaint = "SELECT * from images";
    }
 
    $execPaint = mysql_query($selPaint);
 
    if(isset($_SESSION['SESSuserid'])){ //if user logged in                 
 
        echo "<form action=\"do_addcart.php\" method=\"POST\"><br>";
 
        while($thisArt = mysql_fetch_array($execPaint)){
            $fName = $thisArt['filename'];
            echo "<h3>".$thisArt['title']."<h3><br>";
            echo "<a href =".$uploaddir.$fName.">";
            echo "<img src=".$thumbdir."thumb_".$fName."></a><br>";
            echo "<input type=\"checkbox\" name=\"".$thisArt['id']."\" value=\"1\">";
 
 
        echo "<input type =\"submit\" value=\"Select\"><br>";}
        echo "</form>";        
    }
 

how can i retrieve more than one filenames and put 3 images in a row by using PHP.
the effect will something like the following website: http://www.coach.com/content/thumbna...ategory_id=900

can anyone help me with this, it is a bit urgent! :)
thanks in advance!

[ak1dnar]

 
$getName = $_GET['name'];
    if (isset($getName)){
        $selPaint = "SELECT * from images where artist ='".$getName."'";
    }
    else{
        $selPaint = "SELECT * from images";
    }
 

You do know how the "IF" function working here, right?

If you are passing URL parameters to this Script in this way;
http://yourdomain/thisScript.php?name=your_value

 SELECT * from images where artist ='".$getName."'";

Will execut.
If there is nothing on the "name" value

         $selPaint = "SELECT * from images";

will execute.

Before you create your 3 COLUMN structure, how about making this script to display the records.

Are you mentioning that your script ONLY shows One record on both conditions?

[kang jia]

 
$getName = $_GET['name'];
    if (isset($getName)){
        $selPaint = "SELECT * from images where artist ='".$getName."'";
    }
    else{
        $selPaint = "SELECT * from images";
    }
 

You do know how the "IF" function working here, right?

If you are passing URL parameters to this Script in this way;
http://yourdomain/thisScript.php?name=your_value

 SELECT * from images where artist ='".$getName."'";

Will execut.
If there is nothing on the "name" value

         $selPaint = "SELECT * from images";

will execute.

Before you create your 3 COLUMN structure, how about making this script to display the records.

Are you mentioning that your script ONLY shows One record on both conditions?

No, this If function is working fine, it returns records i want, but the questions i ask is more towards how to 3 different images in a row, because the code

[code:PHP]

while($thisArt = mysql_fetch_array($execPaint)){
$fName = $thisArt['filename'];
echo "<h3>".$thisArt['title']."<h3><br>";
echo "<a href =".$uploaddir.$fName.">";
echo "<img src=".$thumbdir."thumb_".$fName."></a><br>";
}

[/code]

this code can only give me one image each time through the while loop, and one row one image, what i want to achieve is to have 3 different images in a row. i dont know how to write this kind of code. can help me with this, i will really appreciate your kind help! :)

[ak1dnar]

Please read through this tutorial.
Hope you may find the answer from there. If there is a doubt feel free to ask. Thanks and good luck.

Please use code tags in this format:

[code=php]

[code] put a / after the opening square bracket to close the code tags.