Page 1 of 1

Select query not working????

Posted: Tue Oct 21, 2008 3:19 pm
by zed420
Hi ALL
Can someone please tell me why isn't my select query working properly, there are NO errors but its bringing out all the records even those are NOT user_id = id.
Same query I'm checking it with phpMyAdmin and it works like charm.Its been three whole days can some take me out of this misery.

Thanks
Zed

Code: Select all

function validation(){
 
$job_id = $_POST['job_id'];
$user_id = $_POST['user_id'];
$typeOfcustomer = $_POST['typeOfcustomer'];
$typeOfvehicle = $_POST['typeOfvehicle'];
$noOfVehicle = $_POST['noOfVehicle'];
$regul = $_POST['regul'];
$cust_name = $_POST['cust_name'];
$cust_address = $_POST['cust_address'];
$post_code = $_POST['post_code'];
$cust_tel = $_POST['cust_tel'];
$des = $_POST['des'];
$dateDay = $_POST['dateDay'];
$dateMO = $_POST['dateMO'];
$dateYr = $_POST['dateYr'];
$timeHr = $_POST['timeHr'];
$timeMin = $_POST['timeMin'];
 
$query = "INSERT INTO blockbook  VALUES
(NULL,'$user_id','$typeOfcustomer',
'$typeOfvehicle','$noOfVehicle','$regul','$cust_name','$cust_address','$post_code','$cust_tel',
'$des','$dateDay','$dateMO','$dateYr','$timeHr','$timeMin')";
 
   $result = mysql_query($query)or die(mysql_error());
 ?>  
 
/*****************************************************************************************/
 
$query2 = "SELECT * FROM blockbook, user WHERE  blockbook.user_id = user.id ";
   $result2 = mysql_query($query2)or die(mysql_error());
?>
<div class="smallerText">
<TABLE BORDER=0 WIDTH=100% CELLSPACING=3 CELLPADDING=3 ALIGN=CENTER bgcolor="#99CC99">
<TR ALIGN=CENTER bgcolor="#CCFF66">
<td><font color=red><b>C/A</b></font></TD>
<td><font color=red><b>JN</b></font></TD>
<td ><font color=red><b>TOC</b></font></TD>
<td ><font color=red><b>TOV</b></font></TD>
<td ><font color=red><b>NOV</b></font></TD>
<td ><font color=red><b>Regu</b></font></TD>
<td ><font color=red><b>Multi Days Book</b></font></TD>
<td ><font color=red><b>Cust Name</b></font></TD>
<td ><font color=red><b>Pick Address</b></font></TD>
<td ><font color=red><b>Destination</b></font></TD>
<td ><font color=red><b>Tel</b></font></TD>
<td ><font color=red><b>WR</b></font></TD>
<td ><font color=red><b>Date</b></font></TD>
<td ><font color=red><b>Time</b></font></TD>
<td ><font color=red><b>Comments</b></font></td>
</tr>
<?
    while ($row = mysql_fetch_array($result2))  {
    extract($row);
        echo "<tr align=center>
        <td>" . $row['user_id'] . "</td>
        <td>" . $row['job_id'] . "</td>
        <td>" . $row['typeOfcustomer'] . "</td>
        <td>" . $row['typeOfvehicle'] . "</td>
        <td>" . $row['noOfVehicle'] . "</td>
        <td>" . $row['regul'] . "</td>
        <td>" . $row['mon'] . "," . $row['tue'] . "," . $row['wed'] . ",
        " . $row['thur'] . "," . $row['fri'] . "," . $row['sat'] . ",
        " . $row['sun'] . "</td>
        <td>" . $row['cust_name'] . "</td>
        <td>" . $row['cust_address'] . "</a></td>
        <td>" . $row['des'] . "</td>
        <td>" . $row['cust_tel'] . "</td>
        <td>" . $row['reqVehicle'] . "</td>
        <td>" . $row['dateDay'] . "/" . $row['dateMO'] . "/" . $row['dateYr'] . "</td>
        <td>" . $row['timeHr'] . ":" . $row['timeMin'] . "</td>
        <td>" . $row['comment'] . "</td>
        </tr>";
    }
?></table></div><?
}
/*****************************************************************************************/
function blockBook(){
?>
 
<center>
  <h1>Block Bookings facility is only available for registered customers 
  and Account holders. </h1>
</center>
<div class="smallerText2">
 
<form name="blockbook" method="post" action="<?php echo $PHP_SELF ?>">
<table width="100%" border="0" cellspacing="1" cellpadding="0">
  <tr>
    <td></td>
    <td><input name="Job_id" type="hidden" id="id" size="40" /></td>
  </tr>
  <tr>
    <td width="13%">User ID</td>
    <td width="14%"><input name="user_id" type="text" id="user_id" size="7" /></td>
    <td width="6%">Date:</td>
    <td width="22%"><?php
/********************************   Dropdown box for Date  ******************/
 
  $today = Time();                     //stores today's date
  $f_today = date("d-M-Y",$today);     //formats today's date
 
   echo "<div align='center'>\n"; 
  echo "<div align='center'>\n"; 
 
  /* create form containing date selection list */
  //echo "<form action='processform.php' method='post'>\n";
 
  /* build selection list for the day */
  $todayDay= date("d",$today);    //get the day from $today
  echo "<select name='dateDay' > \n";
  for ($n=1;$n<=31;$n++)  
  {
    echo " <option value=$n";
    if ($todayDay == $n ) 
    {
      echo " selected";
    }
    echo "> $n\n";
  }
  echo "</select>";
 
  /* create an array of months*/
  $monthName = array(1=> "January", "February", "March", "April",
                         "May", "June", "July", "August",
                         "September", "October", "November",
                         "December");
 
  /* build selection list for the month */
  $todayMO = date("m",$today);             //get the month from $today
  echo "<select name='dateMO' >\n";
  for ($n=1;$n<=12;$n++) 
  {
    echo "<option value=$n\n";
    if ($todayMO == $n)
    {
      echo " selected";
    }
    echo "> $monthName[$n]\n";
  }
  echo "</select>";
 
  /* build selection list for the year */
  $startYr = date("Y", $today);         //get the year from $today
  echo "<select name='dateYr' >\n";
  for ($n=$startYr;$n<=$startYr+5;$n++)
  {
    echo " <option value=$n";
    if ($startYr == $n )
    {
      echo " selected";
    }
    echo "> $n\n";
  }
  echo "</select>\n";
?></td>
    <td width="13%">Name:</td>
    <td width="32%"><input name="cust_name" type="text" id="cust_name" size="40" /></td>
  </tr>
  <tr>
    <td>Type of Customer:</td>
    <td><select name="typeOfcustomer" onchange="accountCust('parent',this,0)">
      <option value="cash"  selected="selected">Cash</option>
      <option value="authAc.php">Account</option>
    </select></td>
    <td>Time</td>
    <td> Hr <select  name="timeHr"  > 
    <option>00</option>
    <option>01</option>
    <option>02</option>
    <option>03</option>
    <option>04</option>
    <option>05</option>
    <option>06</option>
    <option>07</option>
    <option>08</option>
    <option>09</option>
    <option>10</option>
    <option>11</option>
    <option>12</option>
    <option>13</option>
    <option>14</option>
    <option>15</option>
    <option>16</option>
    <option>17</option>
    <option>18</option>
    <option>19</option>
    <option>20</option>
    <option>21</option>
    <option>22</option>
    <option>23</option>
  </select>
 Min <select name="timeMin" >
    <option>00</option>
    <option>05</option>
    <option>10</option>
    <option>15</option>
    <option>20</option>
    <option>25</option>
    <option>30</option>
    <option>35</option>
    <option>40</option>
    <option>45</option>
    <option>50</option>
    <option>55</option>
  </select></td>
    <td>Pick up Address:</td>
    <td><input name="cust_address" type="text" id="cust_address" size="50" /></td>
  </tr>
  <tr>
    <td>Type of Vehicle Req:</td>
    <td><select name="typeOfvehicle" >
      <option value="4Seater">4 Seater Vehicle</option>
      <option value="7Seater">7 Seater Vehicle</option>
    </select></td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>Post Code:</td>
    <td><input name="cust_postCode" type="text" id="cust_postCode" size="15" /></td>
  </tr>
  <tr>
    <td>No. of Vehicles Req:</td>
    <td><select name="noOfVehicle" >
      <option value="1" selected="selected">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>
    </select></td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>Tel / Mobile:</td>
    <td><input name="cust_tel" type="text" id="cust_tel" size="20" /></td>
    <tr>
    <td>Booking Regularity:</td>
    <td><select name="regul" >
      <option value="0" selected="selected">Select</option>
      <option value="once">Once</option>
      <option value="daily">Daily</option>
      <option value="weekly">Weekly</option>
      <option value="monthly">Monthly</option>
    </select></td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>Destination:</td>
    <td><input name="des" type="text" id="des" size="50" /></td>
</tr>
</table>
 
<hr>
  <tr>
  <td>
       <input name="submit" type="submit" value="Submit" />
  </td>
  <td>
        <input name="reset" type="reset" value="Reset" />
   </td></form>
</tr></div>
<?
}
if (! isset($_POST['submit'])){
    blockBook();
}else{
    validation();
}   
?>
 
 
 

Re: Select query not working????

Posted: Tue Oct 21, 2008 3:32 pm
by requinix
zed420 wrote:but its bringing out all the records even those are NOT user_id = id.

Code: Select all

$query2 = "SELECT * FROM blockbook, user WHERE &nbsp;blockbook.user_id = user.id ";
I don't see any user_id = id in there, just a relationship between two tables.

Re: Select query not working????

Posted: Tue Oct 21, 2008 3:43 pm
by zed420
tasairis wrote:
zed420 wrote:but its bringing out all the records even those are NOT user_id = id.

Code: Select all

$query2 = "SELECT * FROM blockbook, user WHERE &nbsp;blockbook.user_id = user.id ";
I don't see any user_id = id in there, just a relationship between two tables.
Thanks tasairis I've managed to sort it. The query should have been some thing like this;
$query = "SELECT * FROM blockbook
INNER JOIN user ON blockbook.user_id = user.id
WHERE blockbook.user_id = '$user_id'";

Thanks
Zed