IF ELSE Query

[meeble]

Hello,

I am pulling stuff out the database with:

$sql = "SELECT uid,pic_small,title,text_short FROM tbl_products WHERE prod_type='$prod_type' order by prod_type";
$res = mysql_query($sql);

<?
//loop through all results and show them...
while ($item = mysql_fetch_array($res)) {
//if no pic set use default..
if ($item[&quot;pic_small&quot;] == &quot;&quot $item[&quot;pic_small&quot;]=&quot;no_pic_small.jpg&quot;;
?>

print $item[text_short]

}


What I would like is, if $item[text_short] contains a specific phrase, such as 'T shirt' then it prints another phrase underneath, such as 'Best Buy'. If it doesn't match the phrase exactly then nothing is printed.

How can this be done please?

Cheers

James


__________________
It has been said that if you were to put 100 monkeys in a room for an infinite amount of time and gave each one a typewriter, eventually they would reproduce the entire works of Shakespeare. Now, thanks to the Internet, we know that's not true...

James Fielding

 

[sleipnir214]

PHP provides lots of ways to look for a string within another.

strstr() (

http://www.php.net/manual/en/function.strstr.php)

will look for the existence of one string in another.

preg_match() (

http://www.php.net/manual/en/function.preg-match.php)

and ereg() (

http://www.php.net/manual/en/function.ereg.php)

will do the same thing using regular expressions. ______________________________________________________________________
TANSTAAFL!

 

[KarveR]

probably another good one to look at is the php function switch()

It works like a series of if / thens , so you have more options depending on whats returned by the query

http://www.php.net/manual/en/control-structures.switch.php

______________________________________________________________________
There's no present like the time, they say. - Henry's Cat.