php LIKE

[cip6791]

$result = mysql_query("SELECT * FROM xzclf_cats WHERE catname LIKE 'A%'");

 

$row = mysql_fetch_array($result) or die(mysql_error());

 

while($row = mysql_fetch_array($result)){

echo $row['catname'];

echo "<br />";

}

echo "Hello!";

?>

 

I am using the code above to get the catnames that start with the letter A. And it is not displaying anything. the Hello! echo is displaying.

 

Can anybody give me a hand?

 

Thank you.

[JasonLewis]

try this:

$result = mysql_query("SELECT * FROM `xzclf_cats` WHERE upper(left(`catname`,1))='A'");

$row = mysql_fetch_array($result) or die(mysql_error());

while($row = mysql_fetch_array($result)){
   echo $row['catname'];
}

[Sulman]

Try using this:

 

$result = mysql_query("SELECT * FROM xzclf_cats WHERE catname LIKE 'A%'");

while($row = mysql_fetch_assoc($result)){
   echo $row['catname'];
   echo "
";
}
echo "Hello!";
?>

[gabarab]

$result = mysql_query("SELECT * FROM xzclf_cats WHERE catname LIKE 'A%'");

for ($i=0;$i<mysql_num_rows($result);$i++)  echo '<a href="edit.php?catrid='.mysql_result($result,$i,id).'">'.mysql_result($result,$i,name).'</a><br />';

 

-----

That's it...

Work great for me.

[cip6791]

thanks for your help. i ll try them out and let u know