[Resolved] Parsing and styling blob

ph3n0m

I have a blob being returned from a query in the following format

N:Smith;Jim;Alvin;Mr. FN:Jim A.
Smith CATEGORIES:Family
BDAY:1977-01-27 ADR;WORK:;Suite
900;11 5th Street;Coco
Beach;FL;32082 ADR;HOME:;;198 Elm
Street;Coco Beach;FL;32082
TEL;WORK:904-555-9384;
TEL;HOME:904-873-0394
TEL;CELL:904-934-3429

I have parsed it using the following

$vcard = str_replace("\r", "</td></tr>\n<tr><td valign=\"top\" class=\"$row_class\">", $vcard);
$vcard = str_replace("END:VCARD" , "</td></tr></table>", $vcard);
$vcard = str_replace(":" , ": ", $vcard);
$vcard = str_replace(";" , " ", $vcard);

My problem is, that I would like alternatiing colours for each row - however because each row is returned all at once, instead of the usual "while" loop - I have been unable to style it.

Would anyone have any idea on how I could achieve this or even a pointer or two?

thnx in advance

ph3n0m

Ok I have actually resolved this myself (phew!)

So for anyone interested - here is the code I used

$connection = mysql_connect("localhost", "root", "") or die ("Couldnt connect to database");
$db = mysql_select_db("organizer", $connection) or die ("Couldnt select database");

$sql = "SELECT * from vcard where userid='123' and type='vcard'"; 
$sql_result = mysql_query($sql) or die("There are no contacts.");
echo "<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\n";
while ($row = mysql_fetch_array($sql_result)) {
$vcard = $row["data"];
//echo $vcard;
$vcard = str_replace("BEGIN:VCARD" , "", $vcard);
$vcard = str_replace("END:VCARD" , "", $vcard);
$vcard = trim($vcard);
$vcard = str_replace(":" , ": ", $vcard);
$vcard = str_replace(";" , " ", $vcard);

$pieces = split("\r", $vcard);
$i=0;
while ($i < count(split("\r", $vcard))){
if(($i%2)==0){
$row_class = "data1";
}
else{
$row_class = "data2";
} 
echo "<tr><td class=\"$row_class\">" . trim($pieces[$i])."</td></tr>\n";
$i++;
}




echo "</table>";
}