pixeltrace

thanks!

guys, i need help how do i create tables and rows using php? thanks!

hi, this one is working if i type either the last name or first name but when i search typing both firstname and lastname on the search field its giving me a (0) result how do i fix this in such a way that if i also search using both firstname and last name i can still get the correct result. ex. if i search "juan pedro" or "juan" or "pedro" they will still give me juan pedro in my result thanks!

guys, i need help what codes do i need to use so that in my sql query i can search items WHERE lastname AND firstname LIKE '%". $_POST['name'] ."%'"; i have a form wherein you can search via the name of the person either using the first name or last name. but the query that i am using doesnt work and its giving me a (0) results whats wrong in my query codes? need help please thanks!

i am sorry, i placed the wrong information on my second reply the real problem here is, i have a form page wherein you can search via the email address of whoever person you want to search and the result is being submitted to a page wherein you can view the results and this page has a table wherein you can make a new search of a person's email my problem is, when i try to make a new search, i am getting errors like Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in c:\hosting\webhost4life\member\diorgrace\new\admean\pagina\my_pagina_class.php on line 90 Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in c:\hosting\webhost4life\member\diorgrace\new\admean\pagina\my_pagina_class.php on line 63 Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in c:\hosting\webhost4life\member\diorgrace\new\admean\pagina\my_pagina_class.php on line 68 Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in c:\hosting\webhost4life\member\diorgrace\new\admean\pagina\my_pagina_class.php on line 63 Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in c:\hosting\webhost4life\member\diorgrace\new\admean\pagina\my_pagina_class.php on line 68 Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in c:\hosting\webhost4life\member\diorgrace\new\admean\pagina\my_pagina_class.php on line 63 Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in c:\hosting\webhost4life\member\diorgrace\new\admean\pagina\my_pagina_class.php on line 68 Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in c:\hosting\webhost4life\member\diorgrace\new\admean\pagina\my_pagina_class.php on line 63 Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in c:\hosting\webhost4life\member\diorgrace\new\admean\pagina\my_pagina_class.php on line 68 Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in c:\hosting\webhost4life\member\diorgrace\new\admean\pagina\my_pagina_class.php on line 63 Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in c:\hosting\webhost4life\member\diorgrace\new\admean\pagina\my_pagina_class.php on line 68 Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in c:\hosting\webhost4life\member\diorgrace\new\admean\pagina\my_pagina_class.php on line 63 Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in c:\hosting\webhost4life\member\diorgrace\new\admean\pagina\my_pagina_class.php on line 68 i think i cant get any information from the database this is the code for that page <?php session_start(); if (session_is_registered("username")){ include("pagina/my_pagina_class.php"); //establish query array $query_array = array(); //append each input field into a new index //in the query_array if the user selected //it or entered information in the field if(!empty($_POST['email'])){ $query_array[] = "email LIKE '%". $_POST['email'] ."%'"; } //turn array into string $query_string = implode(" AND ", $query_array); //-for the new search if(isset($_GET['email']) && $_GET['email']!='') $query_string = $_GET['email']; else $query_string = implode(" AND ", $query_array); $test = new JHpage; $test->sql = "SELECT * FROM applicant WHERE ". $query_string .""; // 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 ?> <script type="text/JavaScript"> <!-- function MM_openBrWindow(theURL,winName,features) { //v2.0 window.open(theURL,winName,features); } //--> </script> <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="897" border="0" cellspacing="2" cellpadding="0"> <tr> <td colspan="6" align="right"><form method="get" action="searchcnddate.php?id=<? echo "$id"; ?>"> <input name="id" type="hidden" value="3" /> <table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="407"><span class="text6"> <?php echo " total record found: " .$total_recs; ?> </span></td> <td width="486" align="right" class="text6">new search : <input type="text" name="email"> <input type="submit" name="Submit" value="search" /> </td> </tr> </table> </form></td> </tr> <form action="jobrepost.php" method="post"> <tr> <td colspan="6"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="60%" align="left" class="text8"> </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="1" height="1" /></td> </tr> </table></td> </tr> <tr> <td width="68" align="center" bgcolor="#83C2ED" class="text5">ID</td> <td width="320" align="center" valign="top" bgcolor="#83C2ED" class="text5">name</td> <td width="220" align="center" bgcolor="#83C2ED" class="text5">email</td> <td width="163" align="center" bgcolor="#83C2ED" class="text5">level</td> <td width="125" align="center" bgcolor="#83C2ED" class="text5">date registered </td> </tr> <?php for ($i = 0; $i < $num_rows; $i++) { $appid = mysql_result($result, $i, "appid"); $fname = mysql_result($result, $i, "fname"); $lname = mysql_result($result, $i, "lname"); $email = mysql_result($result, $i, "email"); $specialization = mysql_result($result, $i, "specialization"); $level = mysql_result($result, $i, "level"); $dateregistered = mysql_result($result, $i, "dateregistered"); ?> <tr> <td align="center" bgcolor="#FFFFCC" class="text8"><span class="text5"> </span> A<? echo ($appid <= 9) ? $appid : $appid;?> </td> <td bgcolor="#FFFFCC"> <a href="javascript:;" class="link1" onClick="MM_openBrWindow('resume/preview.php?appid=<? echo "$appid"; ?>','','scrollbars=yes,width=760')"> <? echo " ".$fname." ".$lname." "; ?></a></td> <td bgcolor="#FFFFCC" class="text8"> <? echo "$email";?> </td> <td bgcolor="#FFFFCC" class="text8"> <? echo "$level";?><br></td> <td bgcolor="#FFFFCC" class="text8"><? echo "$dateregistered";?></td> <? echo "</td></tr>"; ?> <? } ?> <tr> <td colspan="6" bgcolor="#83C2ED"><img src="../images/spacer.gif" width="10" height="2" /></td> </tr> <tr> <td colspan="6"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="60%" align="left" class="text8"> </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="1" height="1" /></td> </tr> </table></td> </tr> </form> <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> <? }else{ echo "<font face=\"Arial\">You are not authorized to access this page ... Please <a href='../index.php'>Login</a></font>"; } ?> i think the error is on the new search form and my php codes for the new search but i dont know how to fix it hope you could help me with this. thanks!

its working fine now thanks!

in the view.php if i go directly to that page http://www.jobhirings.com/new/jobsearch/view.php i am getting this errors Notice: Undefined index: specialization in c:\hosting\webhost4life\member\diorgrace\new\jobsearch\view.php on line 6 Notice: Undefined index: keywords in c:\hosting\webhost4life\member\diorgrace\new\jobsearch\view.php on line 24 and i need to get rid of it. below is the codes for view.php <?php include("../admean/pagina/my_pagina_class.php"); //-for the keywords, specialization condition $cond = ''; if($_POST['specialization'] != ''){ $cond = " AND specialization = '". $_POST['specialization'] ."'"; } //-for the drop down menu if(isset($_GET['sort1']) && $_GET['sort1']!='') $sort1 = $_GET['sort1']; else $sort1 = "j_position"; if(isset($_GET['sort2']) && $_GET['sort2']!='') $sort2 = $_GET['sort2']; else $sort2 = "ASC"; //- $test = new JHpage; $test->sql = "SELECT * FROM job_ads WHERE j_status ='open' AND j_position LIKE '%". $_POST['keywords'] ."%'".$cond." ORDER BY ".$sort1 ." ".$sort2.""; // 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 ?> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <title>:: Job HiRings - Contact Us ::</title> <style type="text/css"> <!-- body { background-image: url(../images/main/bg.gif); } --> </style> <link href="../css.css" rel="stylesheet" type="text/css"> <script type="text/JavaScript"> <!-- function MM_openBrWindow(theURL,winName,features) { //v2.0 window.open(theURL,winName,features); } //--> </script> </head> <body> <table width="776" border="0" align="center" cellpadding="0" cellspacing="0"> <tr> <td><table width="776" border="0" cellspacing="0" cellpadding="0"> <tr> <td colspan="3" valign="top"><img src="../images/main/top.gif" width="776" height="6"></td> </tr> <tr> <td width="6" align="left" valign="top" background="../images/main/left.gif"><img src="../images/main/left.gif" width="6" height="14"></td> <td width="764" bgcolor="#FFFFFF"><table width="764" border="0" cellspacing="0" cellpadding="0"> <tr> <td colspan="2" valign="top"><img src="../images/contactus/flashmenu.gif" width="764" height="54"></td> </tr> <form method="post" action="view.php" name="searchform"><tr> <td width="525" valign="top" height="159"><img src="../images/job/flash03.gif" width="525" height="159"></td> <td width="239" valign="top"> <!--start of search form--> <table width="239" border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF"> <tr> <td colspan="4" valign="top"><img src="../images/contactus/subquickjob01.gif" width="239" height="32"></td> </tr> <tr> <td width="8" rowspan="8" align="left" background="../images/aboutus/subquickjob02.gif"><img src="../images/contactus/subquickjob02.gif" width="8" height="112"></td> <td colspan="2" valign="top" class="text1"><img src="../images/spacer.gif" width="10" height="4"></td> <td width="5" rowspan="8" align="right" background="../images/contactus/subquickjob03.gif"><img src="../images/contactus/subquickjob03.gif" width="5" height="112"></td> </tr> <tr> <td colspan="2" class="text1"> Keywords</td> </tr> <tr> <td colspan="2" align="right"><input name="keywords" type="text" class="field2"> </td> </tr> <tr> <td colspan="2" align="right" valign="top"><span class="text1"><img src="../images/main/spacer.gif" width="1" height="1"></span></td> </tr> <tr> <td colspan="2" class="text1"> Job Specialization </td> </tr> <tr> <td colspan="2" align="right"> <select name="specialization" class="field3"> <option value="">All</option> <? include '../admean/db_connect.php'; $uSql = "SELECT specialization FROM specialization"; $uResult = mysql_query($uSql, $connection); if(!$uResult){ echo 'no data found'; }else{ while($uRow = mysql_fetch_row($uResult)){ ?> <option value="<?= $uRow[0]?>"><?= $uRow[0]?></option> <? } } ?> </select> </td> </tr> <tr> <td colspan="2" align="right" valign="top"><img src="../images/main/spacer.gif" width="1" height="1"></td> </tr> <tr> <td width="155"> <a href="advancedsearch.php" class="link1">advanced search</a> </td> <td width="71" align="right"><input name="Submit2" type="submit" class="button1" value="Search"> </td> </tr> <tr> <td colspan="4" valign="top"><img src="../images/contactus/subquickjob04.gif" width="239" height="15"></td> </tr> </table> <!--end of search form--> </td> </tr></form> <tr> <td height="62" colspan="2" align="left" valign="top" bgcolor="#FFFFFF"><table width="764" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="181" valign="top" background="../images/contactus/middlebar03.gif"> </td> <td width="344" valign="top"><img src="../images/contactus/middlebar02.gif" width="344" height="50"></td> <td width="239" background="../images/contactus/middlebar03.gif"> </td> </tr> <tr> <td colspan="3" valign="top"> </td> </tr> <tr> <td colspan="3" align="center" valign="top"> <table width="755" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="6"><img src="../admean/images/spacer.gif" width="6" height="10"></td> <td width="743" class="text9"><table width="216" border="0" cellspacing="0" cellpadding="0"> <tr> <td colspan="3" valign="top" bgcolor="#666666"><img src="../admean/job/images/spacer.gif" width="1" height="1"></td> </tr> <tr> <td align="left" bgcolor="#666666" width="1"><img src="../admean/job/images/spacer.gif" width="1" height="1"></td> <td width="214" valign="top"><table width="741" border="0" cellspacing="2" cellpadding="0"> <tr> <td colspan="5"><form method="get" action="view.php"> <table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="450"><span class="text6"> <?php echo " total record found: " .$total_recs; ?> </span></td> <td width="287" align="right" class="text6"><span class="text7">sort by :</span> <select name="sort1"> <option value="j_position">Position</option> <option value="location">Location</option> <option value="date_posted">Date Posted</option> </select> <select name="sort2"> <option value="ASC">ASC</option> <option value="DESC">DESC</option> </select> <input type="submit" name="Submit" value="Go" /> </td> </tr> </table> </form> </td> </tr> <tr> <td colspan="5"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="60%" align="left" class="text8"> </td> <td width="39%" align="right"><!-- nav top --> <? echo "<span class='link1'>".$nav_links."</span>"; ?> </td> <td width="1%" align="right"><img src="../image/spacer.gif" width="1" height="1" /></td> </tr> </table></td> </tr> <tr> <td width="78" bgcolor="950101" class="text9"> Date</td> <td width="212" valign="top" bgcolor="950101" class="text9"> Position </td> <td width="243" bgcolor="950101" class="text9"> Company </td> <td width="198" colspan="2" bgcolor="950101" class="text5"> <span class="text9">Location</span></td> </tr> <?php for ($i = 0; $i < $num_rows; $i++) { $date_posted = mysql_result($result, $i, "date_posted"); $jobid = mysql_result($result, $i, "jobid"); $j_position = mysql_result($result, $i, "j_position"); $c_name = mysql_result($result, $i, "c_name"); $location = mysql_result($result, $i, "location"); ?> <tr> <td bgcolor="#e5e5e5" class="text4"> <? echo "$date_posted"; ?></td> <td bgcolor="#e5e5e5"> <a href="javascript:;" class="link1" onClick="MM_openBrWindow('jobpost.php?jobid=<? echo "$jobid"; ?>','','scrollbars=yes,width=720,height=700')"><? echo "$j_position";?></a></td> <td bgcolor="#e5e5e5" class="text4"> <? echo "$c_name";?> </td> <td bgcolor="#e5e5e5" class="text4"> <? echo "$location";?> </td> </tr> <? } ?> <tr> <td colspan="5" bgcolor="#950101"><img src="../admean/images/spacer.gif" width="10" height="2" /></td> </tr> <tr> <td colspan="5"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="60%" align="left" class="text8"> </td> <td width="39%" align="right"><!-- nav top --> <? echo "<span class='link1'>".$nav_links."</span>"; ?> </td> <td width="1%" align="right"><img src="../image/spacer.gif" width="1" height="1" /></td> </tr> </table></td> </tr> </form> <tr> <td colspan="5"> </td> </tr> </table></td> <td align="right" bgcolor="#666666" width="1"><img src="../admean/job/images/spacer.gif" width="1" height="1"></td> </tr> <tr> <td colspan="3" valign="top" bgcolor="#666666"><img src="../admean/job/images/spacer.gif" width="1" height="1"></td> </tr> </table></td> <td width="10"><img src="../admean/images/spacer.gif" width="6" height="10"></td> </tr> </table> </td> </tr> <tr> <td colspan="3" valign="top"> </td> </tr> </table></td> </tr> <tr> <td colspan="2" valign="top" style="background:url(../images/main/footer.gif); background-repeat:no-repeat"> <? include '../footer.php'; ?> </td> </tr> </table></td> <td width="6" background="../images/main/right.gif" align="right"><img src="../images/main/right.gif" width="6" height="3"></td> </tr> <tr> <td colspan="3" valign="bottom"><img src="../images/main/bottom.gif" width="776" height="8"></td> </tr> </table></td> </tr> </table> </body> </html> hope you could help me with this. thanks!

guys, i need help. i have a search form and its working fine. please check http://www.jobhirings.com/new/ if you input keywords on select specialization on the quick search you wont see any error however if i go directly to http://www.jobhirings.com/new/jobsearch/view.php i am getting this error on top of the page Notice: Undefined index: specialization in c:\hosting\webhost4life\member\diorgrace\new\jobsearch\view.php on line 6 Notice: Undefined index: keywords in c:\hosting\webhost4life\member\diorgrace\new\jobsearch\view.php on line 24 this is my code for the view.php page <?php include("../admean/pagina/my_pagina_class.php"); //-for the keywords, specialization condition $cond = ''; if($_POST['specialization'] != ''){ $cond = " AND specialization = '". $_POST['specialization'] ."'"; } //-for the drop down menu if(isset($_GET['sort1']) && $_GET['sort1']!='') $sort1 = $_GET['sort1']; else $sort1 = "j_position"; if(isset($_GET['sort2']) && $_GET['sort2']!='') $sort2 = $_GET['sort2']; else $sort2 = "ASC"; //- $test = new JHpage; $test->sql = "SELECT * FROM job_ads WHERE j_status ='open' AND j_position LIKE '%". $_POST['keywords'] ."%'".$cond." ORDER BY ".$sort1 ." ".$sort2.""; // 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 ?> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <title>:: Job HiRings - Contact Us ::</title> <style type="text/css"> <!-- body { background-image: url(../images/main/bg.gif); } --> </style> <link href="../css.css" rel="stylesheet" type="text/css"> <script type="text/JavaScript"> <!-- function MM_openBrWindow(theURL,winName,features) { //v2.0 window.open(theURL,winName,features); } //--> </script> </head> <body> <table width="776" border="0" align="center" cellpadding="0" cellspacing="0"> <tr> <td><table width="776" border="0" cellspacing="0" cellpadding="0"> <tr> <td colspan="3" valign="top"><img src="../images/main/top.gif" width="776" height="6"></td> </tr> <tr> <td width="6" align="left" valign="top" background="../images/main/left.gif"><img src="../images/main/left.gif" width="6" height="14"></td> <td width="764" bgcolor="#FFFFFF"><table width="764" border="0" cellspacing="0" cellpadding="0"> <tr> <td colspan="2" valign="top"><img src="../images/contactus/flashmenu.gif" width="764" height="54"></td> </tr> <form method="post" action="view.php" name="searchform"><tr> <td width="525" valign="top" height="159"><img src="../images/job/flash03.gif" width="525" height="159"></td> <td width="239" valign="top"> <!--start of search form--> <table width="239" border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF"> <tr> <td colspan="4" valign="top"><img src="../images/contactus/subquickjob01.gif" width="239" height="32"></td> </tr> <tr> <td width="8" rowspan="8" align="left" background="../images/aboutus/subquickjob02.gif"><img src="../images/contactus/subquickjob02.gif" width="8" height="112"></td> <td colspan="2" valign="top" class="text1"><img src="../images/spacer.gif" width="10" height="4"></td> <td width="5" rowspan="8" align="right" background="../images/contactus/subquickjob03.gif"><img src="../images/contactus/subquickjob03.gif" width="5" height="112"></td> </tr> <tr> <td colspan="2" class="text1"> Keywords</td> </tr> <tr> <td colspan="2" align="right"><input name="keywords" type="text" class="field2"> </td> </tr> <tr> <td colspan="2" align="right" valign="top"><span class="text1"><img src="../images/main/spacer.gif" width="1" height="1"></span></td> </tr> <tr> <td colspan="2" class="text1"> Job Specialization </td> </tr> <tr> <td colspan="2" align="right"> <select name="specialization" class="field3"> <option value="">All</option> <? include '../admean/db_connect.php'; $uSql = "SELECT specialization FROM specialization"; $uResult = mysql_query($uSql, $connection); if(!$uResult){ echo 'no data found'; }else{ while($uRow = mysql_fetch_row($uResult)){ ?> <option value="<?= $uRow[0]?>"><?= $uRow[0]?></option> <? } } ?> </select> </td> </tr> <tr> <td colspan="2" align="right" valign="top"><img src="../images/main/spacer.gif" width="1" height="1"></td> </tr> <tr> <td width="155"> <a href="advancedsearch.php" class="link1">advanced search</a> </td> <td width="71" align="right"><input name="Submit2" type="submit" class="button1" value="Search"> </td> </tr> <tr> <td colspan="4" valign="top"><img src="../images/contactus/subquickjob04.gif" width="239" height="15"></td> </tr> </table> <!--end of search form--> </td> </tr></form> <tr> <td height="62" colspan="2" align="left" valign="top" bgcolor="#FFFFFF"><table width="764" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="181" valign="top" background="../images/contactus/middlebar03.gif"> </td> <td width="344" valign="top"><img src="../images/contactus/middlebar02.gif" width="344" height="50"></td> <td width="239" background="../images/contactus/middlebar03.gif"> </td> </tr> <tr> <td colspan="3" valign="top"> </td> </tr> <tr> <td colspan="3" align="center" valign="top"> <table width="755" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="6"><img src="../admean/images/spacer.gif" width="6" height="10"></td> <td width="743" class="text9"><table width="216" border="0" cellspacing="0" cellpadding="0"> <tr> <td colspan="3" valign="top" bgcolor="#666666"><img src="../admean/job/images/spacer.gif" width="1" height="1"></td> </tr> <tr> <td align="left" bgcolor="#666666" width="1"><img src="../admean/job/images/spacer.gif" width="1" height="1"></td> <td width="214" valign="top"><table width="741" border="0" cellspacing="2" cellpadding="0"> <tr> <td colspan="5"><form method="get" action="view.php"> <table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="450"><span class="text6"> <?php echo " total record found: " .$total_recs; ?> </span></td> <td width="287" align="right" class="text6"><span class="text7">sort by :</span> <select name="sort1"> <option value="j_position">Position</option> <option value="location">Location</option> <option value="date_posted">Date Posted</option> </select> <select name="sort2"> <option value="ASC">ASC</option> <option value="DESC">DESC</option> </select> <input type="submit" name="Submit" value="Go" /> </td> </tr> </table> </form> </td> </tr> <tr> <td colspan="5"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="60%" align="left" class="text8"> </td> <td width="39%" align="right"><!-- nav top --> <? echo "<span class='link1'>".$nav_links."</span>"; ?> </td> <td width="1%" align="right"><img src="../image/spacer.gif" width="1" height="1" /></td> </tr> </table></td> </tr> <tr> <td width="78" bgcolor="950101" class="text9"> Date</td> <td width="212" valign="top" bgcolor="950101" class="text9"> Position </td> <td width="243" bgcolor="950101" class="text9"> Company </td> <td width="198" colspan="2" bgcolor="950101" class="text5"> <span class="text9">Location</span></td> </tr> <?php for ($i = 0; $i < $num_rows; $i++) { $date_posted = mysql_result($result, $i, "date_posted"); $jobid = mysql_result($result, $i, "jobid"); $j_position = mysql_result($result, $i, "j_position"); $c_name = mysql_result($result, $i, "c_name"); $location = mysql_result($result, $i, "location"); ?> <tr> <td bgcolor="#e5e5e5" class="text4"> <? echo "$date_posted"; ?></td> <td bgcolor="#e5e5e5"> <a href="javascript:;" class="link1" onClick="MM_openBrWindow('jobpost.php?jobid=<? echo "$jobid"; ?>','','scrollbars=yes,width=720,height=700')"><? echo "$j_position";?></a></td> <td bgcolor="#e5e5e5" class="text4"> <? echo "$c_name";?> </td> <td bgcolor="#e5e5e5" class="text4"> <? echo "$location";?> </td> </tr> <? } ?> <tr> <td colspan="5" bgcolor="#950101"><img src="../admean/images/spacer.gif" width="10" height="2" /></td> </tr> <tr> <td colspan="5"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="60%" align="left" class="text8"> </td> <td width="39%" align="right"><!-- nav top --> <? echo "<span class='link1'>".$nav_links."</span>"; ?> </td> <td width="1%" align="right"><img src="../image/spacer.gif" width="1" height="1" /></td> </tr> </table></td> </tr> </form> <tr> <td colspan="5"> </td> </tr> </table></td> <td align="right" bgcolor="#666666" width="1"><img src="../admean/job/images/spacer.gif" width="1" height="1"></td> </tr> <tr> <td colspan="3" valign="top" bgcolor="#666666"><img src="../admean/job/images/spacer.gif" width="1" height="1"></td> </tr> </table></td> <td width="10"><img src="../admean/images/spacer.gif" width="6" height="10"></td> </tr> </table> </td> </tr> <tr> <td colspan="3" valign="top"> </td> </tr> </table></td> </tr> <tr> <td colspan="2" valign="top" style="background:url(../images/main/footer.gif); background-repeat:no-repeat"> <? include '../footer.php'; ?> </td> </tr> </table></td> <td width="6" background="../images/main/right.gif" align="right"><img src="../images/main/right.gif" width="6" height="3"></td> </tr> <tr> <td colspan="3" valign="bottom"><img src="../images/main/bottom.gif" width="776" height="8"></td> </tr> </table></td> </tr> </table> </body> </html> hope you could help me with this. thanks a lot!

guys, i need help, i have a form wherein you can search items via email and view it on a different page this is my form code <form action="searchcnddate.php?id=3" method="post"> <td align="left" class="text7"> <input name="email" type="text" size="35" /> <input type="submit" name="Submit2" value="Search Email" class="textfield1"> <input type="hidden" name="id3" value="3" /></td> </form> and this is the code for my searchcndddate.php <?php session_start(); if (session_is_registered("username")){ $id = $_POST['id']; include("pagina/my_pagina_class.php"); //establish query array $query_array = array(); //append each input field into a new index //in the query_array if the user selected //it or entered information in the field if(!empty($_POST['email'])){ $query_array[] = "email LIKE '%". $_POST['email'] ."%'"; } //turn array into string $query_string = implode(" AND ", $query_array); //-for the new search if(isset($_GET['email']) && $_GET['email']!='') $query_string = $_GET['email']; else $query_string = implode(" AND ", $query_array); $test = new JHpage; $test->sql = "SELECT * FROM applicant WHERE ". $query_string .""; // 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 ?> <script type="text/JavaScript"> <!-- function MM_openBrWindow(theURL,winName,features) { //v2.0 window.open(theURL,winName,features); } //--> </script> <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="897" border="0" cellspacing="2" cellpadding="0"> <tr> <td colspan="6" align="right"><form method="get" action="searchcnddate.php?id=<? echo "$id"; ?>"> <input name="id" type="hidden" value="3" /> <table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="407"><span class="text6"> <?php echo " total record found: " .$total_recs; ?> </span></td> <td width="486" align="right" class="text6">new search : <input type="text" name="email"> <input type="submit" name="Submit" value="search" /> </td> </tr> </table> </form></td> </tr> <form action="jobrepost.php" method="post"> <tr> <td colspan="6"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="60%" align="left" class="text8"> </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="1" height="1" /></td> </tr> </table></td> </tr> <tr> <td width="68" align="center" bgcolor="#83C2ED" class="text5">ID</td> <td width="320" align="center" valign="top" bgcolor="#83C2ED" class="text5">name</td> <td width="220" align="center" bgcolor="#83C2ED" class="text5">email</td> <td width="163" align="center" bgcolor="#83C2ED" class="text5">level</td> <td width="125" align="center" bgcolor="#83C2ED" class="text5">date registered </td> </tr> <?php for ($i = 0; $i < $num_rows; $i++) { $appid = mysql_result($result, $i, "appid"); $fname = mysql_result($result, $i, "fname"); $lname = mysql_result($result, $i, "lname"); $email = mysql_result($result, $i, "email"); $specialization = mysql_result($result, $i, "specialization"); $level = mysql_result($result, $i, "level"); $dateregistered = mysql_result($result, $i, "dateregistered"); ?> <tr> <td align="center" bgcolor="#FFFFCC" class="text8"><span class="text5"> </span> A<? echo ($appid <= 9) ? $appid : $appid;?> </td> <td bgcolor="#FFFFCC"> <a href="javascript:;" class="link1" onClick="MM_openBrWindow('resume/preview.php?appid=<? echo "$appid"; ?>','','scrollbars=yes,width=760')"> <? echo " ".$fname." ".$lname." "; ?></a></td> <td bgcolor="#FFFFCC" class="text8"> <? echo "$email";?> </td> <td bgcolor="#FFFFCC" class="text8"> <? echo "$level";?><br></td> <td bgcolor="#FFFFCC" class="text8"><? echo "$dateregistered";?></td> <? echo "</td></tr>"; ?> <? } ?> <tr> <td colspan="6" bgcolor="#83C2ED"><img src="../images/spacer.gif" width="10" height="2" /></td> </tr> <tr> <td colspan="6"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="60%" align="left" class="text8"> </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="1" height="1" /></td> </tr> </table></td> </tr> </form> <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> <? }else{ echo "<font face=\"Arial\">You are not authorized to access this page ... Please <a href='../index.php'>Login</a></font>"; } ?> my new search on this page and its giving me errors. i dont know if my codes is correct hope you could help me with this thanks!

help please

guys, i need help, how do i set my action on my form to go here http://www.jobhirings.com/new/admean/resumemngr.php?id=3&sort1=appid&specialization=Electrical+Engineer&sort2=ASC&Submit=Go in my current code its going here http://www.jobhirings.com/new/admean/resumemngr.php?sort1=appid&specialization=Electrical+Engineer&sort2=ASC&Submit=Go without the id=3 this is my current code <?php session_start(); if (session_is_registered("username")){ include("pagina/my_pagina_class.php"); if(isset($_GET['sort1']) && $_GET['sort1']!='') $sort1 = $_GET['sort1']; else $sort1 = "appid"; if(isset($_GET['specialization']) && $_GET['specialization']!='') $sort3 = $_GET['specialization']; else $sort3 = ""; if(isset($_GET['sort2']) && $_GET['sort2']!='') $sort2 = $_GET['sort2']; else $sort2 = "ASC"; $test = new JHpage; $test->sql = "SELECT * FROM applicant WHERE specialization LIKE '%". $sort3 ."%' ORDER BY ".$sort1 ." ".$sort2.""; // 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 ?> <script type="text/JavaScript"> <!-- function MM_openBrWindow(theURL,winName,features) { //v2.0 window.open(theURL,winName,features); } //--> </script> <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="954" border="0" cellspacing="2" cellpadding="0"> <tr> <td colspan="6"><form method="get" action="resumemngr.php?id=3"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="566"><span class="text6"> <?php echo " total record found: " .$total_recs; ?> </span></td> <td width="479" align="right" class="text6">sort by : <select name="sort1"> <option value="appid">ID</option> <option value="fname">name</option> <option value="dateregistered">date registered</option> </select> <select name="specialization"> <? $uSql = "SELECT specialization FROM specialization ORDER by sid ASC"; $uResult = mysql_query($uSql, $connection); if(!$uResult){ echo 'no data found'; } else{ while($uRow = mysql_fetch_row($uResult)){ ?> <option value="<?= $uRow[0]?>"> <?= $uRow[0]?> </option> <? } } ?> </select> <select name="sort2"> <option value="ASC">ASC</option> <option value="DESC">DESC</option> </select> <input type="submit" name="Submit" value="Go" /> </td> </tr> </table> </form></td> </tr> <form action="jobrepost.php" method="post"> <tr> <td colspan="6"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="60%" align="left" class="text8"> </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="68" align="center" bgcolor="#83C2ED" class="text5">ID</td> <td width="320" align="center" valign="top" bgcolor="#83C2ED" class="text5">name</td> <td width="262" align="center" bgcolor="#83C2ED" class="text5">email</td> <td width="156" align="center" bgcolor="#83C2ED" class="text5">level</td> <td width="136" align="center" bgcolor="#83C2ED" class="text5">date registered </td> </tr> <?php for ($i = 0; $i < $num_rows; $i++) { $appid = mysql_result($result, $i, "appid"); $fname = mysql_result($result, $i, "fname"); $lname = mysql_result($result, $i, "lname"); $email = mysql_result($result, $i, "email"); $specialization = mysql_result($result, $i, "specialization"); $level = mysql_result($result, $i, "level"); $dateregistered = mysql_result($result, $i, "dateregistered"); ?> <tr> <td bgcolor="#FFFFCC" class="text8"><span class="text5"> </span> A<? echo ($appid <= 9) ? $appid : $appid;?> </td> <td bgcolor="#FFFFCC"> <a href="javascript:;" class="link1" onClick="MM_openBrWindow('../jobsearch/jobpost.php?jobid=<? echo "$jobid"; ?>','','scrollbars=yes,width=720,height=700')"> <? echo " ".$fname." ".$lname." "; ?></a></td> <td bgcolor="#FFFFCC" class="text8"> <? echo "$email";?> </td> <td bgcolor="#FFFFCC" class="text8"> <? echo "$level";?><br></td> <td bgcolor="#FFFFCC" class="text8"><? echo "$dateregistered";?></td> <? echo "</td></tr>"; ?> <? } ?> <tr> <td colspan="6" bgcolor="#83C2ED"><img src="../images/spacer.gif" width="10" height="2" /></td> </tr> <tr> <td colspan="6"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="60%" align="left" class="text8"> </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> </form> <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> <? }else{ echo "<font face=\"Arial\">You are not authorized to access this page ... Please <a href='../index.php'>Login</a></font>"; } ?> hope you could help me with this thanks!

any update on this? need help please thanks! i just need to know what code to add in such a way that it will add (1) on uRow[hits] for every item in the specialization that was selected. thanks!

this is the code for my application submit page <? session_start(); if (session_is_registered("username")){ ?> <table width="100" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="6" align="left"><img src="../images/spacer.gif" width="6" height="10" /></td> <td width="100%"><form action="resume/addresume.php" method="post" enctype="multipart/form-data"> <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="558" border="0" cellspacing="2" cellpadding="3"> <tr> <td colspan="3" valign="top"><img src="images/spacer.gif" width="10" height="1" /></td> </tr> <tr> <td colspan="3" bgcolor="#999999" class="text2">ADD CANDIDATE RESUME </td> </tr> <tr> <td colspan="3" valign="top" class="text7">* please fill-up every item on this form </td> </tr> <tr> <td width="119" align="right" valign="top" class="text6">Email :</td> <td> </td> <td width="412" class="text7"><input type="text" name="email" class="textfield"></td> </tr> <tr> <td align="right"><span class="text6">Date of registered : </span></td> <td> </td> <td><span class="text7"> <select name="dayregistered" class="textfield"> <option value="<? echo date('d'); ?>" selected><? echo date('d'); ?></option> <option value='1'>1</option> <option value='2'>2</option> <option value='3'>3</option> <option value='4'>4</option> <option value='5'>5</option> <option value='6'>6</option> <option value='7'>7</option> <option value='8'>8</option> <option value='9'>9</option> <option value='10'>10</option> <option value='11'>11</option> <option value='12'>12</option> <option value='13'>13</option> <option value='14'>14</option> <option value='15'>15</option> <option value='16'>16</option> <option value='17'>17</option> <option value='18'>18</option> <option value='19'>19</option> <option value='20'>20</option> <option value='21'>21</option> <option value='22'>22</option> <option value='23'>23</option> <option value='24'>24</option> <option value='25'>25</option> <option value='26'>26</option> <option value='27'>27</option> <option value='28'>28</option> <option value='29'>29</option> <option value='30'>30</option> <option value='31'>31</option> </select> <select name="monthregistered" class="textfield"> <option value="<? echo date('n'); ?>" selected><? echo date('M'); ?></option> <option value='1'>Jan</option> <option value='2'>Feb</option> <option value='3'>Mar</option> <option value='4'>Apr</option> <option value='5'>May</option> <option value='6'>Jun</option> <option value='7'>Jul</option> <option value='8'>Aug</option> <option value='9'>Sep</option> <option value='10'>Oct</option> <option value='11'>Nov</option> <option value='12'>Dec</option> </select> <select name="yearregistered" class="textfield"> <option value="<? echo date('Y'); ?>" selected><? echo date('Y'); ?></option> <?php for($i=2001; $i<=date("Y"); $i++){ print '<option value="'.$i.'"'; if($yearText == $i){ print '>'.$i.'</option>'; } } ?> </select> </span></td> </tr> <tr> <td align="right"><span class="text6">Job level :</span></td> <td> </td> <td><span class="text7"> <select name="level"> <option value=""></option> <?php $uSql = "SELECT level FROM level"; $uResult = mysql_query($uSql, $connection); while($uRow = mysql_fetch_array($uResult)){ echo "<option value=\"". $uRow['level'] ."\">". $uRow['level'] ."\n"; } ?> </select> </span></td> </tr> <tr> <td align="right" valign="top" class="text6">Job Specialization : </td> <td align="right" valign="top" class="text6"> </td> <td valign="top" class="text6"> <select name="specialization[]" size="8" class="textfield1" multiple> <? include 'db_connect.php'; $uSql = "SELECT specialization FROM specialization ORDER by sid ASC"; $uResult = mysql_query($uSql, $connection); if(!$uResult){ echo 'no data found'; } else{ while($uRow = mysql_fetch_row($uResult)){ ?> <option value="<?= $uRow[0]?>"><?= $uRow[0]?></option> <? } } ?> </select> </td> </tr> <tr> <td align="right" valign="top" class="text6"> </td> <td align="right" valign="top" class="text6"> </td> <td valign="top" class="text7">you can select up to 10 preferred specialization<br> * press CTRL then click on the items you wish to select </td> </tr> <tr> <td colspan="3" valign="top" class="text6"><hr></td> </tr> <tr> <td colspan="3" valign="top" class="text6">Resume : <span class="text7"> copy & paste resume here</span> </td> </tr> <tr> <td colspan="3" align="center" valign="top" class="text6"><textarea id="elm1" name="resume" rows="35" cols="80" style="width: 100%"></textarea></td> </tr> <tr> <td colspan="3" align="center" valign="top" class="text6"><input type="submit" name="Submit" value="Add Candidate" class="textfield1" /> <input type="hidden" name="fname" value="Jobhirings"><input type="hidden" name="lname" value="Database"></td> </tr> <tr> <td colspan="3" align="center" valign="top" class="text6"> </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> </form></td> <td width="6" align="right"><img src="../images/spacer.gif" width="6" height="10" /></td> </tr> </table> <? }else{ echo "<font face=\"Arial\">You are not authorized to access this page ... Please <a href='../index.php'>Login</a></font>"; } ?> this is the code for my addresume.php page <? session_start(); if (session_is_registered("username")){ }else{ echo "<font face=\"Arial\">You are not authorized to access this page ... Please <a href='../index.php'>Login</a></font>"; } include '../db_connect.php'; $email = $_POST['email']; $fname = $_POST['fname']; $lname = $_POST['lname']; $dayregistered = $_POST['dayregistered']; $monthregistered = $_POST['monthregistered']; $yearregistered = $_POST['yearregistered']; $specialization = implode("\n", $_POST['specialization']); $level = $_POST['level']; $resume = $_POST['resume']; // 0000-00-00 $dateregistered = $yearregistered.'-'.$monthregistered.'-'.$dayregistered; //email verification 2 $sql_username_check = mysql_query("SELECT username FROM applicant WHERE email='$email'"); $username_check = mysql_num_rows($sql_username_check); if($username_check > 0){ echo '<script language=javascript> alert("Email is already used!");history.back() = "../resumemngr.php?id=1";</script>'; unset($username); exit(); } $email = stripslashes($email); $fname = stripslashes($fname); $lname = stripslashes($lname); $dateregistered = stripslashes($dateregistered); $specialization = stripslashes($specialization); $level = stripslashes($level); $resume = mysql_real_escape_string(stripslashes($_POST['resume'])); $sql = mysql_query("INSERT INTO applicant (email, username, fname, lname, dateregistered, specialization, level, resume ) VALUES('$email', '$email', '$fname', '$lname', '$dateregistered', '$specialization', '$level', '$resume')") or die (mysql_error()); if(!$sql){ echo '<script language=javascript> alert("Error adding candidate");history.back() = "../resumemngr.php?id=1";</script>'; exit(); } else { $appid = mysql_insert_id(); echo '<script language=javascript> alert("New candidate has been added!");top.location = "../resumemngr.php?id=1";</script>'; } ?> and this is the code for my specialization page $uSql = "SELECT * FROM specialization"; $uResult = mysql_query($uSql, $connection); if(!$uResult){ echo 'no data found'; }else{ while($uRow = mysql_fetch_array($uResult)){ ?> <tr> <td width="4" align="left" valign="top" class="text6"><img src="images/spacer.gif" width="4" height="10" /></td> <td width="536" align="left" valign="top" class="text6">» <?= $uRow[specialization]?> <a href="rlist.php?specialization=$specialization" class="link2">[<?= $uRow[hits]?>]</a></td> </tr> <? } } ?> notice the uRow[hits]? i want to add a code in my addresume.php page that will add 1 on every specialization selected from my application form page to my specialization page. need help thanks!

guys, i need help, i have 2 tables specialization and applicant table both on the same database i have a resume application form and on that form i have a selectbox wherein the user can select as many specialization that he/she wanted on the process page, those items are being imploded and inserted into the applicant table i have a page that list down all the specialization items from specialization table and it has a area there that shows the total number of applicant that falls on the specific specialization the field name of specialization from the specialization table and applicant table is the same my problem now is, how do i set in the other page that will show the total number of applicants that falls on that specific specialization below is my codes for the specialization page <? include 'db_connect.php'; $uSql = "SELECT * FROM specialization"; $uResult = mysql_query($uSql, $connection); if(!$uResult){ echo 'no data found'; }else{ while($uRow = mysql_fetch_array($uResult)){ ?> <tr> <td width="4" align="left" valign="top" class="text6"><img src="images/spacer.gif" width="4" height="10" /></td> <td width="536" align="left" valign="top" class="text6">» <?= $uRow[specialization]?> <a href="rlist.php?specialization=$specialization" class="link2">[<?= $uRow[hits]?>]</a></td> </tr> <? } } ?> and from my form page, this is the code that process my form <? session_start(); if (session_is_registered("username")){ }else{ echo "<font face=\"Arial\">You are not authorized to access this page ... Please <a href='../index.php'>Login</a></font>"; } include '../db_connect.php'; $email = $_POST['email']; $fname = $_POST['fname']; $lname = $_POST['lname']; $dayregistered = $_POST['dayregistered']; $monthregistered = $_POST['monthregistered']; $yearregistered = $_POST['yearregistered']; $specialization = implode("\n", $_POST['specialization']); $level = $_POST['level']; $resume = $_POST['resume']; // 0000-00-00 $dateregistered = $yearregistered.'-'.$monthregistered.'-'.$dayregistered; //email verification 2 $sql_username_check = mysql_query("SELECT username FROM applicant WHERE email='$email'"); $username_check = mysql_num_rows($sql_username_check); if($username_check > 0){ echo '<script language=javascript> alert("Email is already used!");history.back() = "../resumemngr.php?id=1";</script>'; unset($username); exit(); } $email = stripslashes($email); $fname = stripslashes($fname); $lname = stripslashes($lname); $dateregistered = stripslashes($dateregistered); $specialization = stripslashes($specialization); $level = stripslashes($level); $resume = mysql_real_escape_string(stripslashes($_POST['resume'])); $sql = mysql_query("INSERT INTO applicant (email, username, fname, lname, dateregistered, specialization, level, resume ) VALUES('$email', '$email', '$fname', '$lname', '$dateregistered', '$specialization', '$level', '$resume')") or die (mysql_error()); if(!$sql){ echo '<script language=javascript> alert("Error adding candidate");history.back() = "../resumemngr.php?id=1";</script>'; exit(); } else { $appid = mysql_insert_id(); echo '<script language=javascript> alert("New candidate has been added!");top.location = "../resumemngr.php?id=1";</script>'; } ?> what codes do i need to add so that my process page will also update my specialization page with the items added base from the specialization that they selected. hope you could help me with this. thanks!

can you help me with the codes? i dont have any idea how to fix it. thanks!

help please! thanks!

oh, i missed that one ' hehehe. thanks!

guys, i need help, i have a form wherein you can copy and paste your text resume inside everything is working fine in the form except for the page wherein, it updates the database i am getting an error message on the line where my email address falls: error:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near pixeltrace@gmail.com how to fix this? i already tried using stripslashes but i wasnt able to fix the problem below is the code for my updateresume.php page <?php session_start(); if (session_is_registered("username")){ if($_SESSION['account_type'] == 'applicant'){ //if(($_SESSION['user_level'] == administrator) || ($_SESSION['user_level'] == staff)){ include '../admean/db_connect.php'; $username = $_POST['username']; $appid = $_POST['appid']; $resume = $_POST['resume']; $resume = stripslashes($resume); $sql="UPDATE applicant SET resume='$resume WHERE username='$username'"; mysql_query($sql) or die("error:".mysql_error()); echo '<script language=javascript> alert("Your resume has been updated!");top.location = "profile.php?id=1&appid='.$appid.'";</script>'; }else{ echo "<font face=\"Arial\">You are not authorized to access this page ... Please <a href='../index.php'>Login</a></font>"; } } ?> hope you could help me with this. thanks!

hi, any help on this one? thanks!

guys, i need help, i have a selectbox in my update form items on my selectbox will be taken from the database and from the update form you can re-select other items and have it update my problem now is, i can't make it work, i use implode and i am getting some errors implode()function implode: argument to implode must be in array how do i fix this? below is the code for my selectbox <select name="specialization[]" size="8" class="field3" multiple="multiple"> <option value="<? echo implode("\n",$specialization); ?>" selected><? echo implode($specialization); ?></option> <? include 'db_connect.php'; $uSql = "SELECT specialization FROM specialization ORDER by sid ASC"; $uResult = mysql_query($uSql, $connection); if(!$uResult){ echo 'no data found'; } else{ while($uRow = mysql_fetch_row($uResult)){ ?> <option value="<?= $uRow[0]?>"> <?= $uRow[0]?> </option> <? } } ?> </select> hope you could help me with this. thanks!

guys, i need help on my advance seach form. i have 2 page, advanced_search.php and view3.php this is the code for my advanced_search.php <form id="form1" name="form1" method="post" action="view3.php"> <table width="473" border="0" cellspacing="4" cellpadding="0"> <tr> <td width="465" valign="top">Keywords : <input type="text" name="textfield"></td> </tr> <tr> <td valign="top">Country : <select name="country"> <option value="">Select A Country</option> <option value="Afghanistan">Afghanistan</option> <option value="Albania">Albania</option> <option value="Algeria">Algeria</option> <option value="American Samoa">American Samoa</option> <option value="Andorra">Andorra</option> <option value="Angola">Angola</option> <option value="Anguilla">Anguilla</option> </select> <br></td> </tr> <tr> <td>Specialization<br> <select name="specialization[]" size="8" class="textfield1" multiple> <? include '../admean/db_connect.php'; $uSql = "SELECT specialization FROM specialization ORDER by sid ASC"; $uResult = mysql_query($uSql, $connection); if(!$uResult){ echo 'no data found'; } else{ while($uRow = mysql_fetch_row($uResult)){ ?> <option value="<?= $uRow[0]?>"> <?= $uRow[0]?> </option> <? } } ?> </select></td> </tr> <tr> <td>Position Level <select name="level[]" multiple> <option value="">Select Position Level</option> <? $uSql = "SELECT level FROM level"; $uResult = mysql_query($uSql, $connection); if(!$uResult){ echo 'no data found'; }else{ while($uRow = mysql_fetch_array($uResult)){ ?> <option value="<?= $uRow[level]?>"> <?= $uRow[level]?> </option> <? } } ?> </select></td> </tr> <tr> <td>Job Type <span class="text3"> <input type="checkbox" name="jtype[]" value="Permanent" > Permanent <input type="checkbox" name="jtype[]" value="Contract" /> Contract <input type="checkbox" name="jtype[]" value="Part-Time" /> Part-Time </span></td> </tr> <tr> <td><input type="submit" name="Submit" value="Submit"></td> </tr> </table> </form> and this is the code for my view3.php <?php include("../admean/pagina/my_pagina_class.php"); //-for the keywords, specialization .... condition $cond1 = ''; if($_POST['keywords'] != ''){ $cond1 = " j_position LIKE '%". $_POST['keywords'] ."%'"; } $cond2 = ''; if($_POST['specialization'] != ''){ $cond2 = " AND specialization LIKE '%". $_POST['specialization'] ."%'"; } $cond3 = ''; if($_POST['country'] != ''){ $cond3 = " AND country = '". $_POST['country'] ."'"; } $cond4 = ''; if($_POST['level'] != ''){ $cond4 = " AND level = '". $_POST['level'] ."'"; } $cond5 = ''; if($_POST['jtype'] != ''){ $cond5 = " AND j_type = '". $_POST['jtype'] ."'"; } //-for the drop down menu if(isset($_GET['sort1']) && $_GET['sort1']!='') $sort1 = $_GET['sort1']; else $sort1 = "j_position"; if(isset($_GET['sort2']) && $_GET['sort2']!='') $sort2 = $_GET['sort2']; else $sort2 = "ASC"; //- $test = new JHpage; $test->sql = "SELECT * FROM job_ads WHERE j_status ='open' AND ".$cond1." ".$cond2." ".$cond3." ".$cond4." ".$cond5." ORDER BY ".$sort1 ." ".$sort2.""; // 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 ?> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <title>:: Job HiRings - Contact Us ::</title> <style type="text/css"> <!-- body { background-image: url(../images/bg.gif); } --> </style> <link href="../css.css" rel="stylesheet" type="text/css"> <script type="text/JavaScript"> <!-- function MM_openBrWindow(theURL,winName,features) { //v2.0 window.open(theURL,winName,features); } //--> </script> </head> <body> <table width="776" border="0" align="center" cellpadding="0" cellspacing="0"> <tr> <td><table width="776" border="0" cellspacing="0" cellpadding="0"> <tr> <td colspan="3" valign="top"><img src="../images/main/top.gif" width="776" height="6"></td> </tr> <tr> <td width="6" align="left" valign="top" background="../images/main/left.gif"><img src="../images/main/left.gif" width="6" height="14"></td> <td width="764" bgcolor="#FFFFFF"><table width="764" border="0" cellspacing="0" cellpadding="0"> <tr> <td colspan="2" valign="top"><img src="../images/contactus/flashmenu.gif" width="764" height="54"></td> </tr> <tr> <td width="525" valign="top" height="159"><img src="../images/contactus/flash02.gif" width="525" height="159"></td> <td width="239" valign="top"> <!--start of search form--> <form method="post" action="view.php" name="searchform"> <table width="239" border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF"> <tr> <td colspan="4" valign="top"><img src="../images/contactus/subquickjob01.gif" width="239" height="32"></td> </tr> <tr> <td width="8" rowspan="8" align="left" background="../images/aboutus/subquickjob02.gif"><img src="../images/contactus/subquickjob02.gif" width="8" height="112"></td> <td colspan="2" valign="top" class="text1"><img src="../images/spacer.gif" width="10" height="4"></td> <td width="5" rowspan="8" align="right" background="../images/contactus/subquickjob03.gif"><img src="../images/contactus/subquickjob03.gif" width="5" height="112"></td> </tr> <tr> <td colspan="2" class="text1"> Keywords</td> </tr> <tr> <td colspan="2" align="right"><input name="keywords" type="text" class="field2"> </td> </tr> <tr> <td colspan="2" align="right" valign="top"><span class="text1"><img src="../images/main/spacer.gif" width="1" height="1"></span></td> </tr> <tr> <td colspan="2" class="text1"> Job Specialization </td> </tr> <tr> <td colspan="2" align="right"> <select name="specialization" class="field3"> <option value="">All</option> <? include '../admean/db_connect.php'; $uSql = "SELECT specialization FROM specialization"; $uResult = mysql_query($uSql, $connection); if(!$uResult){ echo 'no data found'; }else{ while($uRow = mysql_fetch_row($uResult)){ ?> <option value="<?= $uRow[0]?>"><?= $uRow[0]?></option> <? } } ?> </select> </td> </tr> <tr> <td colspan="2" align="right" valign="top"><img src="../images/main/spacer.gif" width="1" height="1"></td> </tr> <tr> <td width="155"> <a href="../asearch.php" class="link1">advanced search</a> </td> <td width="71" align="right"><input name="Submit2" type="submit" class="button1" value="Search"> </td> </tr> <tr> <td colspan="4" valign="top"><img src="../images/contactus/subquickjob04.gif" width="239" height="15"></td> </tr> </table> </form> <!--end of search form--> </td> </tr> <tr> <td height="62" colspan="2" align="left" valign="top" bgcolor="#FFFFFF"><table width="764" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="181" valign="top" background="../images/contactus/middlebar03.gif"> </td> <td width="344" valign="top"><img src="../images/contactus/middlebar02.gif" width="344" height="50"></td> <td width="239" background="../images/contactus/middlebar03.gif"> </td> </tr> <tr> <td colspan="3" valign="top"> </td> </tr> <tr> <td colspan="3" valign="top"> </td> </tr> <tr> <td colspan="3" align="center" valign="top"> <table width="755" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="6"><img src="../admean/images/spacer.gif" width="6" height="10"></td> <td width="743" class="text9"><table width="216" border="0" cellspacing="0" cellpadding="0"> <tr> <td colspan="3" valign="top" bgcolor="#666666"><img src="../admean/job/images/spacer.gif" width="1" height="1"></td> </tr> <tr> <td align="left" bgcolor="#666666" width="1"><img src="../admean/job/images/spacer.gif" width="1" height="1"></td> <td width="214" valign="top"><table width="741" border="0" cellspacing="2" cellpadding="0"> <tr> <td colspan="5"><form method="get" action="view.php"> <table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="450"><span class="text6"> <?php echo " total record found: " .$total_recs; ?> </span></td> <td width="287" align="right" class="text6"><span class="text7">sort by :</span> <select name="sort1"> <option value="j_position">Position</option> <option value="location">Location</option> <option value="date_posted">Date Posted</option> </select> <select name="sort2"> <option value="ASC">ASC</option> <option value="DESC">DESC</option> </select> <input type="submit" name="Submit" value="Go" /> </td> </tr> </table> </form> </td> </tr> <tr> <td colspan="5"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="60%" align="left" class="text8"> </td> <td width="39%" align="right"><!-- nav top --> <? echo "<span class='link1'>".$nav_links."</span>"; ?> </td> <td width="1%" align="right"><img src="../image/spacer.gif" width="1" height="1" /></td> </tr> </table></td> </tr> <tr> <td width="78" bgcolor="950101" class="text9"> Date</td> <td width="212" valign="top" bgcolor="950101" class="text9"> Position </td> <td width="243" bgcolor="950101" class="text9"> Company </td> <td width="198" colspan="2" bgcolor="950101" class="text5"> <span class="text9">Location</span></td> </tr> <?php for ($i = 0; $i < $num_rows; $i++) { $date_posted = mysql_result($result, $i, "date_posted"); $jobid = mysql_result($result, $i, "jobid"); $j_position = mysql_result($result, $i, "j_position"); $c_name = mysql_result($result, $i, "c_name"); $location = mysql_result($result, $i, "location"); ?> <tr> <td bgcolor="#e5e5e5" class="text4"> <? echo "$date_posted"; ?></td> <td bgcolor="#e5e5e5"> <a href="javascript:;" class="link1" onClick="MM_openBrWindow('jobpost.php?jobid=<? echo "$jobid"; ?>','','scrollbars=yes,width=720,height=700')"><? echo "$j_position";?></a></td> <td bgcolor="#e5e5e5" class="text4"> <? echo "$c_name";?> </td> <td bgcolor="#e5e5e5" class="text4"> <? echo "$location";?> </td> </tr> <? } ?> <tr> <td colspan="5" bgcolor="#950101"><img src="../admean/images/spacer.gif" width="10" height="2" /></td> </tr> <tr> <td colspan="5"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="60%" align="left" class="text8"> </td> <td width="39%" align="right"><!-- nav top --> <? echo "<span class='link1'>".$nav_links."</span>"; ?> </td> <td width="1%" align="right"><img src="../image/spacer.gif" width="1" height="1" /></td> </tr> </table></td> </tr> </form> <tr> <td colspan="5"> </td> </tr> </table></td> <td align="right" bgcolor="#666666" width="1"><img src="../admean/job/images/spacer.gif" width="1" height="1"></td> </tr> <tr> <td colspan="3" valign="top" bgcolor="#666666"><img src="../admean/job/images/spacer.gif" width="1" height="1"></td> </tr> </table></td> <td width="10"><img src="../admean/images/spacer.gif" width="6" height="10"></td> </tr> </table> </td> </tr> <tr> <td colspan="3" valign="top"> </td> </tr> <tr> <td colspan="3" valign="top"> </td> </tr> </table></td> </tr> <tr> <td colspan="2" valign="top" style="background:url(../images/main/footer.gif); background-repeat:no-repeat"> <? include '../footer.php'; ?> </td> </tr> </table></td> <td width="6" background="../images/main/right.gif" align="right"><img src="../images/main/right.gif" width="6" height="3"></td> </tr> <tr> <td colspan="3" valign="bottom"><img src="../images/main/bottom.gif" width="776" height="8"></td> </tr> </table></td> </tr> </table> </body> </html> i am getting problem since i can't make it work and i am getting this errors on my view3.php Notice: Undefined index: keywords in c:\hosting\webhost4life\member\diorgrace\new\jobsearch\view3.php on line 6 Notice: Undefined index: specialization in c:\hosting\webhost4life\member\diorgrace\new\jobsearch\view3.php on line 10 Notice: Undefined index: level in c:\hosting\webhost4life\member\diorgrace\new\jobsearch\view3.php on line 18 Notice: Undefined index: jtype in c:\hosting\webhost4life\member\diorgrace\new\jobsearch\view3.php on line 22 my basic search form is working and i just base the cond of view3.php from my basic search engine but i cant make it work, maybe because now i am using selectbox with mulitple selections and checkbox too hope you could help me fix this since i've been trying to solve this for couple of days already. need help. thanks a lot!

any update for this one? appreciate your help on this. thanks!

any idea as to what the solution to this maybe? hope you could help me with this. thanks!

guys, i have a problem please check http://www.jobhirings.com and click the search button on the quick job search without placing any value in the keywords and specialization notice that the view page works fine. but if you go directly to http://www.jobhirings.com/jobsearch/view.php you will get this error Notice: Undefined index: specialization in c:\hosting\webhost4life\member\diorgrace\new\jobsearch\view.php on line 6 Notice: Undefined index: keywords in c:\hosting\webhost4life\member\diorgrace\new\jobsearch\view.php on line 11 how can i fix this in such a way that if i just go directly to http://www.jobhirings.com/jobsearch/view.php i will be able to view the same thing that i can see when i click on the search button on the quick job search without placing any value. currently this is the codes for my view.php <?php include("../admean/pagina/my_pagina_class.php"); //- $cond = ''; if($_POST['specialization'] != ''){ $cond = " AND specialization = '". $_POST['specialization'] ."'"; } //- $test = new JHpage; $test->sql = "SELECT * FROM job_ads WHERE j_status ='open' AND j_position LIKE '%". $_POST['keywords'] ."%'".$cond; // 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 ?> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <title>:: Job HiRings - Contact Us ::</title> <style type="text/css"> <!-- body { background-image: url(../images/bg.gif); } --> </style> <link href="../css.css" rel="stylesheet" type="text/css"> <script type="text/JavaScript"> <!-- function MM_openBrWindow(theURL,winName,features) { //v2.0 window.open(theURL,winName,features); } //--> </script> </head> <body> <table width="776" border="0" align="center" cellpadding="0" cellspacing="0"> <tr> <td><table width="776" border="0" cellspacing="0" cellpadding="0"> <tr> <td colspan="3" valign="top"><img src="../images/main/top.gif" width="776" height="6"></td> </tr> <tr> <td width="6" align="left" valign="top" background="../images/main/left.gif"><img src="../images/main/left.gif" width="6" height="14"></td> <td width="764" bgcolor="#FFFFFF"><table width="764" border="0" cellspacing="0" cellpadding="0"> <tr> <td colspan="2" valign="top"><img src="../images/contactus/flashmenu.gif" width="764" height="54"></td> </tr> <tr> <td width="525" valign="top" height="159"><img src="../images/contactus/flash02.gif" width="525" height="159"></td> <td width="239" valign="top"> <!--start of search form--> <form method="post" action="view.php" name="searchform"> <table width="239" border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF"> <tr> <td colspan="4" valign="top"><img src="../images/contactus/subquickjob01.gif" width="239" height="32"></td> </tr> <tr> <td width="8" rowspan="8" align="left" background="../images/aboutus/subquickjob02.gif"><img src="../images/contactus/subquickjob02.gif" width="8" height="112"></td> <td colspan="2" valign="top" class="text1"><img src="../images/spacer.gif" width="10" height="4"></td> <td width="5" rowspan="8" align="right" background="../images/contactus/subquickjob03.gif"><img src="../images/contactus/subquickjob03.gif" width="5" height="112"></td> </tr> <tr> <td colspan="2" class="text1"> Keywords</td> </tr> <tr> <td colspan="2" align="right"><input name="keywords" type="text" class="field2"> </td> </tr> <tr> <td colspan="2" align="right" valign="top"><span class="text1"><img src="../images/main/spacer.gif" width="1" height="1"></span></td> </tr> <tr> <td colspan="2" class="text1"> Job Specialization </td> </tr> <tr> <td colspan="2" align="right"> <select name="specialization" class="field3"> <option value="">All</option> <? include '../admean/db_connect.php'; $uSql = "SELECT specialization FROM specialization"; $uResult = mysql_query($uSql, $connection); if(!$uResult){ echo 'no data found'; }else{ while($uRow = mysql_fetch_row($uResult)){ ?> <option value="<?= $uRow[0]?>"><?= $uRow[0]?></option> <? } } ?> </select> </td> </tr> <tr> <td colspan="2" align="right" valign="top"><img src="../images/main/spacer.gif" width="1" height="1"></td> </tr> <tr> <td width="155"> <a href="../asearch.php" class="link1">advanced search</a> </td> <td width="71" align="right"><input name="Submit2" type="submit" class="button1" value="Search"> </td> </tr> <tr> <td colspan="4" valign="top"><img src="../images/contactus/subquickjob04.gif" width="239" height="15"></td> </tr> </table> </form> <!--end of search form--> </td> </tr> <tr> <td height="62" colspan="2" align="left" valign="top" bgcolor="#FFFFFF"><table width="764" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="181" valign="top" background="../images/contactus/middlebar03.gif"> </td> <td width="344" valign="top"><img src="../images/contactus/middlebar02.gif" width="344" height="50"></td> <td width="239" background="../images/contactus/middlebar03.gif"> </td> </tr> <tr> <td colspan="3" valign="top"> </td> </tr> <tr> <td colspan="3" valign="top"> </td> </tr> <tr> <td colspan="3" align="center" valign="top"> <table width="755" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="6"><img src="../admean/images/spacer.gif" width="6" height="10"></td> <td width="743" class="text9"><table width="216" border="0" cellspacing="0" cellpadding="0"> <tr> <td colspan="3" valign="top" bgcolor="#666666"><img src="../admean/job/images/spacer.gif" width="1" height="1"></td> </tr> <tr> <td align="left" bgcolor="#666666" width="1"><img src="../admean/job/images/spacer.gif" width="1" height="1"></td> <td width="214" valign="top"><table width="741" border="0" cellspacing="2" cellpadding="0"> <tr> <td colspan="5"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="799"><span class="text6"> <?php echo " total record found: " .$total_recs; ?> </span></td> <td width="246" align="right" class="text6"> </td> </tr> </table></td> </tr> <tr> <td colspan="5"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="60%" align="left" class="text8"> </td> <td width="39%" align="right"><!-- nav top --> <? echo "<span class='link1'>".$nav_links."</span>"; ?> </td> <td width="1%" align="right"><img src="../image/spacer.gif" width="1" height="1" /></td> </tr> </table></td> </tr> <tr> <td width="78" bgcolor="950101" class="text9"> Date</td> <td width="212" valign="top" bgcolor="950101" class="text9"> Position </td> <td width="243" bgcolor="950101" class="text9"> Company </td> <td width="198" colspan="2" bgcolor="950101" class="text5"> <span class="text9">Location</span></td> </tr> <?php for ($i = 0; $i < $num_rows; $i++) { $date_posted = mysql_result($result, $i, "date_posted"); $jobid = mysql_result($result, $i, "jobid"); $j_position = mysql_result($result, $i, "j_position"); $c_name = mysql_result($result, $i, "c_name"); $location = mysql_result($result, $i, "location"); ?> <tr> <td bgcolor="#e5e5e5" class="text4"> <? echo "$date_posted"; ?></td> <td bgcolor="#e5e5e5"> <a href="javascript:;" class="link1" onClick="MM_openBrWindow('jobpost.php?jobid=<? echo "$jobid"; ?>','','scrollbars=yes,width=720,height=700')"><? echo "$j_position";?></a></td> <td bgcolor="#e5e5e5" class="text4"> <? echo "$c_name";?> </td> <td bgcolor="#e5e5e5" class="text4"> <? echo "$location";?> </td> </tr> <? } ?> <tr> <td colspan="5" bgcolor="#950101"><img src="../admean/images/spacer.gif" width="10" height="2" /></td> </tr> <tr> <td colspan="5"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="60%" align="left" class="text8"> </td> <td width="39%" align="right"><!-- nav top --> <? echo "<span class='link1'>".$nav_links."</span>"; ?> </td> <td width="1%" align="right"><img src="../image/spacer.gif" width="1" height="1" /></td> </tr> </table></td> </tr> </form> <tr> <td colspan="5"> </td> </tr> </table></td> <td align="right" bgcolor="#666666" width="1"><img src="../admean/job/images/spacer.gif" width="1" height="1"></td> </tr> <tr> <td colspan="3" valign="top" bgcolor="#666666"><img src="../admean/job/images/spacer.gif" width="1" height="1"></td> </tr> </table></td> <td width="10"><img src="../admean/images/spacer.gif" width="6" height="10"></td> </tr> </table> </td> </tr> <tr> <td colspan="3" valign="top"> </td> </tr> <tr> <td colspan="3" valign="top"> </td> </tr> </table></td> </tr> <tr> <td colspan="2" valign="top" style="background:url(../images/main/footer.gif); background-repeat:no-repeat"> <? include '../footer.php'; ?> </td> </tr> </table></td> <td width="6" background="../images/main/right.gif" align="right"><img src="../images/main/right.gif" width="6" height="3"></td> </tr> <tr> <td colspan="3" valign="bottom"><img src="../images/main/bottom.gif" width="776" height="8"></td> </tr> </table></td> </tr> </table> </body> </html> i dont know if isset will solve the problem but i dont know how to code it need help on this. thanks!

thanks its working now!