•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the PHP section within the Web Development category of DaniWeb, a massive community of 429,971 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,554 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our PHP advertiser: Lunarpages PHP Web Hosting
Views: 3298 | Replies: 5
 |
•
•
Join Date: Jun 2004
Posts: 5
Reputation: 
Rep Power: 0
Solved Threads: 0
Newbie Poster
How can i deledet and update from table ??????? please
iam ask about
how can i delete and update from table ?
please i want example to delete data from table
and aother example to make update data from table
please help me :o
iam ask about
how can i delete and update from table ?
please i want example to delete data from table
and aother example to make update data from table
please help me :o
•
•
Join Date: Jun 2004
Posts: 173
Reputation:
Rep Power: 0
Solved Threads: 9
Unverified User
I use mysql... so in mysql its...
$sql = "DELETE FROM table WHERE field='value'";
or
$sql = "UPDATE table SET field='value' WHERE ...";
mysql_query($sql);
this is more of a basic SQL question then php...
$sql = "DELETE FROM table WHERE field='value'";
or
$sql = "UPDATE table SET field='value' WHERE ...";
mysql_query($sql);
this is more of a basic SQL question then php...
•
•
Join Date: Mar 2004
Location: Brisbane
Posts: 632
Reputation:
Rep Power: 7
Solved Threads: 6
Practically a Master Poster
I think he wants to know how to do it via php...
Formerly known as Slade.
•
•
Join Date: Apr 2004
Location: Tracy
Posts: 744
Reputation:
Rep Power: 7
Solved Threads: 32
Master Poster
•
•
•
•
Originally Posted by slade
I think he wants to know how to do it via php...
that is how you do it. it would be
<?php
mysql_connect (mysql location, username, password) or die(mysql_error());
$tb_delete = "DELETE FROM tabl WHERE field='value'";
mysql_query($tb_delete) or die(mysql_error());
mysql_close();
that would be most of the code that you would see, or part of it.
!!!!! WARNING YOUR COMPUTER MAY BE INFECTED WITH SPYWARE!!!! PAY AN OVER PRICED AMMOUNT TO HAVE SOMTHING FIXED WE PLACED THERE IN THE FIRST PLACE!!!!!!!!!
sound familiar, know how to block yourself and keep yourself clean.
_____________________
http://www.lavasoftusa.com/ -->adaware
http://www.safer-networking.org/en/index.html -->spybot S&D
http://www.javacoolsoftware.com/spywareblaster.html -->spywareblaster
http://www.javacoolsoftware.com/spywareguard.html -->spywareguard
_____________________
and dont forget to spread the reputation to those that deserve!
sound familiar, know how to block yourself and keep yourself clean.
_____________________
http://www.lavasoftusa.com/ -->adaware
http://www.safer-networking.org/en/index.html -->spybot S&D
http://www.javacoolsoftware.com/spywareblaster.html -->spywareblaster
http://www.javacoolsoftware.com/spywareguard.html -->spywareguard
_____________________
and dont forget to spread the reputation to those that deserve!
•
•
Join Date: Jun 2004
Posts: 5
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
thank you Killer_Typo
now i want to now how i can make update
now i want to now how i can make update
•
•
Join Date: Apr 2004
Location: Tracy
Posts: 744
Reputation:
Rep Power: 7
Solved Threads: 32
Master Poster
•
•
•
•
Originally Posted by astm
thank you Killer_Typo
now i want to now how i can make update
should be around the same as what i said before, but use the UPDATE syntax. if you open up the mysql manual and do a search by going to edit, find on page. and type in the word you will most likely find all of the information you need to know about correct mysql syntax.
also i forgot to to mention that in the code that i listed above i forgot to add the line for selecting the correct databse. wich would be
$use = "USE database";
mysql_query($use) or die(mysql_error());
somthing along those lines should select the databse for the table you wish to modify (ive been writing my own custom database management tool, so ive been trying to get good with mysql syntax)
!!!!! WARNING YOUR COMPUTER MAY BE INFECTED WITH SPYWARE!!!! PAY AN OVER PRICED AMMOUNT TO HAVE SOMTHING FIXED WE PLACED THERE IN THE FIRST PLACE!!!!!!!!!
sound familiar, know how to block yourself and keep yourself clean.
_____________________
http://www.lavasoftusa.com/ -->adaware
http://www.safer-networking.org/en/index.html -->spybot S&D
http://www.javacoolsoftware.com/spywareblaster.html -->spywareblaster
http://www.javacoolsoftware.com/spywareguard.html -->spywareguard
_____________________
and dont forget to spread the reputation to those that deserve!
sound familiar, know how to block yourself and keep yourself clean.
_____________________
http://www.lavasoftusa.com/ -->adaware
http://www.safer-networking.org/en/index.html -->spybot S&D
http://www.javacoolsoftware.com/spywareblaster.html -->spywareblaster
http://www.javacoolsoftware.com/spywareguard.html -->spywareguard
_____________________
and dont forget to spread the reputation to those that deserve!
|
•
•
•
•
•
•
•
•
DaniWeb PHP Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
- How to Update a Data Table? (ASP.NET)
- server notify client to update MySQL table (C)
- retreive and update from check boxes (ColdFusion)
- delete a record and update the dataset (VB.NET)
- how do i update to Access db? (C#)
- Auto update columns? (Database Design)
Other Threads in the PHP Forum
- Previous Thread: Problem Unsetting Variables?
- Next Thread: Code Problem
