if else question

jckos

Hi,

I'm relatively new to php, but I have a site built by a friend who is away, and I need to modify the code.

I have a field in a mySQL db table knit
field Type NULL Default
yarnco_orig enum('YES', 'NO') Yes YES

I have a web page that calls vairous values from this table and prints them to the page (The site uses FastTemplates) using the following:

$query = "select *, knit.description as kd from knit, knit_cat_map, brand_knit_map, yarn_brand, skill, needle_width where needle_width.id = knit.needle_id and skill.type_id = knit.skill_id and yarn_brand.brand_id = brand_knit_map.brand_id and brand_knit_map.knit_id = knit.knit_id and knit.knit_id = knit_cat_map.knit_id and knit_cat_map.knit_id=" . $knitId;

$result = mysql_query ($query, $db) or die(mysql_error());

if ($line = mysql_fetch_array($result)) {
	$tpl->assign('KNIT_ID', $line["knit_id"]);
	$tpl->assign('NAME', $line["name"]);

etc for the rest of the values in the table

I want to a line that says if yarnco_orig is equal to 'YES' echo "MY html and TEXT"

if yarnco_orig is eqaul to 'NO' leave blank.

I've made a few attempts but there is something wrong with what I'm doing.

Any suggestions?

largo

hoping I understand the request...

if ($line = mysql...
    if ($line["yarnco_orig"]) == "YES") {
        // do something.
    }
}

-m.

jckos

I thought that's what I should be doing and tried a variation originally, but I get the following error:

Parse error: parse error, unexpected T_IS_EQUAL in /home/theyarnc/public_html/knit_display.php on line 69

69 is the second if clause

This is what the code looks like:

if ($line = mysql_fetch_array($result)) {
	$tpl->assign('YARNCO_ORIG', $line     ["yarnco_orig"]);

	  if ($line["yarnco_orig"]) == "YES") {
	        echo "hello"
	    }


}

NiXXeD

I see your mistake. You have an extra ) in the middle of the if statement.

if ($line["yarnco_orig"]) == "YES") {

should be:

if ($line["yarnco_orig"] == 'YES') {

Note: I also changed the "YES" to 'YES' cuz you don't really need the double quotes.

Hope that fixed it for ya!

jckos

Thanks,

That seemed to remove the error, but now I need to assign a text value to YARNCO_ORIG so the text will print where I want it.

If you have any idea, let me know. I'll be playing around with it.

Thanks

jckos

This is along the lines of what I think it is

if ($line["yarnco_orig"] == 'YES') {
             $tpl->assign('YARNCO_ORIG', 'THE TEXT I WANT TO USE');
}

but that is giving me an error

jckos

Nevermind, thanks for the tips Nixxed and largo. I got it to work. I really appreciate your help!