Select query not working????

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
zed420
Forum Commoner
Posts: 32
Joined: Wed Jun 04, 2008 11:24 am

Select query not working????

Post 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();
}   
?>
 
 
 
User avatar
requinix
Spammer :|
Posts: 6617
Joined: Wed Oct 15, 2008 2:35 am
Location: WA, USA

Re: Select query not working????

Post 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.
zed420
Forum Commoner
Posts: 32
Joined: Wed Jun 04, 2008 11:24 am

Re: Select query not working????

Post 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
Post Reply