[SOLVED] Removing characters for the last record from database

[MP145]

Hi guys,

 

This is my code

 

<?php

//Connects to Database
mysql_connect($dbhost,$dbuser,$dbpass) or die("Error:: can't connect to database");
$db = mysql_select_db("$dbname") or die("Unable to select db");

//Retrieves data from MySQL
$data = mysql_query("SELECT * FROM botmenu ORDER BY id") or die(mysql_error());

$num=mysql_numrows($data);

if ($num==0) {
echo "Check Back Soon";
} else {
//Puts it into an array
while($bminfo = mysql_fetch_array( $data ))
{

//Displays the record
echo '<a href="'.$bminfo['linkurl'].'">'.$bminfo['linktitle'].'</a> :: ';//Note two dots that i need to display

}
}

?>

 

What this displays is :

Home :: About Us :: Services ::

 

What i intend to do is :

Home :: About Us :: Services

 

I would like to remove the :: from the last record in the mySql db.

 

Can this be done in PHP ?

 

Thanks

[premiso]

$display = array();
while($bminfo = mysql_fetch_array( $data ))
{

//Displays the record
   $display[] =  '<a href="'.$bminfo['linkurl'].'">'.$bminfo['linktitle'].'</a>';//Note two dots that i need to display

}
echo implode(" :: ", $display);
}

 

Should fix it.

[MP145]

Thank you premiso for the reply 

 

YESSSSSSSSSS, works like a charm!!! 

 

Thank you so so much.