[RESOLVED] Reading from a mysql database

shure2

Below is the code im having problems with, for some reason when I use the echo "Name:&nbsp...... it reads from the database, but when I use the Name : <?=$row['compname.... it doesn't.

I don't want to have to write echo for every line and I don't think its the best method so I come to you guys for help!

<html>
<body>
<h1>List all People </h1>

 <?php
while ($row= mysql_fetch_array($result))
{ ?>
    Name : <?=$row['compname']?>  Job :   <?=$row['compdescription']?> <!-- THIS DOESN'T WORK!-->
    <?php
        //echo "Name:&nbsp ", $row['compname']."&nbsp" . "" . "Job:&nbsp ", $row['compdescription']; //THIS WORKS!
    ?>
        <br />
<?php } ?>
</body>
</html>

Pikachu2000

The line below that doesn't work shouldn't work. The open tag needs a space after it, and the = sign doesn't belong there. Also, it's a better practice to always use the long <?php open tag. You'd probably be better off not stepping in and out of PHP in this case, and writing the echo statement while in PHP. It'll end up being shorter.

shure2;10946239 wrote:
Below is the code im having problems with, for some reason when I use the echo "Name:&nbsp...... it reads from the database, but when I use the Name : <?=$row['compname.... it doesn't.

I don't want to have to write echo for every line and I don't think its the best method so I come to you guys for help!
<html>
<body>
<h1>List all People </h1>

 <?php
while ($row= mysql_fetch_array($result))
{ ?>
    Name : <?php echo $row['compname'] ?>  Job :   <?php echo $row['compdescription'] ?> 
    <?php
        //echo "Name: " . $row['compname']. " Job: " . $row['compdescription']; //THIS WORKS ALSO
    ?>
        <br />
<?php } ?>
</body>
</html>

dagon

php short tags have been switched of, which is good, so yes you need to use echo. however i would do the whole thing like this:

<html>
<body>
<h1>List all People</h1>

<?php
while($row= mysql_fetch_array($result)){
	echo 'Name :' . $row['compname'] . 'Job : ' . $row['compdescription'] . '<br />';
}
?>

</body>
</html>

valid html would be a good idea also