output the data in each different tags

[mark103]

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
      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_HOST, DB_USER, DB_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:

    <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

 

[Jessica]

Uhm. Change the parts of your code that echo the <td>s to <span>s

[mark103]

well i got all the data in one <span> tag, i want to split them up to output them in each different <span> tags.

 

Any idea how i can do this?

[Jessica]

I just told you how.

[mark103]

No you didn't, you only told me to do something like this:

 

echo "<span id='text1'>".$row['mydata']."</span>";

 

 

all of the data are joined in one tag. I cannot make them get separate via split them up to ouput in each different tag.

 

Please read my first post again before you say something.

[Jessica]

Maybe you should explain what you actually want. You need to read the link in my signature on asking good questions, because so far you are just wasting time.

[mark103]

I want to put the data into an array before outputting it.

 

Any idea?