i can connect to data but cant print it!

[Jappy]

hiya guys and girls

ive managed to connect to my db but i cant figure out the code to actually print data from it into browser.

can someone please look at the code and tell me what i'm missing? i would like to print the contents of the cell newsId = 00001 in the headline column.

any idea?

Thanks guys


$host = "localhost";
$user = "";
$password = "";
$database = "test";

$connection = mysql_connect($host, $user, $password);
$db = mysql_select_db($database, $connection);


$query = "select HEADLINE from news where newsId='00001'";
$result = mysql_query($query) or die ("Couldn't execute query.");

[someonewhois]

http://php.net/mysql_fetch_array

[Jappy]

thanks!

i got some stuff to print out but while loops dont work. any idea what im doign wrong here?

$query = "select headline from news";
$result = mysql_query($query) or die ("Couldn't execute query.");

while ($row = mysql_fetch_array($result));
{
echo '<p>' . $row['headline'] . '</p>';
}

thanks people, im almost getting somewhere feels good!!

J

[someonewhois]

You don't want the semi colen after the while loop.

  while ($row = mysql_fetch_array($result))
  {
  echo '<p>' . $row['headline'] . '</p>';
  } 

Also, could you please wrap code in [php] tags? It just makes things easier to read. (Oh, and this post should really be in the PHP forum not MySQL, but that's not a huge issue, a mod will move it.)

[Jappy]

thanks a lot Nathan! That fixed it sorry i neve wrote back

J

[chatmasta]

You can extract the row first, too.

while ($row = mysql_fetch_array($result))
   {
  extract($row);
  echo '<p>$headline</p>';
  } 

It makes it fairly esaier. You don't have to. Of course, it probably would start interfering in big applications, so it may not be a good idea.