Printing multiple Database values

[sastudent]

I call the getTitle function but it only returns the last DB value. I presume that is because there are many rows in the DB with the same 'code' However when I call the function I want to get all the values for TITLE where code is something in the DB not just the last one.

Help Please! Thank you very much!!!

class Entry
    {

        private $title;
        private $date;
        private $place;
        private $description;
        private $code;

        function __construct($c)
	{
		$this->code=$c;
		$dbc=mysql_connect(DB_HOST,DB_USER,DB_PASSWORD) or die('Failed'.mysql_error());
		mysql_select_db(DB_NAME);
		$query="SELECT TITLE FROM entry WHERE CODE='".$c."'";
		$result=mysql_query($query);
			while($row=mysql_fetch_array($result))
				{
				$this->title=$row['TITLE'];
				
				}
		mysql_close();
	}

        function getTitle()
        {
            return $this->title;
        }






    }
?>

Check your query returning more rows or not by

if (mysql_num_rows($result) > 1) { echo "returned more than one row" }
else echo "no rows retuned"

$this->title=$row['TITLE'];

The above code is a single title variable should not hold many row values. So make that variable as an array and push whatever values you have in your database using that while loop

[pzuurveen]

You can mak this->title an array

class Entry
   {
   private $title = array();

change the constuctor:

$result=mysql_query($query);
while($row=mysql_fetch_array($result))
   {
   $this->title[]=$row['TITLE'];
   }

[sastudent]

Hi pzuurveen.

thanks for the help.

How should I now change the getTitle function?

Should I use the tooString() function?

Thanks for the help!

[vaultdweller123]

why would you change the getTitle() function? its fine already, it just a matter of how you retrieve it

so you retrieve it like this, first lets instantiate you class Entry

<?php
$obj = new Entry(); // instantiate class Entry
$title = $obj->getTitle(); // get array title

foreach($title as $val){ // loops through all array 
echo $val."<br />"; // test result
}
?>

[sastudent]

Thanks so much!!!!!!

Would not be able to do this without you guys!!!

Vaultdweller-> The reason why I wanted to change the getTitle fuction is beacuse I thought that maybe one could do the for each inside your class...but its working now so thanks a lot! (I am a PHP newbie)

[sastudent]

$p->setContent('<table border="1">

<tr><td>Info: '.$u->getInfo().'</td>
<td>#####</td></tr></table>')

How can I get the result ie $val to display where the ##### is in the code above?

[vaultdweller123]

<?php

$obj = new Entry(); // instantiate class Entry
$title = $obj->getTitle(); // get array title
$content = ""; 

foreach($title as $val){ // loops through all array 
$content += "<td>".$val."</td>"; 
}

$p->setContent('<table border="1">

<tr><td>Info: '.$u->getInfo().'</td>
'.$content.'</tr></table>');


?>

[sastudent]

Is there any way in which I can turn the $content into a link to new unique page which draws info from the database?

for example: $content is the posts users have made and is displayed in a list on his home page but I want them to be able to click on it as well and take the user to a new page...

Thank you for your help VD.