Hi all,
If i have the following code:
$query = \"SELECT * FROM categories WHERE CatID = $id\";
$result = mysql_query($query);
while($row = mysql_fetch_array($result)){
if ( $row[\'url\'] != \"\" ) {
$urls = explode(\", \", $row[url]);
for ($i = 0; $i < count($urls); $i++) {
echo \"<TABLE BORDER=\\"0\\" WIDTH=\\"435\\" CELLSPACING=\\"0\\" CELLPADDING=\\"0\\" BGCOLOR=\\"#000000\\">\";
echo \"<TR>\";
echo \"<TD WIDTH=\\"400\\"> <IMG BORDER=\\"0\\" SRC=\\"images/arrow_W.gif\\" width=\\"6\\" height=\\"9\\"> <A HREF=$urls[$i] target=\\"_blank\\"><FONT COLOR=\\"#FFFF00\\">{$row[\'CatName\']}</FONT></A></TD>\";
echo \"<TD WIDTH=\\"35\\" BGCOLOR=\\"#FFFFFF\\" ALIGN=\\"center\\">\";
echo \"<a href=\\"javascript:void(0);\\" onclick=\\"history.back(); return(false);\\" >\";
echo \"<img src=\\"images/back.gif\\" alt=\\"BACK\\" border=0></a>\";
echo \"</TD>\";
echo \"</TR></table>\";
}
} else {
echo \"<TABLE BORDER=\\"0\\" WIDTH=\\"435\\" CELLSPACING=\\"0\\" CELLPADDING=\\"0\\" BGCOLOR=\\"#000000\\">\";
echo \"<TR>\";
echo \"<TD WIDTH=\\"400\\"> <IMG BORDER=\\"0\\" SRC=\\"images/arrow_W.gif\\" width=\\"6\\" height=\\"9\\"> <FONT COLOR=\\"#FFFF00\\"><b>{$row[\'CatName\']}</b></FONT></TD>\";
echo \"<TD WIDTH=\\"35\\" BGCOLOR=\\"#FFFFFF\\" ALIGN=\\"center\\">\";
echo \"<a href=\\"javascript:void(0);\\" onclick=\\"history.back(); return(false);\\" >\";
echo \"<img src=\\"images/back.gif\\" alt=\\"BACK\\" border=0></a>\";
echo \"</TD>\";
echo \"</TR></table>\";
}
....how can i get the first value from the \"url\" field? Eg. in the field the data might be stored as http://www.site1.com, http://www.site2.com
How do i get the first value, http://www.site1.com
Cheers,
maccam
