Getting no data in Return With PHP MySQL

[itsureboy]

I have a php script to retrieve data from a table in a database.

However i get nothing in return.

Below are example of the table and my php.....

What am I doing wrong?

**There are no connection problems.**

Thanks in advance....

 

 

For example I have a table somewhat like this in my database.

 

color |||||| type  ||||

-------------------------

blue  |||||| shirt ||||

 

 

 

<?php

include 'dbconnect.php';

$query = mysql_query("SELECT type FROM mytable WHERE color = 'blue' ");
$row = mysql_fetch_assoc($query);


echo $row['type'];

?>

[simcoweb]

Try changing to this:

 

<?php

include 'dbconnect.php';

$query = mysql_query("SELECT type FROM mytable WHERE color = 'blue' ");
while ($row = mysql_fetch_array($query))
{

echo "" . $row['type'] . "<br\ >\n";
}

?>

[itsureboy]

It worked!!

Thank you so much....

[simcoweb]

No problem