Hi guys,

I have stored data in a MySQL database and I've output it in PHP. I want to know how I can output the data in different <span id="text1">` tags from `<tr><td>` tags.


PHP Code:
    <?php
      define
('DB_HOST''localhost');
      
define('DB_USER''myusername');
      
define('DB_PASSWORD''mypassword');
      
define('DB_DATABASE''mydbname');   
   
      
$errmsg_arr = array();
      
$errflag false;
      
$link mysql_connect(DB_HOSTDB_USERDB_PASSWORD);
   
       if(!
$link)
      {
        die(
'Failed to connect to server: ' mysql_error());
      }
      
$db mysql_select_db(DB_DATABASE);
   
      if(!
$db)
      {
        die(
"Unable to select database");
      }
   
   
      if(
$errflag)
      {
        
$_SESSION['ERRMSG_ARR'] = $errmsg_arr;
        echo 
implode('<br />',$errmsg_arr);
      }
      else
      {
        
$qrytable1="SELECT id, mydata FROM mydb ";
        
$result1=mysql_query($qrytable1) or die('Error:<br />' $qry '<br />' mysql_error());
   
         while (
$row mysql_fetch_array($result1))
        {
          echo 
"<tr><td>".$row['mydata']."</td></tr>";
        }
      }
    
?>
On my PHP page it show something like this:


PHP Code:
    <tr><td>my data 1</td></tr><tr><td>my data 2</td></tr><tr><td>my data 3</td></tr><tr><td>my data 4</td></tr
How can I split the output the data into an array before I could output them in different <span id="text1">` tags from `<tr><td>` tags?

any advice would be much appreicated.

thanks in advance