Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Page 2 of 3 FirstFirst 123 LastLast
Results 16 to 30 of 35
  1. #16
    Senior Coder
    Join Date
    Feb 2011
    Location
    Your Monitor
    Posts
    4,091
    Thanks
    51
    Thanked 506 Times in 493 Posts
    Quote Originally Posted by wojo1086 View Post
    Why do you have little apostrophe looking things around your column name? Ex:
    `date_next_maint`
    They shouldn't be there.
    Actually technically they should be there, that is the correct and proper way however since mysql know many of us are lazy they don't enforce it. Try using a column name with spaces though and you're going to come up against sql parse errors without the ` marks

    Same principle with dos program names and parameters.
    My helpful sig is on vacation trying to loose some weight. It got a bit fat and caused a few problems but it will be back at some point!

  2. Users who have thanked tangoforce for this post:

    flashbang_pro (08-28-2012)

  3. #17
    New Coder
    Join Date
    May 2011
    Posts
    21
    Thanks
    12
    Thanked 0 Times in 0 Posts
    I have added the session_start and now this is the error I get.

    Error -

    Maintenance Info Creation Failed.

    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 '' at line 5

    Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 5 SQL: UPDATE service_info SET `date_next_maint`='testing', `issues_reported`='', `date_reported`='', `scheduled_service_date`='', `service_performed`='', `date_service_performed`='', `date_of_followup`='',`service_in_progress`='', `date_return_use`='', `time_return_use`='', `issues_nonrepairable`='', `date_nonrepairable_issues`='', `comments` ='' WHERE id=

    Also on the page with the form I noticed in the url there is no id specified.

  4. #18
    New Coder
    Join Date
    May 2011
    Posts
    21
    Thanks
    12
    Thanked 0 Times in 0 Posts
    Ok I have made some updates so I will repost all files involved.

    service_list_update (displays table of current records with each having an update link in last row)

    PHP Code:
    <html>
    <head>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
    <title>Service Order Database</title>
    <link href="nav.css" rel="stylesheet" type="text/css"><!--[if lt IE 9]>
    <script src="http://html5shiv.googlecode.com/svn/trunk/html5.js"></script>
    <![endif]-->
    </head>
    <body>
    <?php require_once("dbcon.php"); ?>
    <?php 
    require_once("functions.php"); ?>
    <?php
    $query
    ="SELECT * FROM service_info ORDER BY id";
    $result=mysql_query($query);

    $num=mysql_numrows($result);

    mysql_close();

    echo 
    "<b><center>Database Output</center></b><br><br>";
    // process form when posted 
    if(isset($_POST['value'])) { 
        if(
    $_POST['value'] == 'Engine') { 
            
    // query to get all Engine records   
            
    $query "SELECT * FROM servifce_info WHERE issues_reported='Engine'";   
        }elseif(
    $_POST['value'] == 'Transmission') { 
            
    // query to get all Transmission records   
            
    $query "SELECT * FROM servifce_info WHERE issues_reported='Transmission'";   
        }elseif(
    $_POST['value'] == 'Differential') { 
            
    // query to get all Differential records   
            
    $query "SELECT * FROM servifce_info WHERE issues_reported='Differential'";   
        }elseif(
    $_POST['value'] == 'Electrical') { 
            
    // query to get all Electrical records   
            
    $query "SELECT * FROM servifce_info WHERE issues_reported='Electrical'";   
        }elseif(
    $_POST['value'] == 'Tires') { 
            
    // query to get all Tires records   
            
    $query "SELECT * FROM servifce_info WHERE issues_reported='Tires'";   
        }elseif(
    $_POST['value'] == 'Brakes') { 
            
    // query to get all Brakes records   
            
    $query "SELECT * FROM servifce_info WHERE issues_reported='Brakes'";   
        }elseif(
    $_POST['value'] == 'HVAC') { 
            
    // query to get all HVAC records   
            
    $query "SELECT * FROM servifce_info WHERE issues_reported='HVAC'";   
        }elseif(
    $_POST['value'] == 'Lighting') { 
            
    // query to get all Lighting records   
            
    $query "SELECT * FROM servifce_info WHERE issues_reported='Lighting'";   
        }elseif(
    $_POST['value'] == 'Accident Damage') { 
            
    // query to get all Accident Damage records   
            
    $query "SELECT * FROM servifce_info WHERE issues_reported='Accident Damage'";   
        } else {   
            
    // query to get all records   
            
    $query "SELECT * FROM servifce_info ";   
        }   
    mysql_close();

    ?> 
    <html> 
    <head></head> 
    <body> 
    <form action='<?php echo $_SERVER['PHP_SELF']; ?>' method='post' name='form_filter' >  
        <select name="value">  
            <option value="all">All</option>  
            <option value="Engine">Engine</option>  
            <option value="Transmission">Transmission</option>  
            <option value="Differential">Differential</option>     
            <option value="Electrical">Electrical</option>  
            <option value="Tires">Tires</option>  
            <option value="Brakes">Brakes</option>  
            <option value="HVAC">HVAC</option>  
            <option value="Lighting">Lighting</option>  
            <option value="Accident">Accident</option>  
    </select>  
        <br />  
        <input type='submit' value = 'Filter'>  
    </form> 
    <div id="nav">
    <ul>
        <li><a href="order_vehicle_name.php" title=""> ORDER BY VEHICLE NAME</a></li>
        <li><a href="order_vehicle_number.php" title=""> ORDER BY VEHICLE NUMBER</a></li>
        <li><a href="order_location.php" title=""> ORDER BY LOCATION</a></li>
        <li><a href="order_status.php" title=""> ORDER BY STATUS</a></li>
        <li><a href="order_issues_reported.php" title=""> ORDER REPORTED ISSUES</a></li>
        <li><a href="order_id.php" title=""> ORDER BY ID</a></li>
        <li><a href="index.php">LOG OUT</a></li>
    </ul>
    </div>
    <table border="1" cellspacing="5" cellpadding="5">
    <tr>
    <th><font face="Arial, Helvetica, sans-serif">ID</font></th>
    <th><font face="Arial, Helvetica, sans-serif">Vehicle Name</font></th>
    <th><font face="Arial, Helvetica, sans-serif">Vehicle Number</font></th>
    <th><font face="Arial, Helvetica, sans-serif">Location</font></th>
    <th><font face="Arial, Helvetica, sans-serif">Status</font></th>
    <th><font face="Arial, Helvetica, sans-serif">RTS</font></th>
    <th><font face="Arial, Helvetica, sans-serif">Odometer Date</font></th>
    <th><font face="Arial, Helvetica, sans-serif">Odometer Reading Date</font></th>
    <th><font face="Arial, Helvetica, sans-serif">Date of next scheduled maintenance</font></th>
    <th><font face="Arial, Helvetica, sans-serif">Maintenace/Repair Issues Reported</font></th>
    <th><font face="Arial, Helvetica, sans-serif">Date Issues Reported</font></th>
    <th><font face="Arial, Helvetica, sans-serif">Scheduled Service Date Issues Reported</font></th>
    <th><font face="Arial, Helvetica, sans-serif">Repair Service Performed W/Comments</font></th>
    <th><font face="Arial, Helvetica, sans-serif">Date Service Performed</font></th>
    <th><font face="Arial, Helvetica, sans-serif">Date OF Follow-up</font></th>
    <th><font face="Arial, Helvetica, sans-serif">Service In Progress 0=NO 1=YES</font></th>
    <th><font face="Arial, Helvetica, sans-serif">Date Return To Use</font></th>
    <th><font face="Arial, Helvetica, sans-serif">Time Return Use</font></th>
    <th><font face="Arial, Helvetica, sans-serif">Nonrepaiable Issues Found W/Comments</font></th>
    <th><font face="Arial, Helvetica, sans-serif">Date Issues Found</font></th>
    <th><font face="Arial, Helvetica, sans-serif">Parts Cost</font></th>
    <th><font face="Arial, Helvetica, sans-serif">Hours Worked</font></th>
    <th><font face="Arial, Helvetica, sans-serif">Comments</font></th>
    <th><font face="Arial, Helvetica, sans-serif">Update</font></th>
    </tr>

    <?php
    $i
    =0;
    while (
    $i $num) {

    $field1=mysql_result($result,$i,"id");
    $field2=mysql_result($result,$i,"name");
    $field3=mysql_result($result,$i,"number");
    $field4=mysql_result($result,$i,"location");
    $field5=mysql_result($result,$i,"status");
    $field6=mysql_result($result,$i,"rts");
    $field7=mysql_result($result,$i,"odomread");
    $field8=mysql_result($result,$i,"odomdate");
    $field9=mysql_result($result,$i,"date_next_maint");
    $field10=mysql_result($result,$i,"issues_reported");
    $field11=mysql_result($result,$i,"date_reported");
    $field12=mysql_result($result,$i,"scheduled_service_date");
    $field13=mysql_result($result,$i,"service_performed");
    $field14=mysql_result($result,$i,"date_service_performed");
    $field15=mysql_result($result,$i,"date_of_followup");
    $field16=mysql_result($result,$i,"service_in_progress");
    $field17=mysql_result($result,$i,"date_return_use");
    $field18=mysql_result($result,$i,"time_return_use");
    $field19=mysql_result($result,$i,"issues_nonrepairable");
    $field20=mysql_result($result,$i,"date_nonrepairable_issues");
    $field21=mysql_result($result,$i,"parts_cost");
    $field22=mysql_result($result,$i,"hours");
    $field23=mysql_result($result,$i,"comments");
    ?>

    <tr>
    <td><font face="Arial, Helvetica, sans-serif"><?php echo $field1?></font></td>
    <td><font face="Arial, Helvetica, sans-serif"><?php echo $field2?></font></td>
    <td><font face="Arial, Helvetica, sans-serif"><?php echo $field3?></font></td>
    <td><font face="Arial, Helvetica, sans-serif"><?php echo $field4?></font></td>
    <td><font face="Arial, Helvetica, sans-serif"><?php echo $field5?></font></td>
    <td><font face="Arial, Helvetica, sans-serif"><?php echo $field6?></font></td>
    <td><font face="Arial, Helvetica, sans-serif"><?php echo $field7?></font></td>
    <td><font face="Arial, Helvetica, sans-serif"><?php echo $field8?></font></td>
    <td><font face="Arial, Helvetica, sans-serif"><?php echo $field9?></font></td>
    <td><font face="Arial, Helvetica, sans-serif"><?php echo $field10?></font></td>
    <td><font face="Arial, Helvetica, sans-serif"><?php echo $field11?></font></td>
    <td><font face="Arial, Helvetica, sans-serif"><?php echo $field12?></font></td>
    <td><font face="Arial, Helvetica, sans-serif"><?php echo $field13?></font></td>
    <td><font face="Arial, Helvetica, sans-serif"><?php echo $field14?></font></td>
    <td><font face="Arial, Helvetica, sans-serif"><?php echo $field15?></font></td>
    <td><font face="Arial, Helvetica, sans-serif"><?php echo $field16?></font></td>
    <td><font face="Arial, Helvetica, sans-serif"><?php echo $field17?></font></td>
    <td><font face="Arial, Helvetica, sans-serif"><?php echo $field18?></font></td>
    <td><font face="Arial, Helvetica, sans-serif"><?php echo $field19?></font></td>
    <td><font face="Arial, Helvetica, sans-serif"><?php echo $field20?></font></td>
    <td><font face="Arial, Helvetica, sans-serif"><?php echo $field21?></font></td>
    <td><font face="Arial, Helvetica, sans-serif"><?php echo $field22?></font></td>
    <td><font face="Arial, Helvetica, sans-serif"><?php echo $field23?></font></td>
    <td><a href="maint_update.php?id=<?php echo $field1['id']; ?>">update</a></td>
    </tr>

    <?php
    $i
    ++;
    }
    ?>
    </body>
    </html>
    maint_update (displays a form where you can update the selected record)

    PHP Code:
    <?php session_start();?>
    <?php 
    require_once("dbcon.php"); ?>
    <?php 
    require_once("functions.php"); ?>
    <?php
    // get value of id that sent from address bar
    $id=$_GET['id'];
    $_SESSiON['id'] = $id;

    // Retrieve data from database 
    $sql="SELECT * FROM $tbl_name WHERE id='$id'";
    $result=mysql_query($sql);
    $rows=mysql_fetch_array($result);
    ?>

    <html>
    <body>
    <h1>Maintenace Report  </h1>
        <section>
           <section>
             <form method="post" name="form1" action="updated_maint.php">
               <table align="center">
                   <tr valign="baseline">
                   <th nowrap align="right">Date of next scheduled maintenance:</th>
                  <td>
                     <input type="text" name="date_next_maint" value="" size="32">
                 </tr>
                 <tr valign="baseline">
                   <th nowrap align="right">Maintenace/Repair Issues Reported:</th>
                  <td>
                     <textarea name="issues_reported" rows="3" cols="27"></textarea>
                 </tr>
                 <tr valign="baseline">
                   <th nowrap align="right">Date That Maintenace/Repair Issues Reported:</th>
                  <td>
                  <input type="text" name="date_reported" value="" size="32">
                 </tr>
                 <tr valign="baseline">
                   <th nowrap align="right">Scheduled Service Date That Maintenace/Repair Issues Reported:</th>
                  <td>
                     <input type="text" name="scheduled_service_date" value="" size="32">
                 </tr>
                 <tr valign="baseline">
                   <th nowrap align="right">Maintenace/Repair Service Performed W/Comments:</th>
                  <td>
                    <textarea name="service_performed" rows="3" cols="27"></textarea>
                 </tr>
                 <tr valign="baseline">
                   <th nowrap align="right">Date Maintenace/Repair Service Performed:</th>
                   <td><input type="text" name="date_service_performed" value="" size="32"></td>
                 </tr>
                 <tr valign="baseline">
                   <th nowrap align="right">Date OF Follow-up Work / If Needed:</th>
                  <td>
                     <input type="text" name="date_of_followup" value="" size="32">
                 </tr>
                 <tr valign="baseline">
                   <th nowrap align="right">Service In Progress:</th>
                  <td>
                     <input type="radio" name="service_in_progress" value="0" /> No
                        &nbsp;
                        <input type="radio" name="service_in_progress" value="1" /> Yes
                 </tr>
                 <tr valign="baseline">
                   <th nowrap align="right">Date Return To Use:</th>
                  <td>
                     <input type="text" name="date_return_use" value="" size="32">
                 </tr>
                 <tr valign="baseline">
                   <th nowrap align="right">Time Return Use:</th>
                  <td>
                     <input type="text" name="time_return_use" value="" size="32">
                 </tr>
                 <tr valign="baseline">
                   <th nowrap align="right">Nonrepaiable Issues Found W/Comments:</th>
                  <td>
                    <textarea name="issues_nonrepairable" rows="3" cols="27"></textarea>
                 </tr>
                 <tr valign="baseline">
                   <th nowrap align="right">Date Nonrepaiable Issues Found:</th>
                  <td>
                     <input type="text" name="date_nonrepairable_issues" value="" size="32">
                 </tr>
                 <tr valign="baseline">
                   <th nowrap align="right">Comments:</th>
                  <td>
                    <textarea name="comments" rows="3" cols="27"></textarea>
                 </tr>
                 <input type="hidden" name="id" value = "$id" /> 
                 <tr valign="baseline">
                   <td nowrap align="right">&nbsp;</td>
                   <td><input type="submit" value="Insert record"></td>
                 </tr>
               </table>
               <input type="hidden" name="MM_insert" value="form1">
             </form>
             <a href="service_list_update.php">Cancel</a>
             <p>&nbsp;</p>
           </section>
      <!-- end .content --></h2>
        </section>
    </body>
    </html>
    updated_maint (should update the table in mysql and redirect you displaying the results on the service_list_update page)

    PHP Code:
    <?php session_start();?>
    <?php 
    require_once("dbcon.php"); ?>
    <?php 
    require_once("functions.php"); ?>
    <?php
        $id 
    $_SESSION['id'];
        
    $date_next_maint mysql_prep($_POST['date_next_maint']);
        
    $issues_reported mysql_prep($_POST['issues_reported']);
        
    $date_reported mysql_prep($_POST['date_reported']);
        
    $scheduled_service_date mysql_prep($_POST['scheduled_service_date']);
        
    $service_performed mysql_prep($_POST['service_performed']);
        
    $date_service_performed mysql_prep($_POST['date_service_performed']);
        
    $date_of_followup mysql_prep($_POST['date_of_followup']);
        
    $service_in_progress mysql_prep($_POST['service_in_progress']);
        
    $date_return_use mysql_prep($_POST['date_return_use']);
        
    $time_return_use mysql_prep($_POST['time_return_use']);
        
    $issues_nonrepairable mysql_prep($_POST['issues_nonrepairable']);
        
    $date_nonrepairable_issues mysql_prep($_POST['date_nonrepairable_issues']);
        
    $comments mysql_prep($_POST['comments']);
    ?>
    <?php
        $query 
    "UPDATE service_info SET `date_next_maint`='$date_next_maint', `issues_reported`='$issues_reported', `date_reported`='$date_reported',
        `scheduled_service_date`='$scheduled_service_date', `service_performed`='$service_performed', `date_service_performed`='$date_service_performed', 
        `date_of_followup`='$date_of_followup',`service_in_progress`='$service_in_progress', `date_return_use`='$date_return_use', `time_return_use`='$time_return_use', 
        `issues_nonrepairable`='$issues_nonrepairable', `date_nonrepairable_issues`='$date_nonrepairable_issues', `comments` ='$comments'
        WHERE id=$id"
    ;
        
        
    $result mysql_query($query$connection);
        if (
    $result) {
            
    // Success!
            
    redirect_to("service_list_update.php");
        } else {
            
    // Display error message.
            
    echo "<p>Maintenance Info Creation Failed.</p>";
            echo 
    "<p>" mysql_error() . "</p>";
        }
        echo 
    "<p>Error: " mysql_error() . " SQL: $query</p>";
    ?>

  5. #19
    New Coder
    Join Date
    May 2011
    Posts
    21
    Thanks
    12
    Thanked 0 Times in 0 Posts
    This is the error I get now.

    Maintenance Info Creation Failed.

    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 '' at line 5

    Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 5 SQL: UPDATE service_info SET `date_next_maint`='testing', `issues_reported`='', `date_reported`='', `scheduled_service_date`='', `service_performed`='', `date_service_performed`='', `date_of_followup`='',`service_in_progress`='', `date_return_use`='', `time_return_use`='', `issues_nonrepairable`='', `date_nonrepairable_issues`='', `comments` ='' WHERE id=

  6. #20
    Senior Coder
    Join Date
    Feb 2011
    Location
    Your Monitor
    Posts
    4,091
    Thanks
    51
    Thanked 506 Times in 493 Posts
    Quote Originally Posted by flashbang_pro View Post
    maint_update (displays a form where you can update the selected record)
    PHP Code:
    <?php session_start();?>
    <?php 
    require_once("dbcon.php"); ?>
    <?php 
    require_once("functions.php"); ?>
    <?php
    // get value of id that sent from address bar
    $id=$_GET['id'];
    $_SESSiON['id'] = $id//This line is bad
    $_SESSION is case sensitive. That means it must be accessed using $_SESSION not $_SESSiON - Note the little i

    I suspect however that you may still see an error from your SQL after fixing that as where <something> = '' is normally valid - mysql will select a field with nothing in it (though if its an integer field this could cause the error you're seeing I suppose).
    Last edited by tangoforce; 08-27-2012 at 07:17 PM.
    My helpful sig is on vacation trying to loose some weight. It got a bit fat and caused a few problems but it will be back at some point!

  7. Users who have thanked tangoforce for this post:

    flashbang_pro (08-28-2012)

  8. #21
    New Coder
    Join Date
    May 2011
    Posts
    21
    Thanks
    12
    Thanked 0 Times in 0 Posts
    Thank you I will fix that and remember.

  9. #22
    New Coder
    Join Date
    May 2011
    Posts
    21
    Thanks
    12
    Thanked 0 Times in 0 Posts
    Ok I had everything working yesterday, but when I updated a few fields and then when back to update a few others, it deleted the previous updated fields and set them to blank, so not I am trying INSERT INTO service_info WHERE id=$id and this is the error I get and these are the updated pages involved.

    Maintenance Info Creation Failed.

    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 '`date_next_maint`='testing', `date_reported`='testing', `scheduled_service_d' at line 1

    Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`date_next_maint`='testing', `date_reported`='testing', `scheduled_service_d' at line 1 SQL: INSERT INTO service_info `date_next_maint`='testing', `date_reported`='testing', `scheduled_service_date`='testing', `service_performed`='', `date_service_performed`='', `date_of_followup`='',`service_in_progress`='1', `date_return_use`='', `time_return_use`='', `issues_nonrepairable`='', `date_nonrepairable_issues`='', `comments` ='' WHERE id=

    When I go to maint_update page, the url shows id='whatever record clicked' so it is getting the id from the records page.

    Here is records page service_list_update

    PHP Code:
    <html>
    <head>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
    <title>Service Order Database</title>
    <link href="nav.css" rel="stylesheet" type="text/css"><!--[if lt IE 9]>
    <script src="http://html5shiv.googlecode.com/svn/trunk/html5.js"></script>
    <![endif]-->
    </head>
    <body>
    <?php require_once("dbcon.php"); ?>
    <?php 
    require_once("functions.php"); ?>
    <?php
    $query
    ="SELECT * FROM service_info ORDER BY id";
    $result=mysql_query($query);

    $num=mysql_numrows($result);

    mysql_close();

    echo 
    "<b><center>Database Output</center></b><br><br>";
    // process form when posted 
    if(isset($_POST['value'])) { 
        if(
    $_POST['value'] == 'Engine') { 
            
    // query to get all Engine records   
            
    $query "SELECT * FROM servifce_info WHERE issues_reported='Engine'";   
        }elseif(
    $_POST['value'] == 'Transmission') { 
            
    // query to get all Transmission records   
            
    $query "SELECT * FROM servifce_info WHERE issues_reported='Transmission'";   
        }elseif(
    $_POST['value'] == 'Differential') { 
            
    // query to get all Differential records   
            
    $query "SELECT * FROM servifce_info WHERE issues_reported='Differential'";   
        }elseif(
    $_POST['value'] == 'Electrical') { 
            
    // query to get all Electrical records   
            
    $query "SELECT * FROM servifce_info WHERE issues_reported='Electrical'";   
        }elseif(
    $_POST['value'] == 'Tires') { 
            
    // query to get all Tires records   
            
    $query "SELECT * FROM servifce_info WHERE issues_reported='Tires'";   
        }elseif(
    $_POST['value'] == 'Brakes') { 
            
    // query to get all Brakes records   
            
    $query "SELECT * FROM servifce_info WHERE issues_reported='Brakes'";   
        }elseif(
    $_POST['value'] == 'HVAC') { 
            
    // query to get all HVAC records   
            
    $query "SELECT * FROM servifce_info WHERE issues_reported='HVAC'";   
        }elseif(
    $_POST['value'] == 'Lighting') { 
            
    // query to get all Lighting records   
            
    $query "SELECT * FROM servifce_info WHERE issues_reported='Lighting'";   
        }elseif(
    $_POST['value'] == 'Accident Damage') { 
            
    // query to get all Accident Damage records   
            
    $query "SELECT * FROM servifce_info WHERE issues_reported='Accident Damage'";   
        } else {   
            
    // query to get all records   
            
    $query "SELECT * FROM servifce_info ";   
        }   
    mysql_close();

    ?> 
    <html> 
    <head></head> 
    <body> 
    <form action='<?php echo $_SERVER['PHP_SELF']; ?>' method='post' name='form_filter' >  
        <select name="value">  
            <option value="all">All</option>  
            <option value="Engine">Engine</option>  
            <option value="Transmission">Transmission</option>  
            <option value="Differential">Differential</option>     
            <option value="Electrical">Electrical</option>  
            <option value="Tires">Tires</option>  
            <option value="Brakes">Brakes</option>  
            <option value="HVAC">HVAC</option>  
            <option value="Lighting">Lighting</option>  
            <option value="Accident">Accident</option>  
    </select>  
        <br />  
        <input type='submit' value = 'Filter'>  
    </form> 
    <div id="nav">
    <ul>
        <li><a href="order_vehicle_name.php" title=""> ORDER BY VEHICLE NAME</a></li>
        <li><a href="order_vehicle_number.php" title=""> ORDER BY VEHICLE NUMBER</a></li>
        <li><a href="order_location.php" title=""> ORDER BY LOCATION</a></li>
        <li><a href="order_status.php" title=""> ORDER BY STATUS</a></li>
        <li><a href="order_issues_reported.php" title=""> ORDER REPORTED ISSUES</a></li>
        <li><a href="order_id.php" title=""> ORDER BY ID</a></li>
        <li><a href="index.php">LOG OUT</a></li>
    </ul>
    </div>
    <table border="1" cellspacing="5" cellpadding="5">
    <tr>
    <th><font face="Arial, Helvetica, sans-serif">ID</font></th>
    <th><font face="Arial, Helvetica, sans-serif">Vehicle Name</font></th>
    <th><font face="Arial, Helvetica, sans-serif">Vehicle Number</font></th>
    <th><font face="Arial, Helvetica, sans-serif">Location</font></th>
    <th><font face="Arial, Helvetica, sans-serif">Status</font></th>
    <th><font face="Arial, Helvetica, sans-serif">RTS</font></th>
    <th><font face="Arial, Helvetica, sans-serif">Odometer Date</font></th>
    <th><font face="Arial, Helvetica, sans-serif">Odometer Reading Date</font></th>
    <th><font face="Arial, Helvetica, sans-serif">Date of next scheduled maintenance</font></th>
    <th><font face="Arial, Helvetica, sans-serif">Maintenance/Repair Issues Reported</font></th>
    <th><font face="Arial, Helvetica, sans-serif">Date Issues Reported</font></th>
    <th><font face="Arial, Helvetica, sans-serif">Scheduled Service Date Issues Reported</font></th>
    <th><font face="Arial, Helvetica, sans-serif">Repair Service Performed W/Comments</font></th>
    <th><font face="Arial, Helvetica, sans-serif">Date Service Performed</font></th>
    <th><font face="Arial, Helvetica, sans-serif">Date OF Follow-up</font></th>
    <th><font face="Arial, Helvetica, sans-serif">Service In Progress 0=NO 1=YES</font></th>
    <th><font face="Arial, Helvetica, sans-serif">Date Return To Use</font></th>
    <th><font face="Arial, Helvetica, sans-serif">Time Return Use</font></th>
    <th><font face="Arial, Helvetica, sans-serif">Nonrepaiable Issues Found W/Comments</font></th>
    <th><font face="Arial, Helvetica, sans-serif">Date Issues Found</font></th>
    <th><font face="Arial, Helvetica, sans-serif">Parts Cost</font></th>
    <th><font face="Arial, Helvetica, sans-serif">Hours Worked</font></th>
    <th><font face="Arial, Helvetica, sans-serif">Comments</font></th>
    <th><font face="Arial, Helvetica, sans-serif">Update</font></th>
    </tr>

    <?php
    while($row mysql_fetch_array($result)) {
        
    ?>
        <tr>
        <td><font face="Arial, Helvetica, sans-serif"><?php echo $row['id']; ?></font></td>
        <td><font face="Arial, Helvetica, sans-serif"><?php echo $row['name']; ?></font></td>
        <td><font face="Arial, Helvetica, sans-serif"><?php echo $row['number']; ?></font></td>
        <td><font face="Arial, Helvetica, sans-serif"><?php echo $row['location']; ?></font></td>
        <td><font face="Arial, Helvetica, sans-serif"><?php echo $row['status']; ?></font></td>
        <td><font face="Arial, Helvetica, sans-serif"><?php echo $row['rts']; ?></font></td>
        <td><font face="Arial, Helvetica, sans-serif"><?php echo $row['odomread']; ?></font></td>
        <td><font face="Arial, Helvetica, sans-serif"><?php echo $row['odomdate']; ?></font></td>
        <td><font face="Arial, Helvetica, sans-serif"><?php echo $row['date_next_maint']; ?></font></td>
        <td><font face="Arial, Helvetica, sans-serif"><?php echo $row['issues_reported']; ?></font></td>
        <td><font face="Arial, Helvetica, sans-serif"><?php echo $row['date_reported']; ?></font></td>
        <td><font face="Arial, Helvetica, sans-serif"><?php echo $row['scheduled_service_date']; ?></font></td>
        <td><font face="Arial, Helvetica, sans-serif"><?php echo $row['service_performed']; ?></font></td>
        <td><font face="Arial, Helvetica, sans-serif"><?php echo $row['date_service_performed']; ?></font></td>
        <td><font face="Arial, Helvetica, sans-serif"><?php echo $row['date_of_followup']; ?></font></td>
        <td><font face="Arial, Helvetica, sans-serif"><?php echo $row['service_in_progress']; ?></font></td>
        <td><font face="Arial, Helvetica, sans-serif"><?php echo $row['date_return_use']; ?></font></td>
        <td><font face="Arial, Helvetica, sans-serif"><?php echo $row['time_return_use']; ?></font></td>
        <td><font face="Arial, Helvetica, sans-serif"><?php echo $row['issues_nonrepairable']; ?></font></td>
        <td><font face="Arial, Helvetica, sans-serif"><?php echo $row['date_nonrepairable_issues']; ?></font></td>
        <td><font face="Arial, Helvetica, sans-serif"><?php echo $row['parts_cost']; ?></font></td>
        <td><font face="Arial, Helvetica, sans-serif"><?php echo $row['hours']; ?></font></td>
        <td><font face="Arial, Helvetica, sans-serif"><?php echo $row['comments']; ?></font></td>
        <td><a href="maint_update.php?id=<?php echo $row['id']; ?>">update</a></td>
        </tr>
        <?php
    }
    ?>
    <?php
     error_reporting
    (E_ALL);
    ?>
    </body>
    </html>
    Here is update page maint_update

    PHP Code:
    <?php require_once("dbcon.php"); ?>
    <?php 
    require_once("functions.php"); ?>
    <?php
    // get value of id that sent from address bar
    $id=$_GET['id'];
    $_SESSION['id'] = $id;

    // Retrieve data from database 
    $sql="SELECT * FROM service_info WHERE id='$id'";
    $result=mysql_query($sql);
    $rows=mysql_fetch_array($result);
    ?>

    <html>
    <body>
    <h1>Maintenace Report  </h1>
        <section>
           <section>
             <form method="post" name="form1" action="updated_maint.php">
               <table align="center">
                   <tr valign="baseline">
                   <th nowrap align="right">Date of next scheduled maintenance:</th>
                  <td>
                     <input type="text" name="date_next_maint" value="" size="32">
                 </tr>
                 <tr valign="baseline">
                   <th nowrap align="right">Date That Maintenace/Repair Issues Reported:</th>
                  <td>
                  <input type="text" name="date_reported" value="" size="32">
                 </tr>
                 <tr valign="baseline">
                   <th nowrap align="right">Scheduled Service Date That Maintenace/Repair Issues Reported:</th>
                  <td>
                     <input type="text" name="scheduled_service_date" value="" size="32">
                 </tr>
                 <tr valign="baseline">
                   <th nowrap align="right">Maintenace/Repair Service Performed W/Comments:</th>
                  <td>
                    <textarea name="service_performed" rows="3" cols="27"></textarea>
                 </tr>
                 <tr valign="baseline">
                   <th nowrap align="right">Date Maintenace/Repair Service Performed:</th>
                   <td><input type="text" name="date_service_performed" value="" size="32"></td>
                 </tr>
                 <tr valign="baseline">
                   <th nowrap align="right">Date OF Follow-up Work / If Needed:</th>
                  <td>
                     <input type="text" name="date_of_followup" value="" size="32">
                 </tr>
                 <tr valign="baseline">
                   <th nowrap align="right">Service In Progress:</th>
                  <td>
                     <input type="radio" name="service_in_progress" value="0" /> No
                        &nbsp;
                        <input type="radio" name="service_in_progress" value="1" /> Yes
                 </tr>
                 <tr valign="baseline">
                   <th nowrap align="right">Date Return To Use:</th>
                  <td>
                     <input type="text" name="date_return_use" value="" size="32">
                 </tr>
                 <tr valign="baseline">
                   <th nowrap align="right">Time Return Use:</th>
                  <td>
                     <input type="text" name="time_return_use" value="" size="32">
                 </tr>
                 <tr valign="baseline">
                   <th nowrap align="right">Nonrepaiable Issues Found W/Comments:</th>
                  <td>
                    <textarea name="issues_nonrepairable" rows="3" cols="27"></textarea>
                 </tr>
                 <tr valign="baseline">
                   <th nowrap align="right">Date Nonrepaiable Issues Found:</th>
                  <td>
                     <input type="text" name="date_nonrepairable_issues" value="" size="32">
                 </tr>
                 <tr valign="baseline">
                   <th nowrap align="right">Comments:</th>
                  <td>
                    <textarea name="comments" rows="3" cols="27"></textarea>
                 </tr>
                 <input type="hidden" name="id" value = "$id" /> 
                 <tr valign="baseline">
                   <td nowrap align="right">&nbsp;</td>
                   <td><input type="submit" value="Insert record"></td>
                 </tr>
               </table>
               <input type="hidden" name="MM_insert" value="form1">
             </form>
             <a href="service_list_update.php">Cancel</a>
             <p>&nbsp;</p>
           </section>
      <!-- end .content --></h2>
        </section>
    </body>
    </html>
    Here is update file updated_maint

    PHP Code:
    <?php session_start();?>
    <?php 
    require_once("dbcon.php"); ?>
    <?php 
    require_once("functions.php"); ?>
    <?php
        $id 
    $_SESSION['id'];
        
    $date_next_maint mysql_prep($_POST['date_next_maint']);
        
    $date_reported mysql_prep($_POST['date_reported']);
        
    $scheduled_service_date mysql_prep($_POST['scheduled_service_date']);
        
    $service_performed mysql_prep($_POST['service_performed']);
        
    $date_service_performed mysql_prep($_POST['date_service_performed']);
        
    $date_of_followup mysql_prep($_POST['date_of_followup']);
        
    $service_in_progress mysql_prep($_POST['service_in_progress']);
        
    $date_return_use mysql_prep($_POST['date_return_use']);
        
    $time_return_use mysql_prep($_POST['time_return_use']);
        
    $issues_nonrepairable mysql_prep($_POST['issues_nonrepairable']);
        
    $date_nonrepairable_issues mysql_prep($_POST['date_nonrepairable_issues']);
        
    $comments mysql_prep($_POST['comments']);
    ?>
    <?php
        $query 
    "INSERT INTO service_info `date_next_maint`='$date_next_maint', `date_reported`='$date_reported',
        `scheduled_service_date`='$scheduled_service_date', `service_performed`='$service_performed', `date_service_performed`='$date_service_performed', 
        `date_of_followup`='$date_of_followup',`service_in_progress`='$service_in_progress', `date_return_use`='$date_return_use', `time_return_use`='$time_return_use', 
        `issues_nonrepairable`='$issues_nonrepairable', `date_nonrepairable_issues`='$date_nonrepairable_issues', `comments` ='$comments'
        WHERE id=$id"
    ;
        
        
    $result mysql_query($query$connection);
        if (
    $result) {
            
    // Success!
            
    redirect_to("service_list_update.php");
        } else {
            
    // Display error message.
            
    echo "<p>Maintenance Info Creation Failed.</p>";
            echo 
    "<p>" mysql_error() . "</p>";
        }
        echo 
    "<p>Error: " mysql_error() . " SQL: $query</p>";
    ?>
    <?php
    ini_set
    ('display_errors',1); 
     
    error_reporting(E_ALL);
    ?>

  10. #23
    Senior Coder
    Join Date
    Feb 2011
    Location
    Your Monitor
    Posts
    4,091
    Thanks
    51
    Thanked 506 Times in 493 Posts
    Quote Originally Posted by flashbang_pro View Post
    so not I am trying INSERT INTO service_info WHERE id=$id
    Insert doesn't allow the user of a where clause. Insert just takes the columns and data to go into them.

    where can only be used for select, update and delete.

    Change that insert into back into update.
    My helpful sig is on vacation trying to loose some weight. It got a bit fat and caused a few problems but it will be back at some point!

  11. Users who have thanked tangoforce for this post:

    flashbang_pro (08-28-2012)

  12. #24
    New Coder
    Join Date
    May 2011
    Posts
    21
    Thanks
    12
    Thanked 0 Times in 0 Posts
    I switched back to UPDATE and now still having this error

    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 5

    Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 5 SQL: UPDATE service_info SET `date_next_maint`='testing', `date_reported`='testing', `scheduled_service_date`='testing', `service_performed`='', `date_service_performed`='testing', `date_of_followup`='',`service_in_progress`='', `date_return_use`='', `time_return_use`='', `issues_nonrepairable`='', `date_nonrepairable_issues`='', `comments` ='' WHERE id=

  13. #25
    Senior Coder
    Join Date
    Feb 2011
    Location
    Your Monitor
    Posts
    4,091
    Thanks
    51
    Thanked 506 Times in 493 Posts
    WHERE id=$id ";

    Should be

    WHERE id='$id' ";

    Note the single quotes.
    My helpful sig is on vacation trying to loose some weight. It got a bit fat and caused a few problems but it will be back at some point!

  14. #26
    New Coder
    Join Date
    May 2011
    Posts
    21
    Thanks
    12
    Thanked 0 Times in 0 Posts
    Hmmmm...Ok I'm baffled, I understand now where I forgot the single quotes and I fixed that but now I get no errors, but no data has been updated either.

  15. #27
    Senior Coder
    Join Date
    Feb 2011
    Location
    Your Monitor
    Posts
    4,091
    Thanks
    51
    Thanked 506 Times in 493 Posts
    In that case, you need to print the entire query to the browser and then run it through phpmyadmin to see what happens.
    My helpful sig is on vacation trying to loose some weight. It got a bit fat and caused a few problems but it will be back at some point!

  16. #28
    New Coder
    Join Date
    May 2011
    Posts
    21
    Thanks
    12
    Thanked 0 Times in 0 Posts
    How do I do that?

  17. #29
    New Coder
    Join Date
    May 2011
    Posts
    21
    Thanks
    12
    Thanked 0 Times in 0 Posts
    Just a SELECT statement?

  18. #30
    Senior Coder
    Join Date
    Feb 2011
    Location
    Your Monitor
    Posts
    4,091
    Thanks
    51
    Thanked 506 Times in 493 Posts
    PHP Code:
    $query "update service_info `date_next_maint`='$date_next_maint', `date_reported`='$date_reported',
        `scheduled_service_date`='$scheduled_service_date', `service_performed`='$service_performed', `date_service_performed`='$date_service_performed', `date_of_followup`='$date_of_followup',`service_in_progress`='$service_in_progress', `date_return_use`='$date_return_use', `time_return_use`='$time_return_use', 
        `issues_nonrepairable`='$issues_nonrepairable', `date_nonrepairable_issues`='$date_nonrepairable_issues', `comments` ='$comments'
        WHERE id='$id'"
    ;

    print 
    $query// This is what I meant by 'print your query' 
    Then in your browser, highlight the query, right click, click copy.

    Then go into phpmyadmin*.

    Then click your database.

    Then click the SQL page

    Then put the cursor in the box

    Then right click and select paste

    Then click go.



    * Or other mysql explorer / editing program you may have in your admin tools in your control panel.
    My helpful sig is on vacation trying to loose some weight. It got a bit fat and caused a few problems but it will be back at some point!


 
Page 2 of 3 FirstFirst 123 LastLast

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •