Updating and deleting from database

I have to delete data from the database. here is the sample code.

Expand|Select|Wrap|Line Numbers

 <html>

    <head>

        <title>

            Edit and delete fixtures

        </title>

    </head>

        <body>

            <?php
 
                    $fixture_id = '';

                    $update = '';

                    $delete = '';

                    $opponents = '';

                    $date = '';

                    $venue = '';

                    $db_handle = '';

                    $submit = '';
 
                if (isset($_POST['submit1'])) {
 
                    $fixture_id = $_GET['fixture_id'];

                    $update = $_POST['submit'];

                    $opponents = $_POST['opponents'];

                    $date = $_POST['date'];

                    $venue = $_POST['venue'];

                    $submit = $_POST['submit'];
 
                    $opponents = ucwords($opponents);

                    $date = ucwords($date);

                    $venue = ucwords($venue);
 
                    $user_name = "root";

                    $password = "";

                    $database = "zebrascricketclub";

                    $server = "127.0.0.1";

                    $db_handle = mysql_connect($server, $user_name, $password);

                    $db_found = mysql_select_db($database, $db_handle);
 
                if($db_found) {

                    //If update is yes, the form with fixtures data will be displayed ready to be edited,else if delete is yes, then the user will be asked to confirm the action, if yes then the fixture will be deleted from the database.                    if($update == 'yes') {
 
                    echo "<form name = "form1" method = "POST" action = "delete.php">

                         </form>";
 
                    }
 
                }
 
                }
 
            ?>

        </body>

</html>

but i get this error Parse error: syntax error, unexpected T_STRING, expecting ',' or ';' in Z:\Program Files\EasyPHP-5.3.3\www\webfiles\delete.php on line 44

Apr 29 '13 #1

Subscribe Post Reply

1025

Rabbit

12,516

Expert Mod 8TB

Your code doesn't delete anything.

Apr 29 '13 #2

by: Greg | last post by:

I run some reports from the web that is connected to an Access database. I run a macro every 25 minutes that deletes the tables and then appends data to the tables with fresh data. The issue I have...

Microsoft Access / VBA

exporting an excel file from database; making changes to excel file and updating the database by importing it back

by: Luis Esteban Valencia | last post by:

Hello Everyone, Iam an intermediate ASP.Net programmer and iam facing a challenging task. I have a table in MS-SQL server database called 'Members'. The table has following fields... ...

ASP.NET

GridView Control in ASP.NET 2.0 is updating/deleting only via SqlDataSource

by: adam222 | last post by:

hello, i have a web-form with a GridView control, i wanted to update & delete, using the AutoGenerateEditButton. when i used it with sqlDataSource (executing SP in the DB) it works like a...

ASP.NET

Updating a DataSet and Not updating the Database

by: VBNovice05 | last post by:

I am trying to update a DataSet and DataView without updating the database. I have two datasets. DataSet1: Name Size DataSet2: Name Size Path I want to look...

Visual Basic .NET

Updating SqlCe Database from a DataSet

by: Johnny | last post by:

I have a PocketPC mobile application that gets its data from the Sql Server database via a web service. The web service returns a dataset that I need to load into the SqlCe database on the mobile...

C# / C Sharp

Cascade updating/deleting and 3 tier architecture

by: Nemisis | last post by:

Hi everyone, Wonder if anyone can shed some light on how i should setup cascade deletes of object data within my database. One option is to use SQL triggers, is this a good idea? Should the...

.NET Framework

Can you stop a form from updating the database when exiting?

by: Birky | last post by:

How can I stop a form from updating the database when a user closes the form? I have a form which is used for referencing, additions, and modifications but every time the form is closed with no...

Microsoft Access / VBA

Gridview not updating the database

by: =?Utf-8?B?QmFyYmFyYSBBbGRlcnRvbg==?= | last post by:

I setup a simple gridview as a utility just to do some updates, nothing fancy just wanted easy UI to make updates. When I select â€˜Editâ€™, I get the fields I want to edit. I edit them and click...

ASP.NET

Can't seem to crack updating a database

by: Spoogledrummer | last post by:

Hi it's me again, still working on the sam 5 minute problem so feeling kind of thick now. I've dumped the idea of using a textarea for now and am using a textbox instead but am struggling when it...

ASP / Active Server Pages

DataTable row data merged when updating the database

by: Wavey | last post by:

Hi All, I have a problem with updating an Access database from a datatable. I have two rows of data in my database at the moment for testing, the first row is an ID number (primary key), the...

.NET Framework

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

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

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

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

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

Updating and deleting from database

Similar topics