Jeannie109

I am a complete Newbie and I am trying to create a simple job board on my website and I have successfully been able to post data to the database, but I can't get it to display on the web page. The connection to the database is working but the content is not displaying on the web page. It will bring up the table with the entries and will increase the size of the table when I enter another post, but the information itself is not displaying. I can even do a search on my search page and an entry appears, but the actual information is still blank. This was working very nicely with the old table just before I deleted the orginal table and added this new one to change all the fields, so I know the query worked at that time. I had to change the fields and deleted the old table and have just changed the field names in the php file. I feel I am so close since the database in phpMyadmin updates nicely with all the fields, but I am just so new at this I am not sure what to look for in the php SQL query. http://www.bernardtransportation.com/jobboard/jobs.php and I am using MySQL 3.23, 4.0, 4.1, phpMyAdmin, and PHP 5.x, all through GoDaddy hosting. MySQL 3.23, 4.0, 4.1 //EXECUTE OUR SQL STRING FOR THE TABLE RECORDS $result = mysql_query($sql,db() ); if ($sql_debug_mode==1) { echo "<BR>SQL: $sql<BR>"; } if ($myrowsel = mysql_fetch_array($result)) { $id = $myrowsel["id"]; echo " <font size=-2>V=View E=Edit I do not get an error message, but the database does update in phpmyadmin and the web page shows another entry added, but the information does not display. Thank you so much in advance. I have spent many hours searching the internet for answers and posted to every forum I can find. I would greatly appreciate any help at all. [attachment deleted by admin]

Hi Blade, Thank you so much for the suggestion. Now, at least I can see what the problem is, but unfortunately, I do not know how to fix it. This is the error for the "V" View link: Editing Record VED Unknown column 'id' in 'where clause' I am not sure how to fix that. Do I add another field called ID into my Loads table in the database? Also, here is the error message if you click on "V" or View on the main jobs.php Viewing Record Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/content/b/t/g/btginc/html/jobboard/jobs.php on line 921 And, here is the error for the "D" or Delete link from jobs.php Once the box appears and you click on YES: Deleting Record Error Deleting Record (9995SQL) Jeannie

Here is the URL: http://bernardtransportation.com/jobboard/jobs.php?posting=yes& I had this site on IX Webhosting before and it worked perfectly. Now, I just transfered everything to GoDaddy for webhosting and it is failing. Adding a new record is no problem, so it is finding the database table and data just fine. Here is the error code: Editing Record V E D Error Retrieving Records (9993SQLGET) The whole process runs on the single page, job.php, but this is the code referencing the View Edit Delete portion of the page. if ($post == "") { //THEN WE ARE EDITING A RECORD echo "<table border=1 width=400 align=center><tr><td><DIV CLASS='PAGE_STATUS'>Editing Record</DIV>"; ?> <TABLE width=450 align=center><tr><td><DIV CLASS='PAGE_OPTIONS'> <?php if ($allowview == "yes") { ?><a href="<?php echo $thispage; ?>?id=<?php echo $id; ?>&proc=View&<?php echo $pagevars; ?>">V</a> <?php } //END ALLOWVIEW ?><?php if ($allowedit == "yes") { ?> <a href="<?php echo $thispage; ?>?id=<?php echo $id; ?>&proc=Edit&<?php echo $pagevars; ?>">E</a> <?php } //END ALLOWEDIT ?><?php if ($allowdelete == "yes") { ?> <a href="<?php echo $thispage; ?>?id=<?php echo $id; ?>&proc=Delete&<?php echo $pagevars; ?>">D</a> <?php } //END ALLOWDELETE ?></font><font face="arial" size="2"> </DIV></td> </tr> </table> <? /*-- SECTION: 9993SQLGET --*/ $sql = "SELECT * FROM loads WHERE (id = '$id') $addl_select_crit "; if ($sql_debug_mode==1) { echo "<BR>SQL: $sql<BR>"; } $result = mysql_query($sql,db() ) or die ("Error Retrieving Records (9993SQLGET)"); if ($myrow = mysql_fetch_array($result)) { do {

I am using some script to create a Job List. It works well to Add a new job and List all the jobs and the Search feature works also. But, I can't get the Edit, View and Delete feature to work on this page: http://bernardtransportation.com/jobboard/jobs.php?posting=yes& Everything used to work but now I am getting error messages. Can someone please help? Thank you so much.

Barry, Thank you so much for writing back. I appreciate your trying to help with the code. However, I already have the capability to View Edit and Delete. What I need is the code for one of the Options to be [b]Complete[/b] or [b]Done[/b], INSTEAD of Delete, and for the items once completed to be posted to a new page, complete.php. Is that something that is feasible? Again, thank you so much for offering to help. Jeannie

[!--quoteo(post=379935:date=Jun 4 2006, 08:21 AM:name=homchz)--][div class=\'quotetop\']QUOTE(homchz @ Jun 4 2006, 08:21 AM) [snapback]379935[/snapback][/div][div class=\'quotemain\'][!--quotec--] Do you have any of the code behind what's allready there? [/quote] All the code is on the one page: [code]<?php echo "<LINK rel='stylesheet' type='text/css' href='style.css' >"; /*------------------------------------------------ THE FOLLOWING ALLOWS GLOBALS = OFF SUPPORT ------------------------------------------------*/ // $_GET VARIABLES foreach($_GET as $a=>$b){$$a=$b;} // $_POST VARIABLES foreach($_POST as $a=>$b){$$a=$b;} /*------------------------------------------------ END GLOBALS OFF SUPPORT ------------------------------------------------*/ echo "<Font Face='verdana' size='2'>"; /*--------------------------------------------------------------------------------- TURN DEBUG ON - THIS ALLOWS YOU TO VIEW ALL SQL STATEMENTS AS THEY ARE EXECUTED $sql_debug_mode=0 --> OFF (NO SQL STATEMENTS WILL BE SHOWN) $sql_debug_mode=1 --> ON (SQL STATEMENTS WILL BE SHOWN) ---------------------------------------------------------------------------------*/ $sql_debug_mode=0; /*--------------------------------------------------------------------------------- ERROR REPORTING: TO VIEW ALL ERRORS SET error_reporting TO E_ALL OTHER ERROR REPORTING OPTIONS (FROM THE PHP.INI FILE): ; error_reporting is a bit-field. Or each number up to get desired error ; reporting level ; E_ALL - All errors and warnings ; E_ERROR - fatal run-time errors ; E_WARNING - run-time warnings (non-fatal errors) ; E_PARSE - compile-time parse errors ; E_NOTICE - run-time notices (these are warnings which often result ; from a bug in your code, but it's possible that it was ; intentional (e.g., using an uninitialized variable and ; relying on the fact it's automatically initialized to an ; empty string) ; E_CORE_ERROR - fatal errors that occur during PHP's initial startup ; E_CORE_WARNING - warnings (non-fatal errors) that occur during PHP's ; initial startup ; E_COMPILE_ERROR - fatal compile-time errors ; E_COMPILE_WARNING - compile-time warnings (non-fatal errors) ; E_USER_ERROR - user-generated error message ; E_USER_WARNING - user-generated warning message ; E_USER_NOTICE - user-generated notice message ; ; Examples: ; ; - Show all errors, except for notices ; ;error_reporting = E_ALL & ~E_NOTICE ; ; - Show only errors ; ;error_reporting = E_COMPILE_ERROR|E_ERROR|E_CORE_ERROR ; ; - Show all errors except for notices ; error_reporting = E_PARSE|E_ERROR|E_WARNING|E_NOTICE; display all errors, warnings and notices ---------------------------------------------------------------------------------*/ error_reporting(E_WARNING|E_PARSE); //SET THESE VARIABLES TO CUSTOMIZE YOUR PAGE $thispage = $SCRIPT_NAME; //SET THIS TO THE NAME OF THIS FILE $pagevars = ""; //INSERT ANY "GET" VARIABLES HERE... /*---------------------------------------------------------------------- NOTE: THE FOLLOWING 4 "allow" VARIABLES SIMPLY DISABLE THE LINKS FOR ADD/EDIT/VIEW/DELETE. ----------------------------------------------------------------------*/ $allowedit = "yes"; //SET TO "no" IF YOU WANT TO DISABLE EDITING $allowaddnew = "yes"; // SET TO "no" IF YOU WANT TO DISABLE NEW RECORDS $allowview = "yes"; //SET TO "no" IF YOU WANT TO DISABLE VIEWING RECORDS $allowdelete = "yes"; //SET TO "no" IF YOU WANT TO DISABLE DELETING RECORDS /*---------------------------------------------------------------------- * SEARCH SECTIONS BY CODE-NUMBER (LISTED BELOW). (7/7/02): THIS CAN BE VERY USEFUL WHEN IDENTIFYING SECTIONS YOU WISH TO EDIT. USE THE FOLLOWING CODES IN YOUR SEARCH (TYPICALLY, USE CTRL + F): 9991 - SEARCH SECTION (INCLUDES SEARCH FORM AND SEARCH RESULTS) |_ 9991SQL - SQL STATEMENT FOR SEARCH RESULTS |_ 9991FORM - FORM USED FOR POSTING SEARCHES 9992 - VIEW RECORD SECTION (VIEWING SINGLE-RECORD) |_ 9992SQL - SQL STATEMENT FOR OBTAINING SINGLE-RECORD 9993 - EDIT RECORD SECTION (FORM USED FOR EDITING AND POST RESULTS) |_ 9993SQLGET - SQL STATEMENT USED FOR OBTAINING EDIT RECORD |_ 9993SQLUPD - SQL STATEMENT USED FOR UPDATING POSTED RECORD |_ 9993SQLFORM - USER INPUT FORM FOR EDITING RECORD 9994 - ADD RECORD SECTION |_ 9994SQL - SQL STATEMENT USED TO INSERT A RECORD |_ 9994FORM - FORM USED TO CREATE NEW RECORDS 9995 - DELETE RECORD SECTION |_ 9995SQL - SQL STATEMENT USED TO DELETE A RECORD |_ 9995CONFIRM = CONFIRMATION TO DELETE RECORD * GLOBALLY APPEND CRITERIA TO YOUR SQL STATEMENTS USING THE $addl_select AND $addl_insert VARIABLES BELOW. (7/7/02): USEFUL FOR SPECIFYING USERNAMES, OR OTHER RECORD-LIMITING CRITERIA. * THE $addl_select_crit WILL BE APPENDED TO ALL SEL/UPD/DEL STATEMENTS, AS "WHERE" CRITERIA, BEFORE ANY ORDER/LIMIT STATEMENTS ARE APPLIED. EXAMPLE: $addl_select_crit (NOTE! YOU MUST INCLUDE 'AND') $addl_select_crit = "AND (userid='$someusersid' AND create_date='2002-07-07')"; * THE $addl_insert_crit AND $addl_insert_values VARIABLES WILL BE APPENDED TO ALL INSERT STATEMENTS. EXAMPLE: $addl_insert_crit (NOTE! YOU MUST INCLUDE A COMMA (,) BETWEEN FIELDS AND VALUES) $addl_insert_crit = ",userid, create_date"; EXAMPLE: $addl_insert_values (NOTE! YOU MUST INCLUDE A COMMA (,)) BETWEEN FIELDS AND VALUES) $addl_insert_values = ",'$someusersid','2002-07-07'"; EXAMPLE: $addl_select_crit (NOTE! YOU MUST ADD AND/OR) $addl_select_crit = " AND userid = '$someuserid'" EXAMPLE: $addl_update_crit (NOTE! YOU MUST INCLUDE A COMMA (,)) $addl_update_crit = "',userid='$someuserid'" ----------------------------------------------------------------------*/ $addl_select_crit = ""; //ADDL CRITERIA FOR SQL STATEMENTS (ADD/UPD/DEL). $addl_update_crit = ""; //ADDITIONAL CRITERIA FOR UPDATE STATEMENTS. $addl_insert_crit = ""; //ADDITIONAL CRITERIA FOR INSERT STATEMENTS. $addl_insert_values = ""; //ADDITIONAL VALUES FOR INSERT STATEMENTS. /*---------------------------------------------------------------------- NOTE: SOME SERVERS RUN "MAGIC QUOTES" TO FIX STRINGS WHEN INSERTING/ UPDATING RECORDS. IF MAGIC QUOTES OPTION IS DISABLED, THE GENERATED CODE WILL AUTOMATICALLY FIX STRINGS TO HELP ELIMINATE ERRORS. ----------------------------------------------------------------------*/ if (get_magic_quotes_gpc()) { $addslash="no"; } //AUTO-ADD SLASHES IF MAGIC QUOTES IS OFF /*---------------------------------------------------------------------- FUNCTIONS ----------------------------------------------------------------------*/ /*--------------------------------------------------------------- FUNCTION: db() DESCRIPTION: CREATES DB CONNECTION OBJECT FOR KNEBEL.NET PHP CODE GENERATOR CODE. INPUTS: NONE RETURNS: DATABASE CONNECTION OBJECT GLOBAL VARIABLES: NONE FUNCTIONS CALLED: NONE CALLED BY: AUTHOR: KNEBEL MODIFICATIONS: MM/DD/YY - CREATED FUNCTION (KNEBEL.NET) NOTES: ----------------------------------------------------------------*/ function db() { $dbuser = "************"; $dbserver = "*************"; $dbpass = "*************"; $dbname = "***************"; //CONNECTION STRING $db_conn = mysql_connect($dbserver, $dbuser, $dbpass) or die ("UNABLE TO CONNECT TO DATABASE"); mysql_select_db($dbname) or die ("UNABLE TO SELECT DATABASE"); return $db_conn; }//end function db function FixString($strtofix) { //THIS FUNCTION ESCAPES SPECIAL CHARACTERS FOR INSERTING INTO SQL if (get_magic_quotes_gpc()) { $addslash="no"; } else { $addslash="yes"; } if ($addslash == "yes") { $strtofix = addslashes($strtofix); } $strtofix = ereg_replace( "<", "<", $strtofix ); $strtofix = ereg_replace( "'", "'", $strtofix ); $strtofix = ereg_replace( "(\n)", "<BR>", $strtofix ); return $strtofix; }//end FixString function ThrowError($err_type,$err_descr) { //THIS FUNCTION PROVIDES ERROR DESCRIPTIONS $err_text = ""; switch ($err_type) { case "9991SQLresultcount": return "<BR><B>ERROR: --> " . mysql_error() ."</b> <BR>LOCATION: $err_type <BR>DESCRIPTION: Unable to execute SQL statement. <BR>Please Check the Following: <BR>- Ensure the Table(s) Exists in database $dbname <BR>- Ensure All Fields Exist in the Table(s) <BR>- SQL STATEMENT: $err_descr<BR> <BR>- MYSQL ERROR: " . mysql_error(); break; case "9994SQL": return "<BR><B>ERROR: --> " . mysql_error() ."</b> <BR>LOCATION: $err_type <BR>DESCRIPTION: Unable to execute SQL statement. <BR>Please Check the Following: <BR>- Ensure the Table(s) Exists in database $dbname <BR>- Ensure All Fields Exist in the Table(s) <BR>- SQL STATEMENT: $err_descr<BR> <BR>- MYSQL ERROR: " . mysql_error(); break; default: return "UNKNOWN ERROR TYPE: $err_type <BR>DESCR: $err_descr<BR>"; break; } //end switch return $err_text; } //end ThrowError /*---------------------------------------------------------------------- END FUNCTIONS ----------------------------------------------------------------------*/ /*---------------------------------------- ADD NEW LINK ----------------------------------------*/ if ($proc == "") { if ($allowaddnew == "yes") { ?> <table border=0 width=30% align=center> <tr> <td align=center><br><br><font size="3"><b>BTG Job Board</b></font><br><br> <table border=0 align=center width=800> <tr> <td align=center>| <a href=jobs.php?posting=yes&>Job List</a> | <a href=jobs.php?proc=New&>Add a Job</a> | <a href=jobs.php?proc=&>Search</a> | </td></tr></table><br> <? } /*--------------------------------------------------------------------------------------- BEGIN SEARCH SECTION 9991 ---------------------------------------------------------------------------------------*/ /*-- SECTION: 9991FORM --*/ ?> <form method="POST" action="<?php echo $thispage; ?>?posting=yes&<?php echo $pagevars; ?>"> <p><B>Search:</B> <input type="text" CLASS='TXT_BOX' name="searchcrit" size="20" value="<? echo $searchcrit; ?>"> <INPUT CLASS="BUTTON" TYPE="SUBMIT" VALUE="Search!" NAME="B1"></P> </form> </td> </tr> </table> <? /*---------------------------------------------------------------- IF THEY ARE POSTING TO THE SEARCH PAGE (SHOW SEARCH RESULTS) ----------------------------------------------------------------*/ if ($posting == "yes") { /*---------------------------------------------------------------- PAGING SETTINGS - THIS IS USED FOR NEXT/PREVIOUS X RECORDS ----------------------------------------------------------------*/ $pagenorecords = 20; //THIS IS THE PAGE SIZE //IF NO PAGE if ($page == 0) { $myrecstart = 0; } else { $myrecstart = ($page * $pagenorecords); } /*-- SECTION: 9991SQL --*/ if ($searchcrit == "") { $flag = "all"; $sql = "SELECT * FROM loads"; $sqlcount = "select count(*) as reccount from loads"; } else { //IF THEY TYPED SEARCH WORDS $sqlcount = "select count(*) as reccount from loads WHERE ("; $sql = "SELECT * FROM loads WHERE ("; $sqlwhere = " mnum like '%$searchcrit%' OR loadnum like '%$searchcrit%' OR ddate like '%$searchcrit%' OR carrier like '%$searchcrit%' OR pickup like '%$searchcrit%' OR destination like '%$searchcrit%' OR dtime like '%$searchcrit%' OR notes like '%$searchcrit%' "; //FINISH SQL STRING //NOTE:CHECK ABOVE FOR AN EXTRA "OR": //IF YOU LEFT THE LAST //FIELD IN THE FIELD NAME ENTRY FORM BLANK, YOU WILL //GET AN EXTRA "OR" ABOVE. SIMPLY DELETE IT. } //END IF SEARCHCRIT = ""; if ($flag == "all") { $sql = $sql . " WHERE (1=1) $addl_select_crit LIMIT $myrecstart, $pagenorecords"; $sqlcount = $sqlcount . " WHERE (1=1) $addl_select_crit LIMIT $myrecstart, $pagenorecords"; } else { $sqlcount = $sqlcount . $sqlwhere . ") $addl_select_crit LIMIT $myrecstart, $pagenorecords"; $sql = $sql . $sqlwhere . ") $addl_select_crit LIMIT $myrecstart, $pagenorecords"; } if ($sql_debug_mode==1) { echo "<BR>SQL: $sql<BR>"; } //SET PAGE if ($page == 0) { $page = 1; } else { $page = ($page + 1); } /*---------------------------------------------------------------- FIND OUT HOW MANY RECORDS WE HAVE ----------------------------------------------------------------*/ if ($reccount == 0) { //$resultcount = (mysql_query($sqlcount,db() )) OR DIE (ThrowError($err_type,$err_descr);); $resultcount = (mysql_query($sqlcount,db() )) OR DIE (ThrowError("9991SQLresultcount",$sqlcount)); if ($myrowcount = mysql_fetch_array($resultcount)) { $reccount = $myrowcount["reccount"]; } //IF RECCOUNT = 0 }//end if reccount echo "<table border=0 width=95% align=center><tr><td> <DIV CLASS='NUM_RECS_FOUND'>$reccount Records Found</DIV>"; echo "<DIV CLASS='CURR_PAGE'>Page $page</DIV></td></tr></table>"; /*---------------------------------------------------------------- PAGING LINK - THIS IS USED FOR NEXT/PREVIOUS X RECORDS ----------------------------------------------------------------*/ if ($reccount > 20) { $ttlpages = ($reccount / 20); if ($page < $ttlpages) { ?> <HR> <br> <A HREF="<?php echo $thispage; ?>?posting=yes&page=<?php echo $page; ?>&reccount=<?php echo $reccount; ?>&searchcrit=<?php echo $searchcrit; ?>&<?php echo $pagevars; ?>">Next <?php echo $pagenorecords; ?> Records >></a><br> <?php } //END IF AT LAST PAGE } //END IF RECCOUNT > 20 if ($page > 0) { $newpage = $page - 2; } if ($newpage != -1) { ?> <br> <A HREF="<?php echo $thispage; ?>?posting=yes&page=<?php echo $newpage; ?>&reccount=<?php echo $reccount; ?>&searchcrit=<?php echo $searchcrit; ?>&<?php echo $pagevars; ?>"><< Previous <?php echo $pagenorecords; ?> Records</a> <br> <?php } //IF NEWPAGE != -1 /*---------------------------------------------------------------- END PAGING LINK - THIS IS USED FOR NEXT/PREVIOUS X RECORDS ----------------------------------------------------------------*/ //EXECUTE OUR SQL STRING FOR THE TABLE RECORDS $result = mysql_query($sql,db() ); if ($sql_debug_mode==1) { echo "<BR>SQL: $sql<BR>"; } if ($myrowsel = mysql_fetch_array($result)) { $id = $myrowsel["id"]; echo " <font size=-2>V=View E=Edit D=Delete</font><br><TABLE class=sortable id=job_id bgcolor=FFFFC0 border=1 width=95% align=center>"; echo " <TR>"; echo " <TH align=center><DIV CLASS='TBL_COL_HDR'>OPTIONS</DIV></TH>"; echo " <TH align=center><DIV CLASS='TBL_COL_HDR'>MNUM</DIV></TH>"; echo " <TH align=center><DIV CLASS='TBL_COL_HDR'>LOAD#</DIV></TH>"; echo " <TH align=center><DIV CLASS='TBL_COL_HDR'>DDATE</DIV></TH>"; echo " <TH align=center><DIV CLASS='TBL_COL_HDR'>CARRIER</DIV></TH>"; echo " <TH align=center><DIV CLASS='TBL_COL_HDR'>PICKUP</DIV></TD>"; echo " <TH align=center><DIV CLASS='TBL_COL_HDR'>DESTINATION</DIV></TH>"; echo " <TH align=center><DIV CLASS='TBL_COL_HDR'>DTIME</DIV></TH>"; echo " <TH align=center><DIV CLASS='TBL_COL_HDR'>NOTES</DIV></TH>"; echo "\n\n </TR>"; do { //FORMAT THE OUTPUT OF THE SEARCH $id = $myrowsel["id"]; //SWITCH ROW COLORS switch ($shade) { case "TBL_ROW_DATA_LIGHT": $shade = "TBL_ROW_DATA_DRK"; break; case "TBL_ROW_DATA_DRK": $shade = "TBL_ROW_DATA_LIGHT"; break; default: $shade = "TBL_ROW_DATA_DRK"; break; }//end switch shade /*---------------------------------------------------------------- VIEW SEARCH RESULTS BY PAGE ----------------------------------------------------------------*/ /*--------------------------------------- BEGIN RESULTS TABLE ---------------------------------------*/ echo "<TR>"; ?> <TD CLASS='<?php echo $shade; ?>'> <DIV CLASS='PAGE_OPTIONS'> <?php if ($allowview == "yes") { ?><a href="<?php echo $thispage; ?>?id=<?php echo $id; ?>&proc=View&<?php echo $pagevars; ?>">V </a> <?php } ?><?php if ($allowedit == "yes") { ?> <a href="<?php echo $thispage; ?>?id=<?php echo $id; ?>&proc=Edit&<?php echo $pagevars; ?>">E </a> <?php } ?><?php if ($allowdelete == "yes") { ?> <a href="<?php echo $thispage; ?>?id=<?php echo $id; ?>&proc=Delete&<?php echo $pagevars; ?>">D</a> <?php } ?> </DIV> </TD> <?php $mnum = $myrowsel["mnum"]; ?> <TD CLASS='<?php echo $shade; ?>'> <?php echo $mnum; ?> </TD> <?php $loadnum = $myrowsel["loadnum"]; ?> <TD CLASS='<?php echo $shade; ?>'> <?php echo $loadnum; ?> </TD> <?php $ddate = $myrowsel["ddate"]; ?> <TD CLASS='<?php echo $shade; ?>'> <?php echo $ddate; ?> </TD> <?php $carrier = $myrowsel["carrier"]; ?> <TD CLASS='<?php echo $shade; ?>'> <?php echo $carrier; ?> </TD> <?php $pickup = $myrowsel["pickup"]; ?> <TD CLASS='<?php echo $shade; ?>'> <?php echo $pickup; ?> </TD> <?php $destination = $myrowsel["destination"]; ?> <TD CLASS='<?php echo $shade; ?>'> <?php echo $destination; ?> </TD> <?php $dtime = $myrowsel["dtime"]; ?> <TD CLASS='<?php echo $shade; ?>'> <?php echo $dtime; ?> </TD> <?php $notes = $myrowsel["notes"]; ?> <TD CLASS='<?php echo $shade; ?>'> <?php echo $notes; ?> </TD> </TR> <? } while ($myrowsel = mysql_fetch_array($result)); echo "</TABLE>"; /*---------------------------------------------------------------- PAGING LINK - THIS IS USED FOR NEXT/PREVIOUS X RECORDS ----------------------------------------------------------------*/ if ($reccount > 20) { //IF THERE ARE MORE THAN 20 RECORDS PAGING $ttlpages = ($reccount / 20); if ($page < $ttlpages) { ?> <HR> <br> <A HREF="<?php echo $thispage; ?>?posting=yes&page=<?php echo $page; ?>&reccount=<?php echo $reccount; ?>&searchcrit=<?php echo $searchcrit; ?>&<?php echo $pagevars; ?>">Next <?php echo $pagenorecords; ?> Records >></a> <br> <?php } //END IF AT LAST PAGE } //END IF RECCOUNT > 20 //PREVIOUS RECORDS LINK if ($page > 0) { $newpage = $page - 2; } if ($newpage != -1) { ?> <br> <A HREF="<?php echo $thispage; ?>?posting=yes&page=<?php echo $newpage; ?>&reccount=<?php echo $reccount; ?>&searchcrit=<?php echo $searchcrit; ?>&<?php echo $pagevars; ?>"><< Previous <?php echo $pagenorecords; ?> Records</a> <br> <?php } //IF NEWPAGE != -1 /*---------------------------------------------------------------- END PAGING LINK - THIS IS USED FOR NEXT/PREVIOUS X RECORDS ----------------------------------------------------------------*/ } //END PROC == "" } //END IF POSTING = YES /*--------------------------------------------------------------------------------- END SEARCH SECTION 9991 ---------------------------------------------------------------------------------*/ }// END IF PROC = "" ?> <? /*---------------------------------------------------------------------- ADD NEW RECORDS SECTION ----------------------------------------------------------------------*/ if ($proc == "New") { ?> <table border=0 align=center width=90%><tr><td align=center><br><br><font size="3"><b>BTG Job Board</b></font><br><br> <table border=0 align=center width=800> <tr> <td align=center>| <a href=jobs.php?posting=yes&>Job List</a> | <a href=jobs.php?proc=New&>Add a Job</a> | <a href=jobs.php?proc=&>Search</a> | </td></tr></table><br><br> <TABLE border=1 width=40% align=center><tr><td> <? if ($allowaddnew == "yes") { ?> <? } //END OF IF ALLOW ADDNEW /*------------------------------------------------------------------------------- ADD NEW RECORD SECTION 9994 -------------------------------------------------------------------------------*/ if ($proc == "New") { echo "<DIV CLASS='PAGE_STATUS'>Adding Record</DIV>"; if ($post == "yes") { /* WE ARE ADDING A NEW RECORD SUBMITTED FROM THE FORM NOW LOOP THROUGH ALL OF THE RECORDS AND OUTPUT A STRING */ /* FIX STRING */ $mnum = FixString($mnum); $loadnum = FixString($loadnum); $ddate = FixString($ddate); $carrier = FixString($carrier); $pickup = FixString($pickup); $destination = FixString($destination); $dtime = FixString($dtime); $notes = FixString($notes); /*-- SECTION: 9994SQL --*/ $sql = "INSERT INTO loads ( mnum, loadnum, ddate, carrier, pickup, destination, dtime, notes $addl_insert_crit ) VALUES ( '$mnum', '$loadnum', '$ddate', '$carrier', '$pickup', '$destination', '$dtime', '$notes' $addl_insert_values )"; if ($sql_debug_mode==1) { echo "<BR>SQL: $sql<BR>"; } $result = mysql_query($sql,db() ); if ($result == 1) { echo "<DIV CLASS='SQL_RESULTS'>Record Inserted</DIV>"; } else { echo ThrowError("9994SQL",$sql); echo "Error inserting record (9994SQL)"; } //***** END INSERT SQL ***** } //END IF POST = YES FOR ADDING NEW RECORDS /*------------------------------------------------------------------------------- ADD NEW RECORD (CREATING) -------------------------------------------------------------------------------*/ if (!$post) {//THEN WE ARE ENTERING A NEW RECORD //SHOW THE ADD RECORD RECORD DATA INPUT FORM /*-- SECTION: 9994FORM --*/ ?> <FORM METHOD="POST" ACTION="<?php echo $thispage; ?>?proc=New&post=yes&<?php echo $pagevars; ?>"> <TABLE border=1 width=80% align=center> <TR> <TD CLASS='TBL_ROW_HDR'> <B>MNUM:</B> </TD> <TD> <INPUT CLASS='TXT_BOX' type="text" NAME="mnum" SIZE="30"> </TR> <TR> <TD CLASS='TBL_ROW_HDR'> <B>LOADNUM:</B> </TD> <TD> <INPUT CLASS='TXT_BOX' type="text" NAME="loadnum" SIZE="30"> </TR> <TR> <TD CLASS='TBL_ROW_HDR'> <B>DDATE:</B> </TD> <TD> <INPUT CLASS='TXT_BOX' type="text" NAME="ddate" SIZE="30"> </TR> <TR> <TD CLASS='TBL_ROW_HDR'> <B>CARRIER:</B> </TD> <TD> <INPUT CLASS='TXT_BOX' type="text" NAME="carrier" SIZE="30"> </TR> <TR> <TD CLASS='TBL_ROW_HDR'> <B>PICKUP:</B> </TD> <TD> <INPUT CLASS='TXT_BOX' type="text" NAME="pickup" SIZE="30"> </TR> <TR> <TD CLASS='TBL_ROW_HDR'> <B>DESTINATION:</B> </TD> <TD> <INPUT CLASS='TXT_BOX' type="text" NAME="destination" SIZE="30"> </TR> <TR> <TD CLASS='TBL_ROW_HDR'> <B>DTIME:</B> </TD> <TD> <INPUT CLASS='TXT_BOX' type="text" NAME="dtime" SIZE="30"> </TR> <TR> <TD CLASS='TBL_ROW_HDR'> <B>NOTES:</B> </TD> <TD> <textarea CLASS='TXT_BOX'NAME="notes" ROWS="4" cols="35"></TEXTAREA> </TR> <TR> <TD> </TD> <TD> <INPUT CLASS='BUTTON' TYPE="SUBMIT" VALUE="SAVE" NAME="SUBMIT"> <INPUT CLASS='BUTTON' TYPE="RESET" VALUE="RESET" NAME="RESET"> </TD> </TR> </TABLE> <BR> </FORM> </td></tr></table> <?php } //END if post="" //***** END ADD NEW ENTRY FORM***** } //END PROC == NEW /*--------------------------------------------------------------------------------- END ADD SECTION 9994 ---------------------------------------------------------------------------------*/}// END IF PROC = "NEW" ?> <? /*------------------------------------------------- SEARCH AND ADD-NEW LINKS -------------------------------------------------*/ if ($proc == "Edit") { ?> <table border=0 align=center width=90%><tr><td align=center><br><br><font size="3"><b>BTG Job Board</b></font><br><br> <table border=0 align=center width=800> <tr> <td align=center>| <a href=jobs.php?posting=yes&>Job List</a> | <a href=jobs.php?proc=New&>Add a Job</a> | <a href=jobs.php?proc=&>Search</a> | </td></tr></table><br><br> <? if ($allowaddnew == "yes") { ?> <? } //END OF IF ALLOW ADDNEW /*---------------------------------------------------------------------- EDIT RECORDS SECTION ----------------------------------------------------------------------*/ /*------------------------------------------------------------------------------- EDIT RECORD SECTION 9993 -------------------------------------------------------------------------------*/ if ($proc == "Edit") { //SHOW THE EDIT RECORD RECORD PAGE //******************************************************************// if ($post == "yes") { //THEN WE ARE POSTING UPDATES TO A RECORD //***** BEGIN UPDATE SQL***** //REPLACE THE FIELD CONTENTS SO THEY DON'T MESS UP YOUR QUERY //NOW LOOP THROUGH ALL OF THE RECORDS AND OUTPUT A STRING /* FIX STRING */ $mnum = FixString($mnum); $loadnum = FixString($loadnum); $ddate = FixString($ddate); $carrier = FixString($carrier); $pickup = FixString($pickup); $destination = FixString($destination); $dtime = FixString($dtime); $notes = FixString($notes); //SQL STRING /*-- SECTION: 9993SQLUPD --*/ $sql = "UPDATE loads SET mnum='$mnum', loadnum='$loadnum', ddate='$ddate', carrier='$carrier', pickup='$pickup', destination='$destination', dtime='$dtime', notes='$notes' $addl_update_crit WHERE (id='$id') $addl_select_crit "; if ($sql_debug_mode==1) { echo "<BR>SQL: $sql<BR>"; } $result = mysql_query($sql,db() ); if ($result == 1) { echo "<DIV CLASS='SQL_RESULTS'>Updated</DIV>"; } else { echo "Error Updating Record (9993SQLUPD)"; } //***** END UPDATE SQL ***** } //END IF POST IS YES /*------------------------------------------------------------------------------- EDIT RECORD (FORM) - SHOW THE EDIT RECORD RECORD DATA INPUT FORM -------------------------------------------------------------------------------*/ if ($post == "") { //THEN WE ARE EDITING A RECORD echo "<table border=1 width=400 align=center><tr><td><DIV CLASS='PAGE_STATUS'>Editing Record</DIV>"; ?> <TABLE width=450 align=center><tr><td><DIV CLASS='PAGE_OPTIONS'> <?php if ($allowview == "yes") { ?><a href="<?php echo $thispage; ?>?id=<?php echo $id; ?>&proc=View&<?php echo $pagevars; ?>">V</a> <?php } //END ALLOWVIEW ?><?php if ($allowedit == "yes") { ?> <a href="<?php echo $thispage; ?>?id=<?php echo $id; ?>&proc=Edit&<?php echo $pagevars; ?>">E</a> <?php } //END ALLOWEDIT ?><?php if ($allowdelete == "yes") { ?> <a href="<?php echo $thispage; ?>?id=<?php echo $id; ?>&proc=Delete&<?php echo $pagevars; ?>">D</a> <?php } //END ALLOWDELETE ?></font><font face="arial" size="2"> </DIV></td> </tr> </table> <? /*-- SECTION: 9993SQLGET --*/ $sql = "SELECT * FROM loads WHERE (id = '$id') $addl_select_crit "; if ($sql_debug_mode==1) { echo "<BR>SQL: $sql<BR>"; } $result = mysql_query($sql,db() ) or die ("Error Retrieving Records (9993SQLGET)"); if ($myrow = mysql_fetch_array($result)) { do { $mnum = $myrow["mnum"]; $mnum = ereg_replace("(\n)", "<BR>", $mnum); $loadnum = $myrow["loadnum"]; $loadnum = ereg_replace("(\n)", "<BR>", $loadnum); $ddate = $myrow["ddate"]; $ddate = ereg_replace("(\n)", "<BR>", $ddate); $carrier = $myrow["carrier"]; $carrier = ereg_replace("(\n)", "<BR>", $carrier); $pickup = $myrow["pickup"]; $pickup = ereg_replace("(\n)", "<BR>", $pickup); $destination = $myrow["destination"]; $destination = ereg_replace("(\n)", "<BR>", $destination); $dtime = $myrow["dtime"]; $dtime = ereg_replace("(\n)", "<BR>", $dtime); $notes = $myrow["notes"]; $notes = ereg_replace("(\n)", "<BR>", $notes); ?> <form method="post" action="<?php echo $thispage; ?>?proc=Edit&post=yes&<?php echo $pagevars; ?>"> <TABLE border=1 width=90% align=center> <TR> <TD CLASS='TBL_ROW_HDR'> MNUM: </TD> <TD> <INPUT TYPE='TEXT' CLASS='TXT_BOX' name='mnum' value='<?php echo$mnum; ?>' size='30'> </td> </tr> <TR> <TD CLASS='TBL_ROW_HDR'> LOADNUM: </TD> <TD> <INPUT TYPE='TEXT' CLASS='TXT_BOX' name='loadnum' value='<?php echo$loadnum; ?>' size='30'> </td> </tr> <TR> <TD CLASS='TBL_ROW_HDR'> DDATE: </TD> <TD> <INPUT TYPE='TEXT' CLASS='TXT_BOX' name='ddate' value='<?php echo$ddate; ?>' size='30'> </td> </tr> <TR> <TD CLASS='TBL_ROW_HDR'> CARRIER: </TD> <TD> <INPUT TYPE='TEXT' CLASS='TXT_BOX' name='carrier' value='<?php echo$carrier; ?>' size='30'> </td> </tr> <TR> <TD CLASS='TBL_ROW_HDR'> PICKUP: </TD> <TD> <INPUT TYPE='TEXT' CLASS='TXT_BOX' name='pickup' value='<?php echo$pickup; ?>' size='30'> </td> </tr> <TR> <TD CLASS='TBL_ROW_HDR'> DESTINATION: </TD> <TD> <INPUT TYPE='TEXT' CLASS='TXT_BOX' name='destination' value='<?php echo$destination; ?>' size='30'> </td> </tr> <TR> <TD CLASS='TBL_ROW_HDR'> DTIME: </TD> <TD> <INPUT TYPE='TEXT' CLASS='TXT_BOX' name='dtime' value='<?php echo$dtime; ?>' size='30'> </td> </tr> <TR> <TD CLASS='TBL_ROW_HDR'> NOTES: </TD> <TD> <?php $notes=ereg_replace( "(<BR>)", "", $notes ); ?> <textarea CLASS='TXT_BOX' name="notes" rows="4" cols="35"><?php echo$notes; ?></textarea> </td> </tr> </td> </tr&#

[img src=\"style_emoticons/[#EMO_DIR#]/excl.gif\" style=\"vertical-align:middle\" emoid=\":excl:\" border=\"0\" alt=\"excl.gif\" /] I have a Job List with different fields. I would like a column that would have the ability to click on C(ompleted) and when you check it off it will post these jobs to a new web page of completed jobs. Actually, instead of having the Delete choice, I would like a C(ompleted) choice with the V(iew) and E(dit) I can't figure out how to do this. Any help would be appreciated. Here is the site: [a href=\"http://jobboard.bernardtransportation.com/jobs.php?posting=yes&\" target=\"_blank\"]http://jobboard.bernardtransportation.com/...hp?posting=yes&[/a] Please don't delete any entries or make any radical changes to the Job List.

I have a Job List with different fields. I would like a column that would have the ability to click on C(ompleted) and when you check it off it will post these jobs to a new web page of completed jobs. Actually, instead of having the Delete choice, I would like a C(ompleted) choice with the V(iew) and E(dit) I can't figure out how to do this. Any help would be appreciated. Here is the site: [a href=\"http://jobboard.bernardtransportation.com/jobs.php?posting=yes&\" target=\"_blank\"]http://jobboard.bernardtransportation.com/...hp?posting=yes&[/a] Please don't delete any entries or make any radical changes to the Job List.