View only results in table with certain information (only when conformation = No)

6 New Member

I have two table here uncorfirmed booking and confirmed bookings

I only want data to be listed in the unconfirmed booking table when conformation = no

and in only want data to be lised in confirmed booking table when conformation = yes

Any ideas of the code i would have to add and where to add it please

thanks

Expand|Select|Wrap|Line Numbers

 <h1>Booking Table (Unconfirmed Booking)</h1>
 
<?php
 
include("config.php");
 
$con = mysql_connect($mysql_host, $mysql_user, $mysql_password); 
 
mysql_select_db($mysql_database, $con); 
 
$result = mysql_query("SELECT * FROM names");
 
echo "<table border='1'>

<tr>

<th>Booking ID</th>

<th>Firstname</th>

<th>Lastname</th>

<th>Adress</th>

<th>City / Town</th>

<th>Postcode</th>

<th>Phone Number</th>

<th>E-Mail</th>

<th>Cottage</th>

<th>Start Date</th>

<th>End Date</th>

<th>Conformation</th>

<th>Confirm Booking</th>

<th>Delete Booking</th>

</tr>";
 
while($row = mysql_fetch_array($result))

  {

  echo "<tr>";

  echo "<td>" . $row['bookid'] . "</td>";

  echo "<td>" . $row['firstname'] . "</td>";

  echo "<td>" . $row['lastname'] . "</td>";

  echo "<td>" . $row['address'] . "</td>";

  echo "<td>" . $row['citytown'] . "</td>";

  echo "<td>" . $row['postcode'] . "</td>";

  echo "<td>" . $row['phonenumber'] . "</td>";

  echo "<td>" . $row['emailaddress'] . "</td>";

  echo "<td>" . $row['cottage'] . "</td>";

  echo "<td>" . $row['startdate'] . "</td>";

  echo "<td>" . $row['enddate'] . "</td>";

  echo "<td>" . $row['conformation'] . "</td>";

  echo "<td><a href=\"conbook.php?bookid=". $row['bookid']."\" onclick=\"return confirm('Are you sure you want to confirm booking?');\"> Confirm </a></td>";

  echo "<td><a href=\"delbook.php?bookid=". $row['bookid']."\" onclick=\"return confirm('Are you sure you want to delete record?');\"> Delete </a></td>";

  echo "</tr>";

  }

echo "</table>";
 
mysql_close($con); 
 
?>
 
<h1>Booking Table (Confirmed Booking)</h1>
 
<p>

  <?php
 
include("config.php");
 
$con = mysql_connect($mysql_host, $mysql_user, $mysql_password); 
 
mysql_select_db($mysql_database, $con); 
 
$result = mysql_query("SELECT * FROM names");
 
echo "<table border='1'>

<tr>

<th>Booking ID</th>

<th>Firstname</th>

<th>Lastname</th>

<th>Adress</th>

<th>City / Town</th>

<th>Postcode</th>

<th>Phone Number</th>

<th>E-Mail</th>

<th>Cottage</th>

<th>Start Date</th>

<th>End Date</th>

<th>Conformation</th>

<th>Unconfirm Booking</th>

<th>Delete Booking</th>

</tr>";
 
while($row = mysql_fetch_array($result))

  {

  echo "<tr>";

  echo "<td>" . $row['bookid'] . "</td>";

  echo "<td>" . $row['firstname'] . "</td>";

  echo "<td>" . $row['lastname'] . "</td>";

  echo "<td>" . $row['address'] . "</td>";

  echo "<td>" . $row['citytown'] . "</td>";

  echo "<td>" . $row['postcode'] . "</td>";

  echo "<td>" . $row['phonenumber'] . "</td>";

  echo "<td>" . $row['emailaddress'] . "</td>";

  echo "<td>" . $row['cottage'] . "</td>";

  echo "<td>" . $row['startdate'] . "</td>";

  echo "<td>" . $row['enddate'] . "</td>";

  echo "<td>" . $row['conformation'] . "</td>";

  echo "<td><a href=\"unconbook.php?bookid=". $row['bookid']."\" onclick=\"return confirm('Are you sure you want to unconfirm booking?');\"> Unconfirm </a></td>";

  echo "<td><a href=\"delbook.php?bookid=". $row['bookid']."\" onclick=\"return confirm('Are you sure you want to delete record?');\"> Delete </a></td>";

  echo "</tr>";

  }

echo "</table>";
 
mysql_close($con);
 
?>

<p>

  <INPUT type="button" value="Log Out" onClick="location.href='adminlog.php'">

  <html>

Jun 16 '10 #1

Subscribe Reply

1402

JKing

1,206

Recognized Expert Top Contributor

Expand|Select|Wrap|Line Numbers

 
//Change line 11 to this

$result = mysql_query("SELECT * FROM names WHERE conformation = 'yes'");
 
//Change line 67 to

$result = mysql_query("SELECT * FROM names WHERE conformation = 'no'");

What you are doing is adding a where clause to pull the appropriate data based off your conformation field. Now I am assuming here that the field conformation is a string equal to yes or no and not a boolean.

Jun 17 '10 #2

Similar topics

2049

how to pop up a Modeless Dialog only when some conditions are reached?

by: ywchan | last post by:

I have implemnt a onBlur event of a text input. In the event, a window with all records which related to the text input will be shown. However, I don't want to pop up the window in case there is...

Javascript

1965

Manually get the text that a certain control posted when in IsPostBack mode...

by: Nathan Baulch | last post by:

I have a page with EnableViewState="false". That page contains a DropDownList with dynamic items and a submit Button. I need to get the SelectedIndex of the DropDownList on postback however all...

ASP.NET

2969

table column information

by: Scot L. Harris | last post by:

Currently using Postgresql 7.2.4-5.80 with php 4.2.2.-8.0.8 on a redhat 8.0 system. I am writing some php scripts where I want to generate a list of the column names in a particular table that...

PostgreSQL Database

1406

After closing Design View, the table appears instead of form

by: AA Arens | last post by:

When I finished whitch the Design View and want to go back to normal view, the form does not appear. Instead of that the table appears. I only get the form when I cal it on the Switchboard. How...

Microsoft Access / VBA

4756

Javascript - Access By URL: show layer of hidden content only when on certain URL

by: l!m!t | last post by:

Hello, I hope somebody can help me I have been at this for hours. I am new to JavaScript. I need a script to show a layer of hidden content only when on a certain URL. I have searched and...

Javascript

1973

Front end opens slow - only when copied?

by: jonceramic | last post by:

Hi all, I have a situation I can't find any old messages or web-help on. I have a split database with a bizarre quirk. When I open up the front-end file, the main form opens up fairly quickly...

Microsoft Access / VBA

1797

Selecting an element only when it has certain children

by: matturn | last post by:

Is it possible to select elements only when they have certain children? I wish to reduce the margin on "a:hover"s, but only when they have a UL child. Is this possible, or must I give every link...

HTML / CSS

1945

Update the database only when new data

by: mariaz | last post by:

Hello, I am creating a project where I parse an xml page (feed from a website) in a javabean file and I insert the parsed data in a mysql database. I want this data that gets inserted into the...

MySQL Database

23443

How to get Table schema information ?

by: amit2781 | last post by:

How can we get the table schema information in MYSQL 5.1.34? Like we use in ORACLE to get it as: OCIDescribeAny() // //get the describe handle for the table to be described. OCIAttrGet() ...

MySQL Database

7242

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

7138

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

7353

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

7418

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

5662

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice

3222

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...

Networking - Hardware / Configuration

3212

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

781

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

446

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

General