output the data into 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

Weedpacket

First off, note that the MySQL extension is deprecated.

Now, I don't know what " output the data in different <span id="text1">tags from<tr><td>` tags" is supposed to mean, but if you want to "split the output the data into an array before I could output them" then ... put the data into an array before outputting it.

mark103

can you tell me how i can put the data into an array before outputting it?

traq

this line:

while ($row = mysql_fetch_array($result1))

is already storing the values of each result row in an array.

The data is being overwritten on each loop, however. If you want to keep it for later use, instead of doing

while ($row = mysql_fetch_array($result1)) 
        { 
          echo "<tr><td>".$row['mydata']."</td></tr>"; 
        }

assign each row its own (unique) array:

while ($row = mysql_fetch_array($result1)) 
        { 
          echo "<tr><td>".$row['mydata']."</td></tr>"; 
          $savedRows[] = $row;
        }

When you're done with the loop, the first row will be in [font=monospace]$savedRows[0][/font] (i.e., [font=monospace]$savedRows[0]['mydata'][/font], etc.), the second will be in [font=monospace]$savedRows[1][/font], and so forth.

mark103

Your post didnt make much sense. I have copied and paste the code in my php, but it still DON'T put the data into an array before ouput it. Please post the fixed code instead of confused me.

traq

if you want to modify your script, you're going to need to know (or learn!) more about PHP than how to copy+paste. I don't know what you're trying to accomplish (as Weedpacket mentioned, you haven't explained that very clearly), but I'd be happy to help you figure it out.

I don't plan on doing all the work for you, however. If that's what you want, then you need to hire a programmer.