Display the fetched rows

[Anon]

Hi All,

First of all sorry for my bad english. 🙂

I am trying to get last 4 rows of a table, and display the colums contents inside a table with "4 cells", each row results inside a cell.

So far, I learned that I have to do this:

$connection = mysql_connect (localhost, username, password);
or die("Couldn't make connection.");

$db = mysql_select_db("scan", $connection)
or die("Couldn't select database");

$pg4art = "SELECT id, titulo, imagem, texto FROM artigos ORDER BY dia DESC limit 4";

$4art = mysql_query($pg4art,$connection)

Now I believe that to tranform into arrays the colums contents I have to do this:

while ( $row = mysql_fetch_array($4art) ) {
$id = $row["id"];
$titulo = $row["titulo"];
$dia = $row["dia"];
$mes = $row["mes"];
echo ( "a bunch of things" ) ;
}

Basically I am stucked at the echo part. I got contents to grab from the database and display them, in someway like this:

$imagem $titulo | $imagem $titulo

$texto | $texto

$imagem $titulo | $imagem $titulo

$texto | $texto

Of course, there's a bunch of HTML involved to construct the table.

So, basically, how can I use the returned arrays from the while statament (or loop?) to echo it anywhere I like on my html?

Thanks A LOT!

[Anon]

to get a variable in php into html all u have to do is something like:

<table>
<tr>
<td> <?php echo $var ?> </td>
</tr>
</table>

that should get you on ur way.

[inerte]

Shaft,

I will expand a little more the explanation of my problem. 🙂

Each returned result would need to be transformed to a variable.

So, if I fetch the last four rows of the collum "id", I would like to echo it in different places, i.e different cells of the table.

Hope I made myself clear, and sorry for any misspelings this time! ;-)

[staffanolin]

You could put each new result into an index in an array

$i=0;
while(...)
{
//your code
$var[$i] = $result;
$i++;
}

/Staffan

[inerte]

Thanks Mr. Olin for your answer! It works for what I have in mind, thanks again.