Marquee with MySQL and PHP

[sridhar golyandla]

plz, need help urgently

 

Am new bie to php and mysql...

My question is : How to display all the names from database table in a marquee function, which directs from down-to-up.

 

$query=mysql_query("select * from employee where status='Active'");

$num=mysql_num_rows($query);

 

while($row=mysql_fetch_object($query))

{

$list .= $row->names;

echo substr($list, 0);

}

by using these query, it displays only last record of the table.

plz help me out, how to display all the names from the db.

[JonnoTheDev]

$query=mysql_query("SELECT names FROM employee WHERE status='Active'");
$names = array();
while($row = mysql_fetch_object($query)) {   
   $names[] = $row->names;
}
echo implode(", ", $names);

[sridhar golyandla]

It's working well...

 

Thanks to neil.johnson 

[sridhar golyandla]

shall v put hyperlink to each name?

and it moves one by one?

[JonnoTheDev]

You will need to edit the select query and the hyperlink as I dont know you field names or filenames

 

$query=mysql_query("SELECT id, names FROM employee WHERE status='Active'");
$names = array();
while($row = mysql_fetch_object($query)) {   
   $names[] = "<a href='myfile.php?id=".$row->id."'>".$row->names."</a>";
}
echo implode(", ", $names);