php如何截取数组记录然后循环输出？？

Question

<?php
$con = mysql_connect("localhost","root","root");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }
mysql_select_db("newshop", $con);
$exec="SELECT  thumbnail_pic FROM sdb_goods";
$result=mysql_query($exec);
while($rs=mysql_fetch_object($result))
{ 
echo " $rs->thumbnail_pic  <br/>"; 
}
mysql_close($con);
?>
返回的结果是
images/goods/20120503/2cc4ec6557913bf7.jpg|/goods/20120503/2cc4ec6557913bf7.jpg|fs_storage 
images/goods/20120518/73f7e2f8a7b48c2e.png|/goods/20120518/73f7e2f8a7b48c2e.png|fs_storage 
images/goods/20120506/4a583c784010c10e.jpg|/goods/20120506/4a583c784010c10e.jpg|fs_storage 如何达到要求返回的结果是（意思就只要分隔符“|”最前面的一截）
images/goods/20120503/2cc4ec6557913bf7.jpg
images/goods/20120518/73f7e2f8a7b48c2e.png
images/goods/20120506/4a583c784010c10e.jpg
 

Answer 1

while($rs=mysql_fetch_object($result))
{ 
   $t=explode('|', $rs->thumbnail_pic);
   echo " $t[0]<br/>"; 
}

Answer 2

echo strtok($rs->thumbnail_pic, '|'). "<br/>";

Answer 3

老大在经验摆在这里
while($rs=mysql_fetch_object($result))
{  
echo strtok($rs->thumbnail_pic, '|'). "<br/>";
  } 

Answer 4

SELECT SUBSTRING_INDEX(thumbnail_pic,'|',1) AS thumbnail_pic FROM sdb_goods

Answer 5

while($rs=mysql_fetch_object($result)){ 
    echo substr($rs->thumbnail_pic, 0, strpos($rs->thumbnail_pic, '|'));
} 

Answer 6

while($rs=mysql_fetch_object($result))
{  
echo substr($rs->thumbnail_pic,0,strpos($rs->thumbnail_pic, '|')). "<br/>";
  }