liamloveslearning Posted May 13, 2010 Share Posted May 13, 2010 Hi everyone, Im having trouble with an elseif statement, If my value equals 1 I want to show something, if it = 2 i want something else, and again something else for 3, my code doesnt work atm so im wondering if anybody can try rectify it? <?php if (@$row_rsworksorders1['intratype'] == 1) { ?> Signworld <?php } elseIF (@$row_rsworksorders1['intratype'] == 2) { ?> Embroidaworld <?php } else Media ?> Link to comment https://forums.phpfreaks.com/topic/201607-elseif-statement/ Share on other sites More sharing options...
phpchamps Posted May 13, 2010 Share Posted May 13, 2010 post full code plz.. its running at my place... Link to comment https://forums.phpfreaks.com/topic/201607-elseif-statement/#findComment-1057641 Share on other sites More sharing options...
liamloveslearning Posted May 13, 2010 Author Share Posted May 13, 2010 <?php require_once('Connections/intra_conn.php'); ?> <?php // Load the common classes require_once('includes/common/KT_common.php'); // Load the required classes require_once('includes/tfi/TFI.php'); require_once('includes/tso/TSO.php'); require_once('includes/nav/NAV.php'); // Make unified connection variable $conn_intra_conn = new KT_connection($intra_conn, $database_intra_conn); if (!function_exists("GetSQLValueString")) { function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") { if (PHP_VERSION < 6) { $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue; } $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue); switch ($theType) { case "text": $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL"; break; case "long": case "int": $theValue = ($theValue != "") ? intval($theValue) : "NULL"; break; case "double": $theValue = ($theValue != "") ? doubleval($theValue) : "NULL"; break; case "date": $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL"; break; case "defined": $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue; break; } return $theValue; } } // Filter $tfi_listworksorders4 = new TFI_TableFilter($conn_intra_conn, "tfi_listworksorders4"); $tfi_listworksorders4->addColumn("worksorders.intrajobno", "NUMERIC_TYPE", "intrajobno", "="); $tfi_listworksorders4->addColumn("worksorders.intratype", "NUMERIC_TYPE", "intratype", "="); $tfi_listworksorders4->addColumn("worksorders.intrastatus", "NUMERIC_TYPE", "intrastatus", "="); $tfi_listworksorders4->addColumn("worksorders.intracustomer", "STRING_TYPE", "intracustomer", "%"); $tfi_listworksorders4->addColumn("worksorders.intradescription", "STRING_TYPE", "intradescription", "%"); $tfi_listworksorders4->addColumn("worksorders.intraorder", "STRING_TYPE", "intraorder", "%"); $tfi_listworksorders4->addColumn("worksorders.intraartapproval", "STRING_TYPE", "intraartapproval", "%"); $tfi_listworksorders4->addColumn("worksorders.intraestimatedinstall", "STRING_TYPE", "intraestimatedinstall", "%"); $tfi_listworksorders4->addColumn("worksorders.intraprio", "STRING_TYPE", "intraprio", "%"); $tfi_listworksorders4->addColumn("worksorders.intrajobvalue", "STRING_TYPE", "intrajobvalue", "%"); $tfi_listworksorders4->addColumn("worksorders.intraterms", "STRING_TYPE", "intraterms", "%"); $tfi_listworksorders4->addColumn("worksorders.intrajobref", "STRING_TYPE", "intrajobref", "%"); $tfi_listworksorders4->Execute(); // Sorter $tso_listworksorders4 = new TSO_TableSorter("rsworksorders1", "tso_listworksorders4"); $tso_listworksorders4->addColumn("worksorders.intrajobno"); $tso_listworksorders4->addColumn("worksorders.intratype"); $tso_listworksorders4->addColumn("worksorders.intrastatus"); $tso_listworksorders4->addColumn("worksorders.intracustomer"); $tso_listworksorders4->addColumn("worksorders.intradescription"); $tso_listworksorders4->addColumn("worksorders.intraorder"); $tso_listworksorders4->addColumn("worksorders.intraartapproval"); $tso_listworksorders4->addColumn("worksorders.intraestimatedinstall"); $tso_listworksorders4->addColumn("worksorders.intraprio"); $tso_listworksorders4->addColumn("worksorders.intrajobvalue"); $tso_listworksorders4->addColumn("worksorders.intraterms"); $tso_listworksorders4->addColumn("worksorders.intrajobref"); $tso_listworksorders4->setDefault("worksorders.intrajobno"); $tso_listworksorders4->Execute(); // Navigation $nav_listworksorders4 = new NAV_Regular("nav_listworksorders4", "rsworksorders1", "", $_SERVER['PHP_SELF'], 20); //NeXTenesio3 Special List Recordset $maxRows_rsworksorders1 = $_SESSION['max_rows_nav_listworksorders4']; $pageNum_rsworksorders1 = 0; if (isset($_GET['pageNum_rsworksorders1'])) { $pageNum_rsworksorders1 = $_GET['pageNum_rsworksorders1']; } $startRow_rsworksorders1 = $pageNum_rsworksorders1 * $maxRows_rsworksorders1; // Defining List Recordset variable $NXTFilter_rsworksorders1 = "1=1"; if (isset($_SESSION['filter_tfi_listworksorders4'])) { $NXTFilter_rsworksorders1 = $_SESSION['filter_tfi_listworksorders4']; } // Defining List Recordset variable $NXTSort_rsworksorders1 = "worksorders.intrajobno"; if (isset($_SESSION['sorter_tso_listworksorders4'])) { $NXTSort_rsworksorders1 = $_SESSION['sorter_tso_listworksorders4']; } mysql_select_db($database_intra_conn, $intra_conn); $query_rsworksorders1 = "SELECT worksorders.intrajobno, worksorders.intratype, worksorders.intrastatus, worksorders.intracustomer, worksorders.intradescription, worksorders.intraorder, worksorders.intraartapproval, worksorders.intraestimatedinstall, worksorders.intraprio, worksorders.intrajobvalue, worksorders.intraterms, worksorders.intrajobref, worksorders.id FROM worksorders WHERE {$NXTFilter_rsworksorders1} ORDER BY {$NXTSort_rsworksorders1}"; $query_limit_rsworksorders1 = sprintf("%s LIMIT %d, %d", $query_rsworksorders1, $startRow_rsworksorders1, $maxRows_rsworksorders1); $rsworksorders1 = mysql_query($query_limit_rsworksorders1, $intra_conn) or die(mysql_error()); $row_rsworksorders1 = mysql_fetch_assoc($rsworksorders1); if (isset($_GET['totalRows_rsworksorders1'])) { $totalRows_rsworksorders1 = $_GET['totalRows_rsworksorders1']; } else { $all_rsworksorders1 = mysql_query($query_rsworksorders1); $totalRows_rsworksorders1 = mysql_num_rows($all_rsworksorders1); } $totalPages_rsworksorders1 = ceil($totalRows_rsworksorders1/$maxRows_rsworksorders1)-1; //End NeXTenesio3 Special List Recordset mysql_select_db($database_intra_conn, $intra_conn); $query_roweffct = "SELECT worksorders.intraestimatedinstall FROM worksorders"; $roweffct = mysql_query($query_roweffct, $intra_conn) or die(mysql_error()); $row_roweffct = mysql_fetch_assoc($roweffct); $totalRows_roweffct = mysql_num_rows($roweffct); $nav_listworksorders4->checkBoundries(); ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /> <title>Untitled Document</title> <link href="includes/skins/mxkollection3.css" rel="stylesheet" type="text/css" media="all" /> <script src="includes/common/js/base.js" type="text/javascript"></script> <script src="includes/common/js/utility.js" type="text/javascript"></script> <script src="includes/skins/style.js" type="text/javascript"></script> <script src="includes/nxt/scripts/list.js" type="text/javascript"></script> <script src="includes/nxt/scripts/list.js.php" type="text/javascript"></script> <script type="text/javascript"> $NXT_LIST_SETTINGS = { duplicate_buttons: false, duplicate_navigation: false, row_effects: true, show_as_buttons: true, record_counter: false } </script> <style type="text/css"> /* Dynamic List row settings */ .KT_col_intrajobno {width:140px; overflow:hidden;} .KT_col_intratype {width:140px; overflow:hidden;} .KT_col_intrastatus {width:140px; overflow:hidden;} .KT_col_intracustomer {width:140px; overflow:hidden;} .KT_col_intradescription {width:140px; overflow:hidden;} .KT_col_intraorder {width:140px; overflow:hidden;} .KT_col_intraartapproval {width:140px; overflow:hidden;} .KT_col_intraestimatedinstall {width:140px; overflow:hidden;} .KT_col_intraprio {width:140px; overflow:hidden;} .KT_col_intrajobvalue {width:140px; overflow:hidden;} .KT_col_intraterms {width:140px; overflow:hidden;} .KT_col_intrajobref {width:140px; overflow:hidden;} </style> </head> <body> <div class="KT_tng" id="listworksorders4"> <h1> Worksorders <?php $nav_listworksorders4->Prepare(); require("includes/nav/NAV_Text_Statistics.inc.php"); ?> </h1> <div class="KT_tnglist"> <form action="<?php echo KT_escapeAttribute(KT_getFullUri()); ?>" method="post" id="form1"> <div class="KT_options"> <a href="<?php echo $nav_listworksorders4->getShowAllLink(); ?>"><?php echo NXT_getResource("Show"); ?> <?php // Show IF Conditional region1 if (@$_GET['show_all_nav_listworksorders4'] == 1) { ?> <?php echo $_SESSION['default_max_rows_nav_listworksorders4']; ?> <?php // else Conditional region1 } else { ?> <?php echo NXT_getResource("all"); ?> <?php } // endif Conditional region1 ?> <?php echo NXT_getResource("records"); ?></a> <?php // Show IF Conditional region2 if (@$_SESSION['has_filter_tfi_listworksorders4'] == 1) { ?> <a href="<?php echo $tfi_listworksorders4->getResetFilterLink(); ?>"><?php echo NXT_getResource("Reset filter"); ?></a> <?php // else Conditional region2 } else { ?> <a href="<?php echo $tfi_listworksorders4->getShowFilterLink(); ?>"><?php echo NXT_getResource("Show filter"); ?></a> <?php } // endif Conditional region2 ?> </div> <table cellpadding="2" cellspacing="0" class="KT_tngtable"> <thead> <tr class="KT_row_order"> <th> <input type="checkbox" name="KT_selAll" id="KT_selAll"/> </th> <th id="intrajobno" class="KT_sorter KT_col_intrajobno <?php echo $tso_listworksorders4->getSortIcon('worksorders.intrajobno'); ?>"> <a href="<?php echo $tso_listworksorders4->getSortLink('worksorders.intrajobno'); ?>">Job Number</a></th> <th id="intratype" class="KT_sorter KT_col_intratype <?php echo $tso_listworksorders4->getSortIcon('worksorders.intratype'); ?>"> <a href="<?php echo $tso_listworksorders4->getSortLink('worksorders.intratype'); ?>">Type</a></th> <th id="intrastatus" class="KT_sorter KT_col_intrastatus <?php echo $tso_listworksorders4->getSortIcon('worksorders.intrastatus'); ?>"> <a href="<?php echo $tso_listworksorders4->getSortLink('worksorders.intrastatus'); ?>">Job Status</a></th> <th id="intracustomer" class="KT_sorter KT_col_intracustomer <?php echo $tso_listworksorders4->getSortIcon('worksorders.intracustomer'); ?>"> <a href="<?php echo $tso_listworksorders4->getSortLink('worksorders.intracustomer'); ?>">Customer</a></th> <th id="intradescription" class="KT_sorter KT_col_intradescription <?php echo $tso_listworksorders4->getSortIcon('worksorders.intradescription'); ?>"> <a href="<?php echo $tso_listworksorders4->getSortLink('worksorders.intradescription'); ?>">Description</a></th> <th id="intraorder" class="KT_sorter KT_col_intraorder <?php echo $tso_listworksorders4->getSortIcon('worksorders.intraorder'); ?>"> <a href="<?php echo $tso_listworksorders4->getSortLink('worksorders.intraorder'); ?>">Order Date</a></th> <th id="intraartapproval" class="KT_sorter KT_col_intraartapproval <?php echo $tso_listworksorders4->getSortIcon('worksorders.intraartapproval'); ?>"> <a href="<?php echo $tso_listworksorders4->getSortLink('worksorders.intraartapproval'); ?>">Art Appr. Date</a></th> <th id="intraestimatedinstall" class="KT_sorter KT_col_intraestimatedinstall <?php echo $tso_listworksorders4->getSortIcon('worksorders.intraestimatedinstall'); ?>"> <a href="<?php echo $tso_listworksorders4->getSortLink('worksorders.intraestimatedinstall'); ?>">Est. Install</a></th> <th id="intraprio" class="KT_sorter KT_col_intraprio <?php echo $tso_listworksorders4->getSortIcon('worksorders.intraprio'); ?>"> <a href="<?php echo $tso_listworksorders4->getSortLink('worksorders.intraprio'); ?>">Customer Required Date</a></th> <th id="intrajobvalue" class="KT_sorter KT_col_intrajobvalue <?php echo $tso_listworksorders4->getSortIcon('worksorders.intrajobvalue'); ?>"> <a href="<?php echo $tso_listworksorders4->getSortLink('worksorders.intrajobvalue'); ?>">Job Value</a></th> <th id="intraterms" class="KT_sorter KT_col_intraterms <?php echo $tso_listworksorders4->getSortIcon('worksorders.intraterms'); ?>"> <a href="<?php echo $tso_listworksorders4->getSortLink('worksorders.intraterms'); ?>">Terms</a></th> <th id="intrajobref" class="KT_sorter KT_col_intrajobref <?php echo $tso_listworksorders4->getSortIcon('worksorders.intrajobref'); ?>"> <a href="<?php echo $tso_listworksorders4->getSortLink('worksorders.intrajobref'); ?>">Job ref</a></th> <th> </th> </tr> <?php // Show IF Conditional region3 if (@$_SESSION['has_filter_tfi_listworksorders4'] == 1) { ?> <tr class="KT_row_filter"> <td> </td> <td><input type="text" name="tfi_listworksorders4_intrajobno" id="tfi_listworksorders4_intrajobno" value="<?php echo KT_escapeAttribute(@$_SESSION['tfi_listworksorders4_intrajobno']); ?>" size="20" maxlength="255" /></td> <td><select name="tfi_listworksorders4_intratype" id="tfi_listworksorders4_intratype"> <option value="1" <?php if (!(strcmp(1, KT_escapeAttribute(@$_SESSION['tfi_listworksorders4_intratype'])))) {echo "SELECTED";} ?>>Signworld</option> <option value="2" <?php if (!(strcmp(2, KT_escapeAttribute(@$_SESSION['tfi_listworksorders4_intratype'])))) {echo "SELECTED";} ?>>Embroidaworld</option> <option value="3" <?php if (!(strcmp(3, KT_escapeAttribute(@$_SESSION['tfi_listworksorders4_intratype'])))) {echo "SELECTED";} ?>>S. Media</option> </select></td> <td><select name="tfi_listworksorders4_intrastatus" id="tfi_listworksorders4_intrastatus"> <option value="1" <?php if (!(strcmp(1, KT_escapeAttribute(@$_SESSION['tfi_listworksorders4_intrastatus'])))) {echo "SELECTED";} ?>>Artwork</option> <option value="2" <?php if (!(strcmp(2, KT_escapeAttribute(@$_SESSION['tfi_listworksorders4_intrastatus'])))) {echo "SELECTED";} ?>>Production</option> </select></td> <td><input type="text" name="tfi_listworksorders4_intracustomer" id="tfi_listworksorders4_intracustomer" value="<?php echo KT_escapeAttribute(@$_SESSION['tfi_listworksorders4_intracustomer']); ?>" size="20" maxlength="255" /></td> <td><input type="text" name="tfi_listworksorders4_intradescription" id="tfi_listworksorders4_intradescription" value="<?php echo KT_escapeAttribute(@$_SESSION['tfi_listworksorders4_intradescription']); ?>" size="20" maxlength="255" /></td> <td><input type="text" name="tfi_listworksorders4_intraorder" id="tfi_listworksorders4_intraorder" value="<?php echo KT_escapeAttribute(@$_SESSION['tfi_listworksorders4_intraorder']); ?>" size="20" maxlength="255" /></td> <td><input type="text" name="tfi_listworksorders4_intraartapproval" id="tfi_listworksorders4_intraartapproval" value="<?php echo KT_escapeAttribute(@$_SESSION['tfi_listworksorders4_intraartapproval']); ?>" size="20" maxlength="255" /></td> <td><input type="text" name="tfi_listworksorders4_intraestimatedinstall" id="tfi_listworksorders4_intraestimatedinstall" value="<?php echo KT_escapeAttribute(@$_SESSION['tfi_listworksorders4_intraestimatedinstall']); ?>" size="20" maxlength="255" /></td> <td><input type="text" name="tfi_listworksorders4_intraprio" id="tfi_listworksorders4_intraprio" value="<?php echo KT_escapeAttribute(@$_SESSION['tfi_listworksorders4_intraprio']); ?>" size="20" maxlength="100" /></td> <td><input type="text" name="tfi_listworksorders4_intrajobvalue" id="tfi_listworksorders4_intrajobvalue" value="<?php echo KT_escapeAttribute(@$_SESSION['tfi_listworksorders4_intrajobvalue']); ?>" size="20" maxlength="255" /></td> <td><select name="tfi_listworksorders4_intraterms" id="tfi_listworksorders4_intraterms"> <option value="1" <?php if (!(strcmp(1, KT_escapeAttribute(@$_SESSION['tfi_listworksorders4_intraterms'])))) {echo "SELECTED";} ?>>Paid</option> <option value="2" <?php if (!(strcmp(2, KT_escapeAttribute(@$_SESSION['tfi_listworksorders4_intraterms'])))) {echo "SELECTED";} ?>>Pro Forma</option> <option value="3" <?php if (!(strcmp(3, KT_escapeAttribute(@$_SESSION['tfi_listworksorders4_intraterms'])))) {echo "SELECTED";} ?>>COD</option> <option value="4" <?php if (!(strcmp(4, KT_escapeAttribute(@$_SESSION['tfi_listworksorders4_intraterms'])))) {echo "SELECTED";} ?>>14 Days</option> <option value="5" <?php if (!(strcmp(5, KT_escapeAttribute(@$_SESSION['tfi_listworksorders4_intraterms'])))) {echo "SELECTED";} ?>>28 Days</option> </select></td> <td><input type="text" name="tfi_listworksorders4_intrajobref" id="tfi_listworksorders4_intrajobref" value="<?php echo KT_escapeAttribute(@$_SESSION['tfi_listworksorders4_intrajobref']); ?>" size="20" maxlength="255" /></td> <td><input type="submit" name="tfi_listworksorders4" value="<?php echo NXT_getResource("Filter"); ?>" /></td> </tr> <?php } // endif Conditional region3 ?> </thead> <tbody> <?php if ($totalRows_rsworksorders1 == 0) { // Show if recordset empty ?> <tr> <td colspan="14"><?php echo NXT_getResource("The table is empty or the filter you've selected is too restrictive."); ?></td> </tr> <?php } // Show if recordset empty ?> <?php if ($totalRows_rsworksorders1 > 0) { // Show if recordset not empty ?> <?php do { ?> <tr class="<?php echo @$cnt1++%2==0 ? "" : "KT_even"; ?>"> <td><input type="checkbox" name="kt_pk_worksorders" class="id_checkbox" value="<?php echo $row_rsworksorders1['id']; ?>" /> <input type="hidden" name="id" class="id_field" value="<?php echo $row_rsworksorders1['id']; ?>" /></td> <td><div class="KT_col_intrajobno"><?php echo KT_FormatForList($row_rsworksorders1['intrajobno'], 20); ?></div></td> <td><div class="KT_col_intratype"> <?php // Show IF Conditional region4 if (@$row_rsworksorders1['intratype'] == 1) { ?> Signworld <?php // else Conditional region4 } elseIF (@$row_rsworksorders1['intratype'] == 2) { ?> Embroidaworld <?php } else Media // endif Conditional region4 ?> </div></td> <td><div class="KT_col_intrastatus"><?php echo KT_FormatForList($row_rsworksorders1['intrastatus'], 20); ?></div></td> <td><div class="KT_col_intracustomer"><?php echo KT_FormatForList($row_rsworksorders1['intracustomer'], 20); ?></div></td> <td><div class="KT_col_intradescription"><?php echo KT_FormatForList($row_rsworksorders1['intradescription'], 20); ?></div></td> <td><div class="KT_col_intraorder"><?php echo KT_FormatForList($row_rsworksorders1['intraorder'], 20); ?></div></td> <td><div class="KT_col_intraartapproval"><?php echo KT_FormatForList($row_rsworksorders1['intraartapproval'], 20); ?></div></td> <td><div class="KT_col_intraestimatedinstall"><?php echo KT_FormatForList($row_rsworksorders1['intraestimatedinstall'], 20); ?></div></td> <td><div class="KT_col_intraprio"><?php echo KT_FormatForList($row_rsworksorders1['intraprio'], 20); ?></div></td> <td><div class="KT_col_intrajobvalue"><?php echo KT_FormatForList($row_rsworksorders1['intrajobvalue'], 20); ?></div></td> <td><div class="KT_col_intraterms"><?php echo KT_FormatForList($row_rsworksorders1['intraterms'], 20); ?></div></td> <td><div class="KT_col_intrajobref"><?php echo KT_FormatForList($row_rsworksorders1['intrajobref'], 20); ?></div></td> <td><a class="KT_edit_link" href="workorders.php?id=<?php echo $row_rsworksorders1['id']; ?>&KT_back=1"><?php echo NXT_getResource("edit_one"); ?></a> <a class="KT_delete_link" href="#delete"><?php echo NXT_getResource("delete_one"); ?></a></td> </tr> <?php } while ($row_rsworksorders1 = mysql_fetch_assoc($rsworksorders1)); ?> <?php } // Show if recordset not empty ?> </tbody> </table> <div class="KT_bottomnav"> <div> <?php $nav_listworksorders4->Prepare(); require("includes/nav/NAV_Text_Navigation.inc.php"); ?> </div> </div> <div class="KT_bottombuttons"> <div class="KT_operations"> <a class="KT_edit_op_link" href="#" onclick="nxt_list_edit_link_form(this); return false;"><?php echo NXT_getResource("edit_all"); ?></a> <a class="KT_delete_op_link" href="#" onclick="nxt_list_delete_link_form(this); return false;"><?php echo NXT_getResource("delete_all"); ?></a></div> <span> </span> <select name="no_new" id="no_new"> <option value="1">1</option> <option value="3">3</option> <option value="6">6</option> </select> <a class="KT_additem_op_link" href="workorders.php?KT_back=1" onclick="return nxt_list_additem(this)"><?php echo NXT_getResource("add new"); ?></a></div> </form> </div> <br class="clearfixplain" /> </div> <p> </p> </body> </html> <?php mysql_free_result($rsworksorders1); mysql_free_result($roweffct); ?> Link to comment https://forums.phpfreaks.com/topic/201607-elseif-statement/#findComment-1057642 Share on other sites More sharing options...
Kryptix Posted May 13, 2010 Share Posted May 13, 2010 It should be like: <?php if ($var == 1) { echo "Var equals 1"; } else if ($var == 2) { echo "Var equals 2"; } else { echo "Var doesn't equal 1 or 2"; } ?> So in short, it's "else if" and not "elseIF" Also, I'm not sure what you're doing with "else Media" <?php if (@$row_rsworksorders1['intratype'] == 1) { ?> Signworld <?php } else if (@$row_rsworksorders1['intratype'] == 2) { ?> Embroidaworld <?php } else { //Do something else } ?> Link to comment https://forums.phpfreaks.com/topic/201607-elseif-statement/#findComment-1057703 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.