[RESOLVED] How display data inline

eVrn

I am trying to display data inline, say in two or three columns rather than one single column. So far, I am using this code to display a single column:

echo "<DIV ALIGN=center><TABLE BORDER=0>\n";
echo "<TR><TD HEIGHT=40><!--SPACER--></TD></TR>";
do {
printf("<TR><TD ALIGN=center><IMG SRC=images/%s WIDTH=100><BR>%s</TD></TR>\n", $myrow["img"], $myrow["name"]);
} while ($myrow = mysql_fetch_array($result));
echo "</TABLE></DIV>\n";

The above display the image and corresponding title under it. But they are all in a verticle line. I want to have two or three lines / columns.

I have been experimenting with all sorts of ideas, but none work, and I have run out of ideas. Please help! 🙂

bradgrafelman

Have you tried searching the board for certain keywords like "data columns" or "data rows", etc.

eVrn

Thanks for that direction! I never seem to know what search terms to use, so that is very helpfull! Thanks again! Will update this thead when I get it working!

eVrn

OK, getting there I think. I found some direction on that search, thanks Brad.

But I am having trouble getting the images to display. I get the same image and the same caption repeating in every cell, rather than one of each. Here iswhat I have. Can anyone tell me where I am going wrong here?

<TABLE>";

$counter = 0;
$cells_per_row = 3;
while($row=mysql_fetch_array($result))
{
    $counter++;
    if(($counter % $cells_per_row) == 1)  { echo '<TR>'; }
    echo "<TD ALIGN=center><IMG SRC='images/$myrow[img]'><BR>$myrow[name]</TD>\n";
    if(($counter %  $cells_per_row) == 0) { echo '</tr>'; }
}
// just in case we haven't closed the last row
// this would happen if our result set isn't divisible by $cells_per_row
if(($counter % $cells_per_row) != 0) { echo '</tr>'; }

echo "</TABLE>

Thanks so much!!

Piranha

First you have

$row=mysql_fetch_array($result))

And further down it says

images/$myrow[img]'><BR>$myrow[name]

There are 3 problems with this. First you don't use the same variable name. Second is that you don't use the ' sign inside the []. It should be $myrow['img']. Third is that it is not possible to use arrays in strings the way you do. You could do either of the following things:

echo "<TD ALIGN=center><IMG SRC='images/{$myrow['img']}'><BR>{$myrow['name']}</TD>n"; 
echo "<TD ALIGN=center><IMG SRC='images/" . $myrow['img'] . "'><BR>" . $myrow['name'] . "</TD>n";

eVrn

AHHH!! I missed that variable name. That was the problem. When I added () and ' marks, it broke, took them out and it works. Don't understand why.

Thanks!!

Piranha

Because I didn't add parantheses (). I added the curly brackets {}.

eVrn

🙂 Oh.

I'm kinda new, you can probably tell! I will change those to brackets and try again. What did you mean when you said I can't use arrays in strings that way? What am I in danger of having break?

Thanks for your help - BIG TIME!!

Piranha

As far as I know it should only be possible to use single-valued variables in strings. Like this:

echo "1 $test 2";

That should work and output everything correct. But using variables in arrays or variables in classes is not sure to work. At least that is what I thought. So the following should not work:

echo "1 $test[1] 2";
echo "1 $test['abc'] 2";
echo "1 $test->test2 2";

bradgrafelman

For more information about variable parsing and the "complex syntax" using curly braces, see this man page.

eVrn

Oh Boy. This is the part that scares me, but also usually pays off. I have something working, but it is not done correctly. So I am going to go back in and make the code right. If it breaks it, I may be back 🙁 but I hope I can stumble through it and fix it. I have surprised myself over the last month or two and being able to figure some of this stuff out with absolulty ZERO background to go on. Well, a little javascripting and a lot of ActionScripting, but that's it.

So back in I go! Thanks for the link Brad, will bookmark it for now while working on this. And Thanks Piranha for you patients and willingness to explain the obvious to someone who doesn't quite get it ... yet! 🙂

Thanks guys!

Piranha

I am pretty new to PHP as well. Have learned a few other languages before, so I understand the basic but there are always new things to pick up. I suggest that you read a lot of other threads, you will pick up a lot of useful things by doing that.