473,473 Members | 1,951 Online

Sign in
Join

Home Posts Topics Members FAQ

deleting a row (php hyperlinking)

6 New Member

hi i trying to make a delete row word where i click on the word and i delete the row. the problem is in line 46 and 47 i dont know how to hyberlink the word to go to the othe file i keep getting errors i dont know why.

any help please

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['id'] . "</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>" . Confirm . "</td>";

  echo "<td>" . Delete . "</td>";

  echo "</tr>";

  }

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

?>
 
<p>

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

  <html>

Jun 15 '10 #1

Subscribe Reply

4

1464

67

New Member

Hello,

Replace line no 46 & 47 by the following code

Expand|Select|Wrap|Line Numbers

 
echo "<td><a href='yourfile.php'>Confirm</a></td>";

echo "<td><a href='yourfile.php'>Delete</a></td>";

Regards,
Mayur Bhayani

Jun 16 '10 #2

6

New Member

thanks you so much mate tried piece of code like this they didnt work this one does thanks alot

Jun 16 '10 #3

6

New Member

Hi trying to create a query so in this table it will only display data in my table. IF conformation in the names table equals no display this data.

I would like to know the code and where to put it please

thanks

Jun 16 '10 #4

67

New Member

Hello,

Please explain more in details. Not sure what are you looking for...

Thanks & Regards,
Mayur Bhayani

Jun 17 '10 #5

Sign in to post your reply or Sign up for a free account.

Similar topics

PHP trademarked?

by: Google Mike | last post by:

I'm about to come out in a few months with a new company and a new product that is PHP-based. I'm working on a user guide and programming guide that comes out with it. At the bottom on the first...

Problem with deleting from a database

by: Sebastian | last post by:

Hi I got a little problem with deleting from my database, i'm making a simple newsscript. I get a Parse error: syntax error, unexpected T_ELSE on line 24, I have written the error as a comment...

by: Mikro | last post by:

Hi! Please help me to get this work. <?php if(isset($delnews)) { ?> <script language="JavaScript"> function deleting() var answer = confirm ("Delete record?) if (answer){ <?php

Deleting all Data in a DB

by: Fughal | last post by:

Hi, I have a big DB2 database and I need this database without any Data in it for testing something. I have made a backup of these db and restore it on a testing system. My Problem is now how...

Deleting row in mysql database using php script

by: azmiza | last post by:

Hi everybody, I need your help. I want to view my sql database and its work very well which is display in my web browser but once I want to press button yes, its not working, I check the...

Deleting multiple Rows Using Checkbox

by: arizal | last post by:

Hi , I am trying to figure out why my PHP code to delete multiple value by selecting the checkbox is not working. My php code is listed as below <?php $sql = "Select * from list;";...

deleting a line

by: programming | last post by:

how do i delete from a text file 1 of the following lines: jon|scott adam|smith <--delete paul|clark say i would like to delete the middle line of this txt, in member.txt what php code or...

Problem with deleting records from DB

by: Odisey | last post by:

I am not sure if this is a MySQL syntax error or a DB issue yet. I am getting the error from the code: Page Error! This page has been accessed in error. The GET is populated in the browser...

making an alert with php

by: shotokan99 | last post by:

i have this code that when the user click it will delete the record: echo' <td bgcolor="'.$color.'" width="40"><font face="Verdana" size="1"> <a...

Deleting record from MySQL

by: keeps21 | last post by:

I'm having a bit of trouble creating a page to delete a story from the content table in my database. I have checked my DELETE query directly in phpmyadmin and it is working fine. I am echoing...

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...

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...

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...

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?

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...

php

by: muto222 | last post by:

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

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...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.

BYTES.COM © 2024
About Bytes
Terms Of Use
Privacy Policy
Sitemap

Advertise on Bytes
How to Post and Respond on Bytes
How to Promote and Link on Bytes
How to increase your Ranking on Bytes
Become a Recognized Expert on Bytes
Feedback Welcomed! Contact Us