pixeltrace Posted February 22, 2007 Share Posted February 22, 2007 guys, i need help please check http://www.jobhirings.com/admean/client/view.php dont mind about the error on top my problem is with the 2 drop down menu i dont know how to fix it but notice that in the drop down, instead of displaying the actual value, its displaying the error. need help on this please, i haven't fixed this for 3 days already. <?php include($_SERVER['DOCUMENT_ROOT']."/admean/pagina/my_pagina_class.php"); //for the sort drop down menu $type = (!empty($_GET['type']))?$_GET['type']:1; { $order=array(1=>'client_name',2=>'clientid',3=>'date_joined'); if (!empty($type)) $sort="ORDER by '".$order[$type]."'"; } //for the seq drop down menu $seq = (!empty($_GET['seq']))?$_GET['seq']:1; { $order=array(1=>'ASC',2=>'DESC'); if (!empty($seq)) $sort="ORDER by '".$order[$seq]."'"; } $test = new JHpage; $test->sql = "SELECT * FROM clients ".$sort." DESC"; // the (basic) sql statement (use the SQL whatever you like) $result = $test->get_page_result(); // result set $num_rows = $test->get_page_num_rows(); // number of records in result set $nav_links = $test->navigation(" | ", "currentStyle"); // the navigation links (define a CSS class selector for the current link) $nav_info = $test->page_info(); // information about the number of records on page ("to" is the text between the number) $simple_nav_links = $test->back_forward_link(true); // the navigation with only the back and forward links, use true to use images $total_recs = $test->get_total_rows(); // the total number of records ?> <table width="100" border="0" cellspacing="0" cellpadding="0"> <tr> <td><img src="../images/spacer.gif" width="6" height="10"></td> <td><table width="216" border="0" cellspacing="0" cellpadding="0"> <tr> <td colspan="3" valign="top" bgcolor="#3261BB"><img src="images/spacer.gif" width="1" height="1"></td> </tr> <tr> <td align="left" bgcolor="#3261BB" width="1"><img src="images/spacer.gif" width="1" height="1"></td> <td width="214" valign="top"><table width="929" border="0" cellspacing="2" cellpadding="0"> <tr> <td colspan="6"><table width="616" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="329" class="text6"> <?php echo " total record found: " .$total_recs; ?></td> <td width="287"> </td> </tr> </table></td> </tr> <tr> <td colspan="6"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="609"> </td> <td width="100" align="right" class="text6">sort by : <select name="sortby" onFocus="selectedIndex = 0" onChange="if( options[selectedIndex].value != '') document.location = options[selectedIndex].value" class="sorteventlist"> <option value="clientmngr.php">--Please Select--</option> <option value="clientmngr.php?id=2&type=1" <?=($_GET['type']==1)?"selected":"" ?>>name</option> <option value="clientmngr.php?id=2&type=2" <?=($_GET['type']==2)?"selected":"" ?>>client ID</option> <option value="clientmngr.php?id=2&type=3" <?=($_GET['type']==3)?"selected":"" ?>>joined date</option> </select> </td> <td width="80" align="right" class="text6">sort by : <select name="sortby" onFocus="selectedIndex = 0" onChange="if( options[selectedIndex].value != '') document.location = options[selectedIndex].value" class="sorteventlist"> <option value="clientmngr.php">--Please Select--</option> <option value="clientmngr.php?id=2&seq=1" <?=($_GET['seq']==1)?"selected":"" ?>>ASC</option> <option value="clientmngr.php?id=2&seq=2" <?=($_GET['seq']==2)?"selected":"" ?>>DESC</option> </select> </td> </tr> </table></td> </tr> <tr> <td colspan="6"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="60%"> </td> <td width="39%" align="right"><!-- nav top --> <? echo "<span class='link1'>".$nav_links."</span>"; ?> </td> <td width="1%" align="right"><img src="images/spacer.gif" width="12" height="10" /></td> </tr> </table></td> </tr> <tr> <td width="63" align="center" bgcolor="#83C2ED" class="text5">ID</td> <td width="283" align="center" valign="top" bgcolor="#83C2ED" class="text5">name</td> <td width="93" align="center" bgcolor="#83C2ED" class="text5">joined date </td> <td width="236" align="center" bgcolor="#83C2ED" class="text5">rate agreed </td> <td width="194" align="center" bgcolor="#83C2ED" class="text5">remark</td> <td width="46" bgcolor="#83C2ED"> </td> </tr> <?php for ($i = 0; $i < $num_rows; $i++) { $clientid = mysql_result($result, $i, "clientid"); $client_name = mysql_result($result, $i, "client_name"); $date_joined = mysql_result($result, $i, "date_joined"); $client_rate = mysql_result($result, $i, "client_rate"); $client_remarks = mysql_result($result, $i, "client_remarks"); ?> <tr> <td bgcolor="#FFFFCC" class="text8"> C <? echo ($clientid <= 9) ? $clientid : $clientid;?> </td> </td><td bgcolor="#FFFFCC" class="text8"> <? echo "$client_name";?> </td><td bgcolor="#FFFFCC" class="text8"> <? echo "$date_joined";?> </td><td bgcolor="#FFFFCC" class="text8"> <? echo "$client_rate";?> </td><td bgcolor="#FFFFCC" class="text8"> <? echo "$client_remarks";?> <? echo "</td><td align='center' bgcolor='#FFFFCC'><a href='clientmngr.php?id=3&clientid=$clientid' class='link1'>edit</a></td></tr>";?> <? } ?> <tr> <td colspan="6" bgcolor="#83C2ED"><span class="text6"><img src="images/spacer.gif" width="10" height="2" /></span></td> </tr> <tr> <td colspan="6"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="60%"> </td> <td width="39%" align="right"><!-- nav top --> <? echo "<span class='link1'>".$nav_links."</span>"; ?> </td> <td width="1%" align="right"><img src="images/spacer.gif" width="12" height="10" /></td> </tr> </table></td> </tr> <tr> <td colspan="6"> </td> </tr> </table></td> <td align="right" bgcolor="#3261BB" width="1"><img src="images/spacer.gif" width="1" height="1"></td> </tr> <tr> <td colspan="3" valign="top" bgcolor="#3261BB"><img src="images/spacer.gif" width="1" height="1"></td> </tr> </table></td> <td><img src="../images/spacer.gif" width="6" height="10"></td> </tr> </table> Link to comment https://forums.phpfreaks.com/topic/39597-problem-on-my-2-drop-down-menu/ Share on other sites More sharing options...
boo_lolly Posted February 22, 2007 Share Posted February 22, 2007 you seem to have a few problems with your sql query. if i were familiar with OOP, i'd be able to help you, but unfortunately i'm not. Link to comment https://forums.phpfreaks.com/topic/39597-problem-on-my-2-drop-down-menu/#findComment-191072 Share on other sites More sharing options...
pixeltrace Posted February 22, 2007 Author Share Posted February 22, 2007 the query was actually made for the pagination that i included in my page i just set certain condtions on the query to me selected from the drop down menu hope someone could help me on this. i desperately need help on this. thanks! Link to comment https://forums.phpfreaks.com/topic/39597-problem-on-my-2-drop-down-menu/#findComment-191076 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.