Question

I am a newbie in PHP. I was trying to retrieve info from my database and store it in a table.
I know tables in PHP works like 'echo "" '..
i just wanted to know is there any way i can use rowspan here like we do in html?

Answer 1

something like this..

Answer 2

How i do i use it? echo "<tr> <td rowspan="2"> </td> </tr>"; gives me a syntax error..

Answer 3

I'll google that and get back to you in case i'm not able to figure it out. Thank you.

Answer 4

And.. why would i have to use colspan too? What am i missing?

Answer 5

I have this PHP code with me.

<?php
//show information
ini_set('display_errors',1);
error_reporting(E_ALL);
$conn = mysql_connect("localhost","root","");

if(!$conn)
{
echo mysql_error();
}
$db = mysql_select_db("imagestore",$conn);
if(!$db)
{
echo mysql_error();
}

$q = "SELECT * FROM animaldata";
$r = mysql_query("$q",$conn);

if($r)
{
while($row=mysql_fetch_array($r))
{
//header("Content-type: text/html");
echo "</br>";
echo $row['aname'];
echo "</br>";
echo $row['adetails'];
echo "</br>";

//$type = "Content-type: ".$row['aphototype'];
//header($type);
echo "<img src=image.php?ano=".$row['ano']." width=600 height=600/> ";


}
}
else
{
echo mysql_error();
}
?>

Answer 6

Now what i want to do is.. Display 'aname' in one column. 'adetails' in one column.. and 'aphoto' in the column where rows have been combined. I am not really.sure how i would do that.

Answer 7

And there are multiple entries in my database. So for each while loop, there has to be separate table..

Answer 8

Hmm. I think i can do something with that. Thank you. :)

Answer 9

You have to escape special characters

echo "<tr> <td rowspan=\"2\"> </td> </tr>";


in this case you can also replace the outer " with '

echo '<tr> <td rowspan="2"> </td> </tr>';

(although it's alway better to escape)


http://en.wikipedia.org/wiki/Escape_character