Results 1 to 5 of 5

Thread: There are two mysql errors in my code

  1. #1
    Join Date
    Oct 2004
    Posts
    425
    Thanks
    4
    Thanked 1 Time in 1 Post

    Default There are two mysql errors in my code

    There are two mysql errors in my code (how to debug?) when I go to get quote at http://www.poliscarhire.com/ errors at
    http://www.poliscarhire.com/customer...ing-review.php

    first error line 725
    Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /home/content/p/o/l/polisch123/html/customeradmin/booking-review.php:7) in /home/content/p/o/l/polisch123/html/customeradmin/booking-review.php on line 725

    Code:
    725  session_start();
        $_SESSION['datep']=$_POST['datep'];
        $_SESSION['dated']=$_POST['dated'];
        $_SESSION['Locationp']=$_POST['Locationp'];
        $_SESSION['Locationd']=$_POST['Locationd'];
        $_SESSION['days']=$_POST['days'];
        $_SESSION['off']=$_POST['off'];
        $_SESSION['mostdaysrate']=$_POST['mostdaysrate'];		
        $_SESSION['finalprice']=$_POST['finalprice'];
        $_SESSION['cat']=$_POST['cat'];	
    	$cat = $_SESSION['cat'];

    second error line 811
    Warning: mysql_result() [function.mysql-result]: Unable to jump to row 0 on MySQL result index 3 in /home/content/p/o/l/polisch123/html/customeradmin/booking-review.php on line 811

    Warning: mysql_result() [function.mysql-result]: Unable to jump to row 0 on MySQL result index 3 in /home/content/p/o/l/polisch123/html/customeradmin/booking-review.php on line 812

    Warning: mysql_result() [function.mysql-result]: Unable to jump to row 0 on MySQL result index 3 in /home/content/p/o/l/polisch123/html/customeradmin/booking-review.php on line 813

    Warning: mysql_result() [function.mysql-result]: Unable to jump to row 0 on MySQL result index 3 in /home/content/p/o/l/polisch123/html/customeradmin/booking-review.php on line 814

    Warning: mysql_result() [function.mysql-result]: Unable to jump to row 0 on MySQL result index 3 in /home/content/p/o/l/polisch123/html/customeradmin/booking-review.php on line 815

    Warning: mysql_result() [function.mysql-result]: Unable to jump to row 0 on MySQL result index 3 in /home/content/p/o/l/polisch123/html/customeradmin/booking-review.php on line 816

    Warning: mysql_result() [function.mysql-result]: Unable to jump to row 0 on MySQL result index 3 in /home/content/p/o/l/polisch123/html/customeradmin/booking-review.php on line 817

    Warning: mysql_result() [function.mysql-result]: Unable to jump to row 0 on MySQL result index 3 in /home/content/p/o/l/polisch123/html/customeradmin/booking-review.php on line 818

    Warning: mysql_result() [function.mysql-result]: Unable to jump to row 0 on MySQL result index 3 in /home/content/p/o/l/polisch123/html/customeradmin/booking-review.php on line 819

    Warning: mysql_result() [function.mysql-result]: Unable to jump to row 0 on MySQL result index 3 in /home/content/p/o/l/polisch123/html/customeradmin/booking-review.php on line 820

    Warning: mysql_result() [function.mysql-result]: Unable to jump to row 0 on MySQL result index 3 in /home/content/p/o/l/polisch123/html/customeradmin/booking-review.php on line 821

    Warning: mysql_result() [function.mysql-result]: Unable to jump to row 0 on MySQL result index 3 in /home/content/p/o/l/polisch123/html/customeradmin/booking-review.php on line 822

    Warning: mysql_result() [function.mysql-result]: Unable to jump to row 0 on MySQL result index 3 in /home/content/p/o/l/polisch123/html/customeradmin/booking-review.php on line 823

    Warning: mysql_result() [function.mysql-result]: Unable to jump to row 0 on MySQL result index 3 in /home/content/p/o/l/polisch123/html/customeradmin/booking-review.php on line 824

    Warning: mysql_result() [function.mysql-result]: Unable to jump to row 0 on MySQL result index 3 in /home/content/p/o/l/polisch123/html/customeradmin/booking-review.php on line 825

    Code:
    811 $model = mysql_result($result,0,"model");
    $type = mysql_result($result,0,"type");
    $transm = mysql_result($result,0,"transm");
    $cc = mysql_result($result,0,"cc");
    $fuel = mysql_result($result,0,"fuel");
    $doors = mysql_result($result,0,"doors");
    $people = mysql_result($result,0,"people");
    $suitcases = mysql_result($result,0,"suitcases");
    $description = mysql_result($result,0,"description");
    $availability = mysql_result($result,0,"availability");
    $img_small = mysql_result($result,0,"img_small");
    $img_big = mysql_result($result,0,"img_big");
    $special_offer = mysql_result($result,0,"special_offer");
    $discount = mysql_result($result,0,"discount");
    $notes = mysql_result($result,0,"notes");
    				?>

  2. #2
    Join Date
    Oct 2006
    Posts
    183
    Thanks
    0
    Thanked 11 Times in 11 Posts

    Default

    Could you post line 7 from the first error?

    Also, could you post the query and the $result variable for the second error, as well as any variables involved in the query?

  3. #3
    Join Date
    Oct 2004
    Posts
    425
    Thanks
    4
    Thanked 1 Time in 1 Post

    Default

    For a query that results in only one entry(row), how reference differ fields ? problem second fixed-no definition of 'cat' var. well please tell me for first error ?

    Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /home/content/p/o/l/polisch123/html/customeradmin/booking-review.php:7) in /home/content/p/o/l/polisch123/html/customeradmin/booking-review.php on line 725

    may have two or more session_start(); ?

    Also a new problem from the quote you get [on the left] of http://www.poliscarhire.com/
    to the mysql repeat region, repeat buttons 2-6 do not work[js] the other 1, 7-16 buttons work properly, why this error ? is not a repeat ?

    ----------------------------------------------
    line 7: I do not think this is the problem ?

    Code:
    <link rel="shortcut icon" href="favicon.ico" />
    <!-- InstanceBeginEditable name="doctitle" -->
    <title>Booking Review prior Sent</title>
    line 7:<!-- InstanceEndEditable -->
    <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
    <!-- InstanceBeginEditable name="head" -->
    <style type="text/css">
    <!--
    .style1 {font-weight: bold}
    -->
    </style>
    <!-- InstanceEndEditable -->
    Code:
                <?php     $_SESSION['cat']=$_POST['cat'];	
    	$cat = $_SESSION['cat'];
    ?>....
    ........
             <?php 
    // --------------------------------------------------------------------------------
    include("../dbinfo.php");
    $linkid = mysql_connect($hostname,$username,$password);
    @mysql_select_db($database) or die( "Unable to select database");   // @
    // Base query 
    $query ='';
    $query = "SELECT * FROM $CarsTable WHERE cat='$cat'";  
    $result = @mysql_query($query,$linkid);
    				$model = mysql_result($result,0,"model");
    				$type = mysql_result($result,0,"type");
    				$transm = mysql_result($result,0,"transm");
    				$cc = mysql_result($result,0,"cc");
    				$fuel = mysql_result($result,0,"fuel");
    				$doors = mysql_result($result,0,"doors");
    				$people = mysql_result($result,0,"people");
    				$suitcases = mysql_result($result,0,"suitcases");
    			$description = mysql_result($result,0,"description");
    				$availability = mysql_result($result,0,"availability");
    				$img_small = mysql_result($result,0,"img_small");
    				$img_big = mysql_result($result,0,"img_big");
    			$special_offer = mysql_result($result,0,"special_offer");
    				$discount = mysql_result($result,0,"discount");
    				$notes = mysql_result($result,0,"notes");
    				?>

  4. #4
    Join Date
    Oct 2004
    Posts
    425
    Thanks
    4
    Thanked 1 Time in 1 Post

    Default form1's submit button work but form2's not work,why[total 16 buttons] ?

    form1's submit button work but form2's not work,why[total 16 buttons] ?

    Code:
    <td align="center" valign="middle"><form action="../customeradmin/booking-review.php" method="post" enctype="application/x-www-form-urlencoded" name="form1" target="_self">
          <input type="hidden" name="datep" value="10:00 Friday August 22nd, 2008">            
          <input type="hidden" name="dated" value="10:00 Sunday August 31st, 2008">
                <input type="hidden" name="Locationp" value="Polis Office">
                <input type="hidden" name="Locationd" value="Polis Office">
                <input type="hidden" name="days" value="9">
                <input type="hidden" name="mostdaysrate" value="28">
                <input type="hidden" name="off" value="50.4">
                <input type="hidden" name="cat" value="B1">
                <input type="hidden" name="finalprice" value="231.84">
                <input type="hidden" name="car" value="Group B1-Hyundai Atoz or similar">
    <a href="javascript:form1.submit()"><img src="../images/but_bookit.gif" width="80" height="22" border="0"></a>
        </form></td>
      </tr>
    </table>
    </fieldset>		
    		</td></tr>
    		<tr><td><hr size="3" /></td></tr>
    <link href="/css-styles.css" rel="stylesheet" type="text/css">
    <style type="text/css">
    <!--
    .style2 {color: #000000}
    .style4 {color: #006699}
    .style5 {color: #006600}
    -->
    </style>
    				
    
    		<tr><td><fieldset><legend>Subcompact</legend><table width="580" border="0" cellpadding="5" cellspacing="0" class="menutext" summary="quote result table cell">
      <tr>
        <td width="132" rowspan="2">&nbsp;</td>
        <td width="298">&nbsp;</td>
        <td width="120">&nbsp;</td>
      </tr>
      <tr>
        <td rowspan="3" align="center" valign="middle"><table width="104%"  border="0" cellpadding="1" cellspacing="0" class="menutext" summary="characteristics table of car for rent">
          <tr>
            <td width="32%" align="left" valign="middle"><span class="style4"> model </span></td>
            <td width="68%" align="left" valign="middle"><span class="style2">
              Opel Corsa or Toyota Yaris        </span></td>
          </tr>
          <tr>
            <td align="left" valign="middle"><span class="style4">people/door</span></td>
            <td align="left" valign="middle"><span class="style2">
              5          &nbsp;/&nbsp;
              3</span></td>
          </tr>
          <tr>
            <td align="left" valign="middle"><span class="style4"> trans </span></td>
            <td align="left" valign="middle"><span class="style2">
              manual        </span></td>
          </tr>
          <tr>
            <td align="left" valign="middle"><span class="style4"> size/fuel</span></td>
            <td align="left" valign="middle"><span class="style2">
              1000cc
    &nbsp;/&nbsp;
    Petrol</span></td>
          </tr>
          <tr>
            <td align="left" valign="middle"><span class="style4"> luggage </span></td>
            <td align="left" valign="middle"><span class="style2">
              2 small        </span></td>
          </tr>
          <tr>
            <td align="left" valign="middle"><span class="style4"> status </span></td>
            <td align="left" valign="middle"><span class="style2">
            Available</span></td>
          </tr>
          <tr>
            <td>&nbsp;</td>
            <td>&nbsp;</td>
          </tr>
        </table></td>
        <td rowspan="2" align="center" valign="middle"><p>&nbsp;<span class="text_normal20pxbold">
          32.5    </span>/day
              </p>
          <p>&nbsp;<span class="style4">total&nbsp;
                269.1      </span>            <br>
                &nbsp;<span class="style5">save&nbsp;
                58.5&nbsp;&nbsp;20% OFF
            </span></p>      </td>
      </tr>
      <tr>
        <td height="38" align="center" valign="middle"><img src="/images/cars/b2_toyota_yaris.jpg" alt="Opel Corsa or Toyota Yaris" border="1" /></td>
        </tr>
      <tr>
        <td height="65" align="center" valign="middle"><p>Group&nbsp;
              B2    </p>
          <p>
              
            </p></td>
        <td align="center" valign="middle"><form action="../customeradmin/booking-review.php" method="post" enctype="application/x-www-form-urlencoded" name="form2" target="_self">
          <input type="hidden" name="datep" value="10:00 Friday August 22nd, 2008">            
          <input type="hidden" name="dated" value="10:00 Sunday August 31st, 2008">
                <input type="hidden" name="Locationp" value="Polis Office">
                <input type="hidden" name="Locationd" value="Polis Office">
                <input type="hidden" name="days" value="9">
                <input type="hidden" name="mostdaysrate" value="32.5">
                <input type="hidden" name="off" value="58.5">
                <input type="hidden" name="cat" value="B2">
                <input type="hidden" name="finalprice" value="269.1">
                <input type="hidden" name="car" value="Group B2-Opel Corsa or Toyota Yaris">
    <a href="javascript:form2.submit()"><img src="../images/but_bookit.gif" width="80" height="22" border="0"></a>
        </form></td>
      </tr>
    </table>
    Last edited by leonidassavvides; 08-29-2008 at 11:34 AM. Reason: add

  5. #5
    Join Date
    Oct 2004
    Posts
    425
    Thanks
    4
    Thanked 1 Time in 1 Post

    Default

    Answer and this: a php session var an be reinitialized directly[re-asign a value to it] or it must virst unset ? required the unset ?

Bookmarks

Posting Permissions

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