pixeltrace

the form page is just simple i have one field <form action="process.php" method="POST"> <b class="text3">Username:</b> <input type="text" name="username" maxlength="30"> <input type="submit" value="Get New Password"> </form> and a process.php page wherein the validation and sending of new password will happen. i made a process.php page i dont know if this is correct or if it will work because honestly, i still can't, write php well yet. below is the codes that i have made <? include 'db_connect.php'; $username = $_POST['username']; $query = mysql_query("SELECT password, email FROM admin_users WHERE username= '$username'") or die(mysql_error()); $row = mysql_fetch_array( $query ); //print_r($row); // to print the values of the row $password = $row["password"]; $email = $row["email"]; $sql_username_check = mysql_query("SELECT username, email FROM admin_user WHERE username='$username'"); $username_check = mysql_num_rows($sql_username_check); if($username_check > 0){ $db_password = md5($password); } $Message = ""; $Message .= "An Email from: Administrator\n"; $Message .= "New password has been created\n"; $Message .= "For: $username\n"; $Message .= "Your new password is: $newpassword\n"; $Message .= "\n\n"; $Header = administator@email.com; $To = "$email"; $Subject = "New Password"; } else { echo '<script language=javascript> alert("Username doesnt exist!");top.location = "index.php";</script>'; } ?> hope you could help me with this. thanks a lot!

guys, i need help, i have a login form and needs to have a forgot password page. what i wanted to happen is that the user will input his/her username to the forgot password field and a new password will be submitted to his/her email once he/she click on the get new password button. on the process page there should be some verifications, like to verify if the username exsists, if not it should go back to the index page if yes process will continue and will send a new password to the user. need help on this since i dont have idea how to do this since the password that i have in my database is in md5 thanks in advance!

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!

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>

thanks! my form is working fine now.

guys, i need help, i have a field in my database date_posted (date) 0000-00-00 what should be in my query if i wanted just to get the value of the day? let say <? $uSql = "SELECT date_posted(i just wanted to get the day) FROM dates"; $uResult = mysql_query($uSql, $connection); if(!$uResult){ echo 'no data found'; }else{ while($uRow = mysql_fetch_array($uResult)){ ?> whats the correct query for this? thanks!

guys, i need help i have a form that when filled up it has to update the database and at the same time to create a new page for that. i dont have any idea how to do this. hope you guys can help me with this. thanks in advance!

guys, i need help, it seems that my page is not displaying anything. i got 2 page for this 1st page has the link for that specific item to be updated the code for the link is <a href='client/edit.php?clientid=$clientid' class='link1'>edit</a> and i can say that i dont have a problem with it since the URL link is correct the 2nd page is the edit.php page wherein all the details from the database will be displayed in the text field, text area, list menu i can't find the error since its not displaying any errors on the page. the only problem is its not displaying anything on the page below is my codes for edit.php <? 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>"; } $clientid = $_POST['clientid']; ?> <form action="client/updateclient.php" method="post" id="add" name="add"> <? include '../db_connect.php'; $uSql = "SELECT * FROM clients WHERE clientid= '$clientid' "; $uResult = mysql_query($uSql, $connection); if(!$uResult){ echo 'no data found'; } else { while($uRow = mysql_fetch_row($uResult)){ ?> <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="515" border="0" cellspacing="5" cellpadding="3"> <tr> <td colspan="3" valign="top"><img src="images/spacer.gif" width="10" height="8"></td> </tr> <tr> <td colspan="3" bgcolor="#999999" class="text2">CLIENT INFORMATION </td> </tr> <tr> <td colspan="3" valign="top"><img src="images/spacer.gif" width="10" height="10"></td> </tr> <tr> <td width="137" align="right" valign="top" class="text6">Date Joined : </td> <td> </td> <td class="text7"><select name="dayjoined" > <option value="<? echo '$day_joined'; ?>"></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="monthjoined"> <option value="<? echo '$month_joined'; ?>"></option> <OPTION value='01'>Jan</option> <OPTION value='02'>Feb</option> <OPTION value='03'>Mar</option> <OPTION value='04'>Apr</option> <OPTION value='05'>May</option> <OPTION value='06'>Jun</option> <OPTION value='07'>Jul</option> <OPTION value='08'>Aug</option> <OPTION value='09'>Sep</option> <OPTION value='10'>Oct</option> <OPTION value='11'>Nov</option> <OPTION value='12'>Dec</option> </select> <select name="yearjoined"> <?php for($i=2001; $i<=date("Y"); $i++){ print '<option value="'.$i.'"'; if($yearText == $i){ print ' selected'; } print '>'.$i.'</option>'; } ?> </select></td> </tr> <tr> <td align="right" valign="top" class="text6">Company Name: </td> <td width="7" rowspan="2"> </td> <td width="363"><span class="text7"> <input name="cname" type="text" size="50" value="<? echo '$client_name'; ?>"> </span></td> </tr> <tr> <td align="right" valign="top" class="text6">Address : </td> <td width="363"><textarea name="cadd" cols="50" rows="5"><? echo '$client_add'; ?></textarea></td> </tr> <tr> <td align="right" valign="top" class="text6">Telephone No : </td> <td> </td> <td><span class="text7"> <input type="text" name="cphone" value="<? echo '$client_phone'; ?>"> </span></td> </tr> <tr> <td align="right" valign="top" class="text6">Fax : </td> <td> </td> <td><span class="text7"> <input type="text" name="cfax" value="<? echo '$client_fax'; ?>"> </span></td> </tr> <tr> <td align="right" valign="top" class="text6">Website : </td> <td> </td> <td><span class="text7"> <input type="text" name="cwebsite" value="<? echo '$client_site'; ?>"> </span></td> </tr> <tr> <td align="right"><span class="text6">Country : </span></td> <td> </td> <td><select name="ccountry"> <option value="<? echo '$client_country'; ?>"></option> <option value="AF">Afghanistan</option> <option value="AL">Albania</option> <option value="DZ">Algeria</option> <option value="AS">American Samoa</option> <option value="AD">Andorra</option> <option value="AO">Angola</option> <option value="AI">Anguilla</option> <option value="AQ">Antarctica</option> <option value="AG">Antigua and Barbuda</option> <option value="AR">Argentina</option> <option value="AM">Armenia</option> <option value="AW">Aruba</option> <option value="AU">Australia</option> <option value="AT">Austria</option> <option value="AZ">Azerbaijan</option> <option value="BS">Bahamas</option> <option value="BH">Bahrain</option> <option value="BD">Bangladesh</option> <option value="BB">Barbados</option> <option value="BY">Belarus</option> <option value="BE">Belgium</option> <option value="BZ">Belize</option> <option value="BJ">Benin</option> <option value="BM">Bermuda</option> <option value="BT">Bhutan</option> <option value="BO">Bolivia</option> <option value="BA">Bosnia Hercegovina</option> <option value="BW">Botswana</option> <option value="BV">Bouvet Island</option> <option value="BR">Brazil</option> <option value="IO">British Indian Ocean Territory</option> <option value="BN">Brunei Darussalam</option> <option value="BG">Bulgaria</option> <option value="BF">Burkina Faso</option> <option value="BI">Burundi</option> <option value="KH">Cambodia</option> <option value="CM">Cameroon</option> <option value="CA">Canada</option> <option value="CV">Cape Verde</option> <option value="KY">Cayman Islands</option> <option value="CF">Central African Republic</option> <option value="TD">Chad</option> <option value="CL">Chile</option> <option value="CN">China</option> <option value="CX">Christmas Island</option> <option value="CC">Cocos (Keeling) Islands</option> <option value="CO">Colombia</option> <option value="KM">Comoros</option> <option value="CG">Congo</option> <option value="CK">Cook Islands</option> <option value="CR">Costa Rica</option> <option value="CI">Cote D'ivoire</option> <option value="HR">Croatia</option> <option value="CU">Cuba</option> <option value="CY">Cyprus</option> <option value="CZ">Czech Republic</option> <option value="DK">Denmark</option> <option value="DJ">Djibouti</option> <option value="DM">Dominica</option> <option value="DO">Dominican Republic</option> <option value="TP">East Timor</option> <option value="EC">Ecuador</option> <option value="EG">Egypt</option> <option value="SV">EL Salvador</option> <option value="GQ">Equatorial Guinea</option> <option value="ER">Eritrea</option> <option value="EE">Estonia</option> <option value="ET">Ethiopia</option> <option value="FK">Falkland Islands (Malvinas)</option> <option value="FO">Faroe Islands</option> <option value="FJ">Fiji</option> <option value="FI">Finland</option> <option value="FR">France</option> <option value="GF">French Guiana</option> <option value="PF">French Polynesia</option> <option value="TF">French Southern Territories</option> <option value="GA">Gabon</option> <option value="GM">Gambia</option> <option value="GE">Georgia</option> <option value="DE">Germany</option> <option value="GH">Ghana</option> <option value="GI">Gibraltar</option> <option value="GR">Greece</option> <option value="GL">Greenland</option> <option value="GD">Grenada</option> <option value="GP">Guadeloupe</option> <option value="GU">Guam</option> <option value="GT">Guatemala</option> <option value="GN">Guinea</option> <option value="GW">Guinea-Bissau</option> <option value="GY">Guyana</option> <option value="HT">Haiti</option> <option value="HM">Heard and Mc Donald Islands</option> <option value="HN">Honduras</option> <option value="HK">Hong Kong</option> <option value="HU">Hungary</option> <option value="IS">Iceland</option> <option value="IN">India</option> <option value="ID">Indonesia</option> <option value="IR">Iran</option> <option value="IQ">Iraq</option> <option value="IE">Ireland</option> <option value="IL">Israel</option> <option value="IT">Italy</option> <option value="JM">Jamaica</option> <option value="JP">Japan</option> <option value="JO">Jordan</option> <option value="KZ">Kazakhstan</option> <option value="KE">Kenya</option> <option value="KI">Kiribati</option> <option value="KP">Korea (North)</option> <option value="KR">Korea (South)</option> <option value="KW">Kuwait</option> <option value="KG">Kyrgyzstan</option> <option value="LA">Laos</option> <option value="LV">Latvia</option> <option value="LB">Lebanon</option> <option value="LS">Lesotho</option> <option value="LR">Liberia</option> <option value="LY">Libyan Arab Jamahiriya</option> <option value="LI">Liechtenstein</option> <option value="LT">Lithuania</option> <option value="LU">Luxembourg</option> <option value="MO">Macau</option> <option value="MK">Macedonia</option> <option value="MG">Madagascar</option> <option value="MW">Malawi</option> <option value="MY">Malaysia</option> <option value="MV">Maldives</option> <option value="ML">Mali</option> <option value="MT">Malta</option> <option value="MH">Marshall Islands</option> <option value="MQ">Martinique</option> <option value="MR">Mauritania</option> <option value="MU">Mauritius</option> <option value="YT">Mayotte</option> <option value="MX">Mexico</option> <option value="FM">Micronesia</option> <option value="MC">Monaco</option> <option value="MN">Mongolia</option> <option value="MS">Montserrat</option> <option value="MA">Morocco</option> <option value="MZ">Mozambique</option> <option value="MM">Myanmar</option> <option value="NA">Nambia</option> <option value="NR">Nauru</option> <option value="NP">Nepal</option> <option value="NL">Netherlands</option> <option value="AN">Netherlands Antilles</option> <option value="NC">New Caledonia</option> <option value="NZ">New Zealand</option> <option value="NI">Nicaragua</option> <option value="NE">Niger</option> <option value="NG">Nigeria</option> <option value="NU">Niue</option> <option value="NF">Norfolk Island</option> <option value="MP">Northern Mariana Islands</option> <option value="NO">Norway</option> <option value="OM">Oman</option> <option value="OT">Others</option> <option value="PK">Pakistan</option> <option value="PW">Palau</option> <option value="PS">Palestinian Territory, Occupied</option> <option value="PA">Panama</option> <option value="PG">Papua New Guinea</option> <option value="PY">Paraguay</option> <option value="PE">Peru</option> <option value="PH">Philippines</option> <option value="PN">Pitcairn</option> <option value="PL">Poland</option> <option value="PT">Portugal</option> <option value="PR">Puerto Rico</option> <option value="QA">Qatar</option> <option value="MD">Republic Of Moldova</option> <option value="RE">Reunion</option> <option value="RO">Romania</option> <option value="RU">Russia</option> <option value="RW">Rwanda</option> <option value="KN">Saint Kitts And Nevis</option> <option value="LC">Saint Lucia</option> <option value="VC">Saint Vincent and The Grenadines</option> <option value="WS">Samoa</option> <option value="SM">San Marino</option> <option value="ST">Sao Tome and Principe</option> <option value="SA">Saudi Arabia</option> <option value="SN">Senegal</option> <option value="SC">Seychelles</option> <option value="SL">Sierra Leone</option> <option value="SG" selected>Singapore</option> <option value="SK">Slovakia</option> <option value="SI">Slovenia</option> <option value="SB">Solomon Islands</option> <option value="SO">Somalia</option> <option value="ZA">South Africa</option> <option value="GS">South Georgia And South Sandwich Islands</option> <option value="ES">Spain</option> <option value="LK">Sri Lanka</option> <option value="SH">St. Helena</option> <option value="PM">St. Pierre and Miquelon</option> <option value="SD">Sudan</option> <option value="SR">Suriname</option> <option value="SJ">Svalbard and Jan Mayen Islands</option> <option value="SZ">Swaziland</option> <option value="SE">Sweden</option> <option value="CH">Switzerland</option> <option value="SY">Syrian Arab Republic</option> <option value="TW">Taiwan</option> <option value="TJ">Tajikistan</option> <option value="TZ">Tanzania</option> <option value="TH">Thailand</option> <option value="TG">TOGO</option> <option value="TK">Tokelau</option> <option value="TO">Tonga</option> <option value="TT">Trinidad and Tobago</option> <option value="TN">Tunisia</option> <option value="TR">Turkey</option> <option value="TM">Turkmenistan</option> <option value="TC">Turks and Caicos Islands</option> <option value="TV">Tuvalu</option> <option value="UG">Uganda</option> <option value="UA">Ukraine</option> <option value="AE">United Arab Emirates</option> <option value="GB">United Kingdom</option> <option value="US">United States</option> <option value="UM">United States Minor Outlying Islands</option> <option value="UY">Uruguay</option> <option value="UZ">Uzbekistan</option> <option value="VU">Vanuatu</option> <option value="VA">Vatican City State (Holy See)</option> <option value="VE">Venezuela</option> <option value="VN">Vietnam</option> <option value="VG">Virgin Islands (British)</option> <option value="VI">Virgin Islands (U.S.)</option> <option value="WF">Wallis and Futuna Islands</option> <option value="EH">Western Sahara</option> <option value="YE">Yemen</option> <option value="YU">Yugoslavia</option> <option value="CD">Zaire</option> <option value="ZM">Zambia</option> <option value="ZW">Zimbabwe</option> </select> </td> </tr> <tr> <td colspan="3" align="right" valign="top" class="text6"><img src="images/spacer.gif" width="10" height="10"></td> </tr> <tr> <td colspan="3" bgcolor="#999999" class="text2">TERMS OF AGREEMENT </td> </tr> <tr> <td colspan="3" align="right" valign="top" class="text6"><img src="images/spacer.gif" width="10" height="10"></td> </tr> <tr> <td align="right" valign="top" class="text6">Rate Agreed : </td> <td> </td> <td><span class="text7"> <input type="text" name="crate" value="<? echo '$client_rate'; ?>"> </span></td> </tr> <tr> <td align="right" class="text6">Warranty Period : </td> <td> </td> <td><span class="text7"> <input type="text" name="cwarranty" value="<? echo '$client_warranty'; ?>"> </span></td> </tr> <tr> <td align="right" valign="top" class="text6">Credit Term : </td> <td> </td> <td><span class="text7"> <input type="text" name="cterm" value="<? echo '$client_terms'; ?>"> </span></td> </tr> <tr> <td align="right" class="text6">Date Signed : </td> <td> </td> <td><span class="text7"> <select name="daysigned"> <option value="<? echo '$day_signed'; ?>"></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="monthsigned"> <option value="<? echo '$month_joined'; ?>"></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> </select> <select name="yearsigned"> <?php for($i=2001; $i<=date("Y"); $i++){ print '<option value="'.$i.'"'; if($yearText == $i){ print ' selected'; } print '>'.$i.'</option>'; } ?> </select> </span></td> </tr> <tr> <td align="right" valign="top" class="text6">Remark :</td> <td> </td> <td><textarea name="cremark" cols="50" rows="5"><? echo '$client_remarks'; ?></textarea></td> </tr> <tr> <td align="right" valign="top" class="text6"> </td>

how to fix this? because i tested the 2 function on 2 separate page 1 page for pagina and 1 page for the drop down they both work but when i combined them i cant make it work need help please! thanks!

i placed this on top of the sql query now $sort = 'ORDER by clientid'; and this is the new error message that i am getting from the drop down menu Notice:undefined index type in c:\hosting\webhost4life\member\diorgrace\admean\client\view.php on line 47>name Notice:undefined index type in c:\hosting\webhost4life\member\diorgrace\admean\client\view.php on line 48>client ID Notice:undefined index type in c:\hosting\webhost4life\member\diorgrace\admean\client\view.php on line 49>red date Notice:undefined index type in c:\hosting\webhost4life\member\diorgrace\admean\client\view.php on line 50>joined date what does this mean? this is the codes for that line <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":"" ?>>reg date</option> <option value="clientmngr.php?id=2&type=4" <?=($_GET['type']==4)?"selected":"" ?>>joined date</option> </select>

sorry,i am lost, can you help me fix it? whats the solution for this? thanks in advance!

hows the solution here? need help thanks!

thats actually the problem that i am seeing the $sort is actually in the middle of the codes <? $type = (!empty($_GET['type']))?$_GET['type']:1; { $order=array(1=>'client_name',2=>'clientid',3=>'staff_created',4=>'staff_created'); if (!empty($type)) $sort="ORDER by '".$order[$type]."'"; } ?> and i dont know how to loop it back to the sql query on top

guys, i need help. i have a page view.php i have a pagina working already before on this page until i placed a drop down menu that will sort the items on the table via name, client id, joined date, reg date, etc i tried the drop down codes without the pagina first and it worked. now when i combined the two functions i am getting some errors. below is the error ============ Notice: Undefined variable: sort in c:\hosting\webhost4life\member\diorgrace\admean\client\view.php on line 10 Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in c:\hosting\webhost4life\member\diorgrace\admean\client\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\admean\client\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\admean\client\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\admean\client\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\admean\client\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\admean\client\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\admean\client\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\admean\client\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\admean\client\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\admean\client\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\admean\client\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\admean\client\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\admean\client\my_pagina_class.php on line 68 ===================================== this is my codes for the drop down menu without the pagina <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="794" 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"> total record found : </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="459"> </td> <td width="158" 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":"" ?>>reg date</option> <option value="clientmngr.php?id=2&type=4" <?=($_GET['type']==4)?"selected":"" ?>>joined date</option> </select> </td> </tr> </table></td> </tr> <tr> <td colspan="6"> </td> </tr> <tr> <td width="58" align="center" bgcolor="#83C2ED" class="text5">ID</td> <td width="215" align="center" valign="top" bgcolor="#83C2ED" class="text5">name</td> <td width="91" align="center" bgcolor="#83C2ED" class="text5">joined date </td> <td width="200" align="center" bgcolor="#83C2ED" class="text5">rate agreed </td> <td width="175" align="center" bgcolor="#83C2ED" class="text5">remark</td> <td width="41" bgcolor="#83C2ED"> </td> </tr> <? $type = (!empty($_GET['type']))?$_GET['type']:1; { $order=array(1=>'client_name',2=>'clientid',3=>'staff_created',4=>'staff_created'); if (!empty($type)) $sort="ORDER by '".$order[$type]."'"; } ?> <? include 'db_connect.php'; $uSql = "SELECT clientid, client_name, day_joined, month_joined, year_joined, client_rate, client_remarks FROM clients ".$sort." ASC"; $uResult = mysql_query($uSql, $connection); if(!$uResult){ echo 'no data found'; } else { while($uRow = mysql_fetch_row($uResult)){ ?> <tr> <td bgcolor="#FFFFCC" class="text8"> C <?= $uRow[0]?></td> <td bgcolor="#FFFFCC" class="text8"> <?= $uRow[1]?></td> <td bgcolor="#FFFFCC" class="text8"> <?= $uRow[2]?> - <?= $uRow[3]?> - <?= $uRow[4]?></td> <td bgcolor="#FFFFCC" class="text8"> <?= $uRow[5]?></td> <td bgcolor="#FFFFCC" class="text8"> <?= $uRow[6]?></td> <td align="center" bgcolor="#FFFFCC"><a href="clientedit.php?$clientid=$clientid" class="link1">edit</a></td> </tr> <? } } ?> <tr> <td colspan="6"> </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> and this is my code for the combined pagina and drop down menu codes <?php session_start(); if (session_is_registered("username")){ include($_SERVER['DOCUMENT_ROOT']."/admean/client/my_pagina_class.php"); $test = new JHpage; $test->sql = "SELECT * FROM clients ".$sort." ASC"; // 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="539"> </td> <td width="239" 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":"" ?>>reg date</option> <option value="clientmngr.php?id=2&type=4" <?=($_GET['type']==4)?"selected":"" ?>>joined date</option> </select> </td> <td width="12" align="right" class="text6"><img src="../images/spacer.gif" width="12" height="10"></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> <? $type = (!empty($_GET['type']))?$_GET['type']:1; { $order=array(1=>'client_name',2=>'clientid',3=>'staff_created',4=>'staff_created'); if (!empty($type)) $sort="ORDER by '".$order[$type]."'"; } ?> <?php for ($i = 0; $i < $num_rows; $i++) { $clientid = mysql_result($result, $i, "clientid"); $client_name = mysql_result($result, $i, "client_name"); $day_joined = mysql_result($result, $i, "day_joined"); $month_joined = mysql_result($result, $i, "month_joined"); $year_joined = mysql_result($result, $i, "year_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 "$day_joined";?> - <? echo "$month_joined";?> - <? echo "$year_joined";?> </td><td bgcolor="#FFFFCC" class="text8"> <? echo "$client_rate";?> </td><td bgcolor="#FFFFCC" class="text8"> <? echo "$client_remarks";?> </td><td align="center" bgcolor="#FFFFCC"><a href="clientedit.php?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> <? }else{ echo "<font face=\"Arial\">You are not authorized to access this page ... Please <a href='../index.php'>Login</a></font>"; } ?> need help please! thanks in advance!

ok. i'll try this one. i'll update then.

so far this is the code that i have done and i am not sure if its working since i dont see any changes in my table need help please! <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="794" 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"> total record found : </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="459"> </td> <td width="158" 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?id=2&type=1">name</option> <option value="clientmngr.php?id=2&type=2">client ID</option> <option value="clientmngr.php?id=2&type=3">reg date</option> </select> </td> </tr> </table></td> </tr> <tr> <td colspan="6"> </td> </tr> <tr> <td width="58" align="center" bgcolor="#83C2ED" class="text5">ID</td> <td width="215" align="center" valign="top" bgcolor="#83C2ED" class="text5">name</td> <td width="91" align="center" bgcolor="#83C2ED" class="text5">joined date </td> <td width="200" align="center" bgcolor="#83C2ED" class="text5">rate agreed </td> <td width="175" align="center" bgcolor="#83C2ED" class="text5">remark</td> <td width="41" bgcolor="#83C2ED"> </td> </tr> <? $type = $_GET['type']; { $order = 'client_name'; if ($type=='1') {$order = 'client_name';} if ($type=='2') {$order = 'clientid';} if ($type=='3') {$order = 'staff_created';} } ?> <? include 'db_connect.php'; $order = '$order'; $uSql = "SELECT clientid, client_name, day_joined, month_joined, year_joined, client_rate, client_remarks FROM clients ORDER by '$order' DESC"; $uResult = mysql_query($uSql, $connection); if(!$uResult){ echo 'no data found'; } else{ while($uRow = mysql_fetch_row($uResult)){ ?> <tr> <td bgcolor="#FFFFCC" class="text8"> C <?= $uRow[0]?></td> <td bgcolor="#FFFFCC" class="text8"> <?= $uRow[1]?></td> <td bgcolor="#FFFFCC" class="text8"> <?= $uRow[2]?> - <?= $uRow[3]?> - <?= $uRow[4]?></td> <td bgcolor="#FFFFCC" class="text8"> <?= $uRow[5]?></td> <td bgcolor="#FFFFCC" class="text8"> <?= $uRow[6]?></td> <td align="center" bgcolor="#FFFFCC"><a href="clientedit.php?$clientid=$clientid" class="link1">edit</a></td> </tr> <? } } ?> <tr> <td colspan="6"> </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> thanks!

guys, i need help, i have a table that lists all items in my database and i have a drop down menu that should change the order of the list via name clientID date staff my problem now is, i dont know how to do it. the only thing that i have done so far is the generate data from the database below is my codes for this page. <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="794" 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"> total record found : </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="459"> </td> <td width="158" class="text6">sort by : <select name="select"> <option value="1">name</option> <option value="2">client ID</option> <option value="3">reg date</option> </select> </td> </tr> </table></td> </tr> <tr> <td colspan="6"> </td> </tr> <tr> <td width="58" align="center" bgcolor="#83C2ED" class="text5">ID</td> <td width="215" align="center" valign="top" bgcolor="#83C2ED" class="text5">name</td> <td width="91" align="center" bgcolor="#83C2ED" class="text5">joined date </td> <td width="200" align="center" bgcolor="#83C2ED" class="text5">rate agreed </td> <td width="175" align="center" bgcolor="#83C2ED" class="text5">remark</td> <td width="41" bgcolor="#83C2ED"> </td> </tr> <? include 'db_connect.php'; $uSql = "SELECT clientid, client_name, day_joined, month_joined, year_joined, client_rate, client_remarks FROM clients ORDER by client_name DESC"; $uResult = mysql_query($uSql, $connection); if(!$uResult){ echo 'no data found'; } else{ while($uRow = mysql_fetch_row($uResult)){ ?> <tr> <td bgcolor="#FFFFCC" class="text8"> C <?= $uRow[0]?></td> <td bgcolor="#FFFFCC" class="text8"> <?= $uRow[1]?></td> <td bgcolor="#FFFFCC" class="text8"> <?= $uRow[2]?> - <?= $uRow[3]?> - <?= $uRow[4]?></td> <td bgcolor="#FFFFCC" class="text8"> <?= $uRow[5]?></td> <td bgcolor="#FFFFCC" class="text8"> <?= $uRow[6]?></td> <td align="center" bgcolor="#FFFFCC"><a href="clientedit.php?$clientid=$clientid" class="link1">edit</a></td> </tr> <? } } ?> <tr> <td colspan="6"> </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> hope you could give me the codes that would do that kind of function. thanks!

hi, thanks! its working now

i am getting a new error now --------- Warning: main(../db_connect.php): failed to open stream: No such file or directory in c:\hosting\webhost4life\member\diorgrace\admean\addclient.php on line 2 Warning: main(): Failed opening '../db_connect.php' for inclusion (include_path='.;c:\php\pear') in c:\hosting\webhost4life\member\diorgrace\admean\addclient.php on line 2 Warning: mysql_query(): Access denied for user 'ODBC'@'localhost' (using password: NO) in c:\hosting\webhost4life\member\diorgrace\admean\addclient.php on line 44 Warning: mysql_query(): A link to the server could not be established in c:\hosting\webhost4life\member\diorgrace\admean\addclient.php on line 44 Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in c:\hosting\webhost4life\member\diorgrace\admean\addclient.php on line 45 Warning: mysql_query(): Access denied for user 'ODBC'@'localhost' (using password: NO) in c:\hosting\webhost4life\member\diorgrace\admean\addclient.php on line 53 Warning: mysql_query(): A link to the server could not be established in c:\hosting\webhost4life\member\diorgrace\admean\addclient.php on line 53 Access denied for user 'ODBC'@'localhost' (using password: NO) ------------ what seems to be the problem here?

this is the error that i am getting now after changing the "target" to "action" 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 'client_warranty, client_term, day_signed, month_signed, year_sig also this is the code for my addclient.php <? include '../db_connect.php'; $dayjoined = $_POST['dayjoined']; $monthjoined = $_POST['monthjoined']; $yearjoined = $_POST['yearjoined']; $cname = $_POST['cname']; $cadd = $_POST['cadd']; $cphone = $_POST['cphone']; $cfax = $_POST['cfax']; $cwebsite = $_POST['cwebsite']; $ccountry = $_POST['ccountry']; $crate = $_POST['crate']; $cwarranty = $_POST['cwarranty']; $cterm = $_POST['cterm']; $daysigned = $_POST['daysigned']; $monthsigned = $_POST['monthsigned']; $yearsigned = $_POST['yearsigned']; $cremark = $_POST['cremark']; $username = $_POST['username']; $dayjoined = stripslashes($dayjoined); $monthjoined = stripslashes($monthjoined); $yearjoined = stripslashes($yearjoined); $cname = stripslashes($cname); $cadd = stripslashes($cadd); $cphone = stripslashes($cphone); $cfax = stripslashes($cfax); $cwebsite = stripslashes($cwebsite); $ccountry = stripslashes($ccountry); $crate = stripslashes($crate); $cwarranty = stripslashes($cwarranty); $cterm = stripslashes($cterm); $daysigned = stripslashes($daysigned); $monthsigned = stripslashes($monthsigned); $yearsigned = stripslashes($yearsigned); $cremark = stripslashes($cremark); $username = stripslashes($username); // --- for the company logo //if ($clientImage == '$EventImage') {$clientImageLink = '2';} // else {$clientImageLink = '1';} $sql_cname_check = mysql_query("SELECT client_name FROM clients WHERE client_name='$cname'"); $cname_check = mysql_num_rows($sql_cname_check); if($cname_check > 0){ echo '<script language=javascript> alert("Client name already exist!");top.location = "clientmngr.php?id=1";</script>'; unset($cname); exit(); } $sql = mysql_query("INSERT INTO clients (day_joined, month_joined, year_joined, client_name, client_add, client_phone, client_fax, client_site, client_country, client_rate, ,client_warranty, client_term, day_signed, month_signed, year_signed, client_remarks, staff_created ) VALUES('$dayjoined', '$monthjoined', '$yearjoined', '$cname', '$cadd', '$cphone', '$cfax', '$cwebsite', '$ccountry', '$crate', '$cwarranty', '$cterm', '$daysigned', '$monthsigned', '$yearsigned', '$cremark', '$username')") or die (mysql_error()); if(!$sql){ echo '<script language=javascript> alert("Error adding client");top.location = "clientmngr.php?id=1";</script>'; exit(); } else { $clientid = mysql_insert_id(); echo '<script language=javascript> alert("New client has been added by '.$username.';!");top.location = "clientmngr.php?id=2";</script>'; } ?>

this is the error that i am getting now after changing the "target" to "action" 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 'client_warranty, client_term, day_signed, month_signed, year_sig also this is the code for my addclient.php <? include '../db_connect.php'; $dayjoined = $_POST['dayjoined']; $monthjoined = $_POST['monthjoined']; $yearjoined = $_POST['yearjoined']; $cname = $_POST['cname']; $cadd = $_POST['cadd']; $cphone = $_POST['cphone']; $cfax = $_POST['cfax']; $cwebsite = $_POST['cwebsite']; $ccountry = $_POST['ccountry']; $crate = $_POST['crate']; $cwarranty = $_POST['cwarranty']; $cterm = $_POST['cterm']; $daysigned = $_POST['daysigned']; $monthsigned = $_POST['monthsigned']; $yearsigned = $_POST['yearsigned']; $cremark = $_POST['cremark']; $username = $_POST['username']; $dayjoined = stripslashes($dayjoined); $monthjoined = stripslashes($monthjoined); $yearjoined = stripslashes($yearjoined); $cname = stripslashes($cname); $cadd = stripslashes($cadd); $cphone = stripslashes($cphone); $cfax = stripslashes($cfax); $cwebsite = stripslashes($cwebsite); $ccountry = stripslashes($ccountry); $crate = stripslashes($crate); $cwarranty = stripslashes($cwarranty); $cterm = stripslashes($cterm); $daysigned = stripslashes($daysigned); $monthsigned = stripslashes($monthsigned); $yearsigned = stripslashes($yearsigned); $cremark = stripslashes($cremark); $username = stripslashes($username); // --- for the company logo //if ($clientImage == '$EventImage') {$clientImageLink = '2';} // else {$clientImageLink = '1';} $sql_cname_check = mysql_query("SELECT client_name FROM clients WHERE client_name='$cname'"); $cname_check = mysql_num_rows($sql_cname_check); if($cname_check > 0){ echo '<script language=javascript> alert("Client name already exist!");top.location = "clientmngr.php?id=1";</script>'; unset($cname); exit(); } $sql = mysql_query("INSERT INTO clients (day_joined, month_joined, year_joined, client_name, client_add, client_phone, client_fax, client_site, client_country, client_rate, ,client_warranty, client_term, day_signed, month_signed, year_signed, client_remarks, staff_created ) VALUES('$dayjoined', '$monthjoined', '$yearjoined', '$cname', '$cadd', '$cphone', '$cfax', '$cwebsite', '$ccountry', '$crate', '$cwarranty', '$cterm', '$daysigned', '$monthsigned', '$yearsigned', '$cremark', '$username')") or die (mysql_error()); if(!$sql){ echo '<script language=javascript> alert("Error adding client");top.location = "clientmngr.php?id=1";</script>'; exit(); } else { $clientid = mysql_insert_id(); echo '<script language=javascript> alert("New client has been added by '.$username.';!");top.location = "clientmngr.php?id=2";</script>'; } ?>

hi, my problem is also related to this. how about in the case of the days? let say the user selected Jan the day has to change in related to the number of days that jan have what is the code for this? thanks!

guys, i need help, i have 2 page add.php and addclient.php my problem is, i cant make insert new data to the database and when i click on the save button its opening a new window of the same page need help please this is the link http://www.jobhirings.com/admean/clientmngr.php?id=1 and this is the code for my add.php <form target="addclient.php" method="post" id="add" name="add" 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="515" border="0" cellspacing="5" cellpadding="3"> <tr> <td colspan="3" valign="top"><img src="images/spacer.gif" width="10" height="8"></td> </tr> <tr> <td colspan="3" bgcolor="#999999" class="text2">CLIENT INFORMATION </td> </tr> <tr> <td colspan="3" valign="top"><img src="images/spacer.gif" width="10" height="10"></td> </tr> <tr> <td width="137" align="right" valign="top" class="text6">Date Joined : </td> <td> </td> <td class="text7"><select name="dayjoined"> <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="monthjoined"> <OPTION value='01'>Jan</option> <OPTION value='02'>Feb</option> <OPTION value='03'>Mar</option> <OPTION value='04'>Apr</option> <OPTION value='05'>May</option> <OPTION value='06'>Jun</option> <OPTION value='07'>Jul</option> <OPTION value='08'>Aug</option> <OPTION value='09'>Sep</option> <OPTION value='10'>Oct</option> <OPTION value='11'>Nov</option> <OPTION value='12'>Dec</option> </select> <select name="yearjoined"> <OPTION value='2007'>2009</OPTION> <OPTION value='2007'>2008</OPTION> <OPTION value='2007'>2007</OPTION> <OPTION value='2006'>2006</OPTION> <OPTION value='2005'>2005</OPTION> <OPTION value='2004'>2004</OPTION> <OPTION value='2003'>2003</OPTION> <OPTION value='2002'>2002</OPTION> <OPTION value='2001'>2001</OPTION> <OPTION value='2000'>2000</OPTION> </select></td> </tr> <tr> <td align="right" valign="top" class="text6">Company Name: </td> <td width="7" rowspan="2"> </td> <td width="363"><span class="text7"> <input name="cname" type="text" size="50"> </span></td> </tr> <tr> <td align="right" valign="top" class="text6">Address : </td> <td width="363"><textarea name="cadd" cols="50" rows="5"></textarea></td> </tr> <tr> <td align="right" valign="top" class="text6">Telephone No : </td> <td> </td> <td><span class="text7"> <input type="text" name="cphone"> </span></td> </tr> <tr> <td align="right" valign="top" class="text6">Fax : </td> <td> </td> <td><span class="text7"> <input type="text" name="cfax"> </span></td> </tr> <tr> <td align="right" valign="top" class="text6">Website : </td> <td> </td> <td><span class="text7"> <input type="text" name="cwebsite"> </span></td> </tr> <tr> <td align="right"><span class="text6">Country : </span></td> <td> </td> <td><select name="ccountry"> <option value="AF">Afghanistan</option> <option value="AL">Albania</option> <option value="DZ">Algeria</option> <option value="AS">American Samoa</option> <option value="AD">Andorra</option> <option value="AO">Angola</option> <option value="AI">Anguilla</option> <option value="AQ">Antarctica</option> <option value="AG">Antigua and Barbuda</option> <option value="AR">Argentina</option> <option value="AM">Armenia</option> <option value="AW">Aruba</option> <option value="AU">Australia</option> <option value="AT">Austria</option> <option value="AZ">Azerbaijan</option> <option value="BS">Bahamas</option> <option value="BH">Bahrain</option> <option value="BD">Bangladesh</option> <option value="BB">Barbados</option> <option value="BY">Belarus</option> <option value="BE">Belgium</option> <option value="BZ">Belize</option> <option value="BJ">Benin</option> <option value="BM">Bermuda</option> <option value="BT">Bhutan</option> <option value="BO">Bolivia</option> <option value="BA">Bosnia Hercegovina</option> <option value="BW">Botswana</option> <option value="BV">Bouvet Island</option> <option value="BR">Brazil</option> <option value="IO">British Indian Ocean Territory</option> <option value="BN">Brunei Darussalam</option> <option value="BG">Bulgaria</option> <option value="BF">Burkina Faso</option> <option value="BI">Burundi</option> <option value="KH">Cambodia</option> <option value="CM">Cameroon</option> <option value="CA">Canada</option> <option value="CV">Cape Verde</option> <option value="KY">Cayman Islands</option> <option value="CF">Central African Republic</option> <option value="TD">Chad</option> <option value="CL">Chile</option> <option value="CN">China</option> <option value="CX">Christmas Island</option> <option value="CC">Cocos (Keeling) Islands</option> <option value="CO">Colombia</option> <option value="KM">Comoros</option> <option value="CG">Congo</option> <option value="CK">Cook Islands</option> <option value="CR">Costa Rica</option> <option value="CI">Cote D'ivoire</option> <option value="HR">Croatia</option> <option value="CU">Cuba</option> <option value="CY">Cyprus</option> <option value="CZ">Czech Republic</option> <option value="DK">Denmark</option> <option value="DJ">Djibouti</option> <option value="DM">Dominica</option> <option value="DO">Dominican Republic</option> <option value="TP">East Timor</option> <option value="EC">Ecuador</option> <option value="EG">Egypt</option> <option value="SV">EL Salvador</option> <option value="GQ">Equatorial Guinea</option> <option value="ER">Eritrea</option> <option value="EE">Estonia</option> <option value="ET">Ethiopia</option> <option value="FK">Falkland Islands (Malvinas)</option> <option value="FO">Faroe Islands</option> <option value="FJ">Fiji</option> <option value="FI">Finland</option> <option value="FR">France</option> <option value="GF">French Guiana</option> <option value="PF">French Polynesia</option> <option value="TF">French Southern Territories</option> <option value="GA">Gabon</option> <option value="GM">Gambia</option> <option value="GE">Georgia</option> <option value="DE">Germany</option> <option value="GH">Ghana</option> <option value="GI">Gibraltar</option> <option value="GR">Greece</option> <option value="GL">Greenland</option> <option value="GD">Grenada</option> <option value="GP">Guadeloupe</option> <option value="GU">Guam</option> <option value="GT">Guatemala</option> <option value="GN">Guinea</option> <option value="GW">Guinea-Bissau</option> <option value="GY">Guyana</option> <option value="HT">Haiti</option> <option value="HM">Heard and Mc Donald Islands</option> <option value="HN">Honduras</option> <option value="HK">Hong Kong</option> <option value="HU">Hungary</option> <option value="IS">Iceland</option> <option value="IN">India</option> <option value="ID">Indonesia</option> <option value="IR">Iran</option> <option value="IQ">Iraq</option> <option value="IE">Ireland</option> <option value="IL">Israel</option> <option value="IT">Italy</option> <option value="JM">Jamaica</option> <option value="JP">Japan</option> <option value="JO">Jordan</option> <option value="KZ">Kazakhstan</option> <option value="KE">Kenya</option> <option value="KI">Kiribati</option> <option value="KP">Korea (North)</option> <option value="KR">Korea (South)</option> <option value="KW">Kuwait</option> <option value="KG">Kyrgyzstan</option> <option value="LA">Laos</option> <option value="LV">Latvia</option> <option value="LB">Lebanon</option> <option value="LS">Lesotho</option> <option value="LR">Liberia</option> <option value="LY">Libyan Arab Jamahiriya</option> <option value="LI">Liechtenstein</option> <option value="LT">Lithuania</option> <option value="LU">Luxembourg</option> <option value="MO">Macau</option> <option value="MK">Macedonia</option> <option value="MG">Madagascar</option> <option value="MW">Malawi</option> <option value="MY">Malaysia</option> <option value="MV">Maldives</option> <option value="ML">Mali</option> <option value="MT">Malta</option> <option value="MH">Marshall Islands</option> <option value="MQ">Martinique</option> <option value="MR">Mauritania</option> <option value="MU">Mauritius</option> <option value="YT">Mayotte</option> <option value="MX">Mexico</option> <option value="FM">Micronesia</option> <option value="MC">Monaco</option> <option value="MN">Mongolia</option> <option value="MS">Montserrat</option> <option value="MA">Morocco</option> <option value="MZ">Mozambique</option> <option value="MM">Myanmar</option> <option value="NA">Nambia</option> <option value="NR">Nauru</option> <option value="NP">Nepal</option> <option value="NL">Netherlands</option> <option value="AN">Netherlands Antilles</option> <option value="NC">New Caledonia</option> <option value="NZ">New Zealand</option> <option value="NI">Nicaragua</option> <option value="NE">Niger</option> <option value="NG">Nigeria</option> <option value="NU">Niue</option> <option value="NF">Norfolk Island</option> <option value="MP">Northern Mariana Islands</option> <option value="NO">Norway</option> <option value="OM">Oman</option> <option value="OT">Others</option> <option value="PK">Pakistan</option> <option value="PW">Palau</option> <option value="PS">Palestinian Territory, Occupied</option> <option value="PA">Panama</option> <option value="PG">Papua New Guinea</option> <option value="PY">Paraguay</option> <option value="PE">Peru</option> <option value="PH">Philippines</option> <option value="PN">Pitcairn</option> <option value="PL">Poland</option> <option value="PT">Portugal</option> <option value="PR">Puerto Rico</option> <option value="QA">Qatar</option> <option value="MD">Republic Of Moldova</option> <option value="RE">Reunion</option> <option value="RO">Romania</option> <option value="RU">Russia</option> <option value="RW">Rwanda</option> <option value="KN">Saint Kitts And Nevis</option> <option value="LC">Saint Lucia</option> <option value="VC">Saint Vincent and The Grenadines</option> <option value="WS">Samoa</option> <option value="SM">San Marino</option> <option value="ST">Sao Tome and Principe</option> <option value="SA">Saudi Arabia</option> <option value="SN">Senegal</option> <option value="SC">Seychelles</option> <option value="SL">Sierra Leone</option> <option value="SG" selected>Singapore</option> <option value="SK">Slovakia</option> <option value="SI">Slovenia</option> <option value="SB">Solomon Islands</option> <option value="SO">Somalia</option> <option value="ZA">South Africa</option> <option value="GS">South Georgia And South Sandwich Islands</option> <option value="ES">Spain</option> <option value="LK">Sri Lanka</option> <option value="SH">St. Helena</option> <option value="PM">St. Pierre and Miquelon</option> <option value="SD">Sudan</option> <option value="SR">Suriname</option> <option value="SJ">Svalbard and Jan Mayen Islands</option> <option value="SZ">Swaziland</option> <option value="SE">Sweden</option> <option value="CH">Switzerland</option> <option value="SY">Syrian Arab Republic</option> <option value="TW">Taiwan</option> <option value="TJ">Tajikistan</option> <option value="TZ">Tanzania</option> <option value="TH">Thailand</option> <option value="TG">TOGO</option> <option value="TK">Tokelau</option> <option value="TO">Tonga</option> <option value="TT">Trinidad and Tobago</option> <option value="TN">Tunisia</option> <option value="TR">Turkey</option> <option value="TM">Turkmenistan</option> <option value="TC">Turks and Caicos Islands</option> <option value="TV">Tuvalu</option> <option value="UG">Uganda</option> <option value="UA">Ukraine</option> <option value="AE">United Arab Emirates</option> <option value="GB">United Kingdom</option> <option value="US">United States</option> <option value="UM">United States Minor Outlying Islands</option> <option value="UY">Uruguay</option> <option value="UZ">Uzbekistan</option> <option value="VU">Vanuatu</option> <option value="VA">Vatican City State (Holy See)</option> <option value="VE">Venezuela</option> <option value="VN">Vietnam</option> <option value="VG">Virgin Islands (British)</option> <option value="VI">Virgin Islands (U.S.)</option> <option value="WF">Wallis and Futuna Islands</option> <option value="EH">Western Sahara</option> <option value="YE">Yemen</option> <option value="YU">Yugoslavia</option> <option value="CD">Zaire</option> <option value="ZM">Zambia</option> <option value="ZW">Zimbabwe</option> </select> </td> </tr> <tr> <td colspan="3" align="right" valign="top" class="text6"><img src="images/spacer.gif" width="10" height="10"></td> </tr> <tr> <td colspan="3" bgcolor="#999999" class="text2">TERMS OF AGREEMENT </td> </tr> <tr> <td colspan="3" align="right" valign="top" class="text6"><img src="images/spacer.gif" width="10" height="10"></td> </tr> <tr> <td align="right" valign="top" class="text6">Rate Agreed : </td> <td> </td> <td><span class="text7"> <input type="text" name="crate"> </span></td> </tr> <tr> <td align="right" class="text6">Warranty Period : </td> <td> </td> <td><span class="text7"> <input type="text" name="cwarranty"> </span></td> </tr> <tr> <td align="right" valign="top" class="text6">Credit Term : </td> <td> </td> <td><span class="text7"> <input type="text" name="cterm"> </span></td> </tr> <tr> <td align="right" class="text6">Date Signed : </td> <td> </td> <td><span class="text7"> <select name="daysigned"> <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="monthsigned"> <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> </select> <select name="yearsigned"> <option value='2007'>2009</option> <option value='2007'>2008</option> <option value='2007'>2007</option> <option value='2006'>2006</option> <option value='2005'>2005</option> <option value='2004'>2004</option> <option value='2003'>2003</option> <option value='2002'>2002</option> <option value='2001'>2001</option> <option value='2000'>2000</option> </select> </span></td> </tr> <tr> <td align="right" valign="top" class="text6">Remark :</td> <td> </td> <td><textarea name="cremark" cols="50" rows="5"></textarea></td> </tr> <tr> <td align="right" valign="top" class="text6">&nbsp

sorry bro, i'm totally lost and dont know where and how to start. hope you could help me with this. thanks in advance!

hi, i dont understand and how to place this in my page. im still in the process of learning. this is the codes for my page <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="620" 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"> <? $sql = mysql_query("SELECT * FROM 'clients' "); $num = mysql_num_rows($sql); ?> total record found : <?= $uRow[0]?> </td> <td width="287"> </td> </tr> </table></td> </tr> <tr> <td colspan="6"><table width="617" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="459"> </td> <td width="158" class="text6">sort by : <? $display_order = $_POST['select']; $order_type = "ASC"; $sql = mysql_query("SELECT * FROM `table` WHERE `var`='value' ORDER BY ".$display_order." ".$order_type.""); ?> <select name="select"> <option value="1">name</option> <option value="2">client ID</option> <option value="3">reg date</option> </select> </td> </tr> </table></td> </tr> <tr> <td colspan="6"> </td> </tr> <tr> <td width="52" align="center" bgcolor="#83C2ED" class="text5">ID</td> <td width="160" align="center" valign="top" bgcolor="#83C2ED" class="text5">name</td> <td width="69" align="center" bgcolor="#83C2ED" class="text5">joined date </td> <td width="153" align="center" bgcolor="#83C2ED" class="text5">rate agreed </td> <td width="133" align="center" bgcolor="#83C2ED" class="text5">remark</td> <td width="39" bgcolor="#83C2ED"> </td> </tr> <? include 'db_connect.php'; $uSql = "SELECT clientid, client_name, day_joined, month_joined, year_joined, client_rate, client_remarks FROM clients ORDER by client_name DESC"; $uResult = mysql_query($uSql, $connection); if(!$uResult){ echo 'no data found'; } else{ while($uRow = mysql_fetch_row($uResult)){ ?> <tr> <td bgcolor="#FFFFCC" class="text8"> C <?= $uRow[0]?></td> <td bgcolor="#FFFFCC" class="text8"> <?= $uRow[1]?></td> <td bgcolor="#FFFFCC" class="text8"> <?= $uRow[2]?> - <?= $uRow[3]?> - <?= $uRow[4]?></td> <td bgcolor="#FFFFCC" class="text8"> <?= $uRow[5]?></td> <td bgcolor="#FFFFCC" class="text8"> <?= $uRow[6]?></td> <td align="center" bgcolor="#FFFFCC"><a href="clientedit.php?$clientid=$clientid" class="link1">edit</a></td> </tr> <? } } ?> <tr> <td colspan="6"> </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> i placed the code that you gave me but i'm not sure if this is correct since its still not working. thanks in advance!