need help with output the data

[mark103]

Hi guys,

I have stored the data in mysql database where I can ouput them in php using with this following code:
 

<?php

session_start();

  define('DB_HOST', 'localhost');

  define('DB_USER', 'mydbusername');

  define('DB_PASSWORD', 'mydbpassword');

  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, channels FROM tvguide";

    $result1=mysql_query($qrytable1) or die('Error:<br />' . $qry . '<br />' . mysql_error());

     

    while ($row = mysql_fetch_array($result1))

    {

      echo "</br>";

      echo "<td>".$row['channels']."</td>";

      echo "</br>";

    }

  }

?>

I want to know how I can output the data from php to html, do you know how?

if so please can you help me.

thanks in advance.

 

[devWhiz]

I'm not sure I get what you mean? Is your script not displaying anything? Any errors being displayed? The only thing I see that would cause an error is your $qry variable being undefined.

[computermax2328]

I agree with CLUELESS plus if you are going to be using HTML elements in your PHP use the right ones. For your table you have the start a <table> outside of your while loop. Then if you want to have one piece of data per row you need to add <tr> tags in your loop. Replace the <br> tags with them.

echo "<table>";
//query
while ($SomethingWorks) {
echo "<tr>";
echo "$row['whatever']";
echo "<tr>";
}
echo "</table>";

[Barand]

Don't forget the '<td>...</td>' tags