Records Won't Delete
mysql_query("DELETE FROM guestbook WHERE id = '$recnum'"); It works fine on my local server but it doesn't delete records on the remote server. any ideas?
View Complete Forum Thread with Replies
Related Forum Messages:
Wont Add Records To My Database
can u check my codes and tell me whats wrong because for some reason it wont add records to my database, im using phpadmin v4.23 here are my codes <htmL> <body> <form action="insert.php" method="post"> First Name: <input type="text" name="first"><br> <input type="Submit"> </form> </body> </html> here are my php codes <? $username="root"; $password=""; $database="trial"; $first=$_POST['first']; mysql_connect(localhost,$username,$password); @mysql_select_db($database) or die( "Unable to select database"); ....
View Replies !
DELETE RECORDS - Database Adding New Records
iv got the database adding new records, and now I want it to display all of the records that are there buy name and id number, then i want u to be able to type in the id number of the customer u wish to delete and it shoudl delete it, sounds good buts its not actually deleting the record. it says it does, but its not doing it. Code:
View Replies !
DELETE Records
I am going to write a php script to delete some records based on values supplies by the user. I was just wondering if the query is correct but there are no records to delete for example if this query was executed but there was no testId 7, would an error occur or would the query be performed but just not delete any records? PHP Code: $testId = 7; $q="$q="DELETEÂ Â FROM test WHERE testId = $testId"; mysql_query($q, $link_id)or die(mysql_error());
View Replies !
Wants To Delete Old Records
I want to delete records that are more than 7 days old($keeptime). I am new to this and can't figure out the correct code. The table is called 'x4tables' and the field 'tdate' is a timestamp. I have used: Code:
View Replies !
Delete Records Since A Week
I've been trying to delete records since a week and i'm not able to do it. Before with this script, i was doing so many things at a time and i was confused.But, now, i just displaying the records from a table N trying to delete them.Would somebody pls guide me. I just wanna set the delete flag(i.e, i want to set the RBS_DELETE column to Y or something) when i check a check box to delete it. I've some 5 records displaying on my form and i want to check 3 of them and when i check them and hit submit, i want the RBS_DELETE column to have some value. PHP Code:
View Replies !
Delete Records From A Table
I have a table its called queue. It has a field called id. I want to delete all records in the table apart from the ones with id equals to 74 or 75 or 87. How do i do that?
View Replies !
Forms To Delete Records
I am trying to make a PHP script that displays all of the records from a database, then allows a user to edit or delete the records via a form. I need a checkbox beside the names and a text field with a number beside each name. Is there a way to make it delete all names with a check beside them and update all number that have been changed when the user clicks submit?
View Replies !
Delete Records From Table 1
I have a script that doesn't delete records from one database when it should, and now I have to do this myself because database is big and causes problems on the server. What I have is: TABLE 1, field auction TABLE 2, field id so I would like to delete all records from TABLE 1 where the value of the field auction doesn't match the value of the field id in TABLE 2. Can someone help me on this, please? I need to get this database cleaned.
View Replies !
Delete Specific Records
On clients machine, currently to delete on trainee record it runs 10 queries to delete records from 10 tables. At the time of running all queries, server shows (104) Connection reset by peer. An error condition occurred while reading data from the network. I think it because of running 10 queries at a same time. Is there any possibility that through one line of query we can delete record from 10 tables. I've tried following query DELETE FROM table1, table2, table3, table4, table5, table6, table7, table8, table9, table10 WHERE empID = 11; But it gives ' error in query.
View Replies !
Delete All Records Starting In R
PHP Code: $result2 = mysql_query ("DELETE FROM r_CompTables WHERE CompID = R??") or die("DELETE error: ".mysql_error()); I have this code but I want it to delete anything start in R. R will be followed with a number so it could be R5 or R91.
View Replies !
Delete Fixed Number Of Records
i have a table with one field. this field saves times as records. i want to there are 40 recoreds always. in other mean when inserts 41'st record then 1'st record be delete how to delete fixed number of records at a time of first of my records asc (like select). in other mean i want to like: delete from table order by time asc limit 0,1
View Replies !
Delete Selected Records From Table.
Can anyone see why this connection doesn't work? It's suppose to delete selected records from my table. <?php if (isset($_POST['delete'])) // && isset($_POST['delcus'])) { foreach ($_POST['delcus'] as $val) { echo "$val"; $conn= mysql_connect( "localhost", "user", "password" ); $sql = mysql_select_db( "snow" ); $del = mysql_query("DELETE * FROM request WHERE qid =" .$val); //$rows = mysql_num_rows($del); $rs = mysql_query($conn, $sql, $del); if($rs) .........................
View Replies !
Multiple Delete From A List Of Records
If I have a list of records from a database on the screen, each with a check box beside them, how would I delete all the records that have been ticked? I assume I would use a variable similar to checked[], but not sure what syntax I would use to remove them from the database? Would I loop round each record comparing the checked[] value and it it's set, delete the record?
View Replies !
Do A DELETE Statement To Remove Any Records That Don`t Match.
I`m just trying to figure out the best method to delete my records and wondered if it was possible to do a DELETE statement to remove any records that don`t match. Here is my code so far: $Query="select blah its huge:-)"; $RESULT=mysql_query($Query); $my_rows=mysql_num_rows($RESULT); for ($a=0; $a<$my_rows; $a++){ mysql_data_seek($RESULT, $a); $Array = mysql_fetch_array($RESULT); printf("%s<BR>", $Array['Email']);} My Query returns Matched Records, what I would like to achieve is deletion of the records that didn`t match, would it be possible to do that under the printf statement. So delete all the records in the table that don`t match up to $Array['Email']??
View Replies !
Delete Option From My View Records Page
I have a list of things I need to do with my database - but this is my next hurdle - the delete query within my view records page. I want to be able to click on a button or link to delete a record in a table. I was envisaging that each record would have a delete button or link next to it and clicking that would remove it. Here is the script I have created to view "Devices": PHP Code:
View Replies !
Delete Multiple Records In The Same Database Querie?
I have some code that deletes records from the database, in a loop. However its prety inificient as it makes a seperate database call in every loop whcih is slow. PHP Code: for ($i=0; $i<count($idarray); $i++) db_query("delete from clicks where id='$idarray[$i]'"); Is their a more efficient way of doing that? It is posible to delete multiple records in the same database querie?
View Replies !
Auto Delete The Old Records But What If Server Clock Was Set Up Wrong In Maintenance?
I want auto delete any events that the event date is at least 1 day older than current date. No problem for the php programming. get the current data (server clock), check the events date and delete the old records. My problem is that for some very rare cases. Say if for extrem cases I have 1000 new events saved in database. But somehow, I or the the hosting company do the server maintenance, and reset the time clock of the server, in case in the maintenace, the server time clock was set up wrong say 2005, was set up as 2006. Code:
View Replies !
Delete Record - When The Delete Link Is Clicked The Next Page Is Blank And Nothing Is Deleted.
This is my "delete.php" and this "todo/delete.php?id=64" an example of a link to it generated from the index.php page. When the delete link is clicked the next page is blank and nothing is deleted. What have I done wrong? <? include("dbinfo.inc.php"); mysql_connect(localhost,$username,$password); @mysql_select_db($database) or die( "Unable to select database"); $id="delete from todo where id='$id'"; mysql_query($id); mysql_close(); ?>
View Replies !
Mysql Delete - $query = Mysql_query("DELETE
how would i do the following ? $query = mysql_query("DELETE notes, datestamp, abs_value, ID FROM absence_mgt WHERE datestamp='$date' AND ID='$vtc_login' ") or die(mysql_error()); im just getting "Unknown table 'notes' in MULTI DELETE" ?
View Replies !
Displaying Priorty Records And Normal Records In The One Dataset.
I have a page which displays the records from the database and uses paging to display the records in groupes of 10 per page. I now want to be able to show results depending on the database field (display) in the database (can be set to either "full" or "limited"). If the record and the field display is equal to "full" i want to then display this record at the top of the record set and display all the fields. If the record is equal to "limited" i want to display different results and they must show after all the records which are equal to "full". I can't output two different recordsets as i use paging and only want to show 10 records per page. Code:
View Replies !
Problems With The Listing Of Records, Editing Of Records
I'm having problems with the listing of records, editing of records, and deleting of records. I'm not sure what I'm doing wrong. The listing script is calling the add entry script. So I add the record, the database is updated, and nothing else happens. I don't get a list of records from that table. When I did SQL programming off the mainframe, you did a simple select statement. I'm not sure why the PHP list script is calling the add entry script. Code:
View Replies !
Xml Wont Write Right
i'm trying to use php (4.06) to write to an xml document usind data and fieldnames from a psql database. the php script is generating xml, its writing the whole document in fact but the structure is wrong. It prints a record for correct number of fields but it repeats the details twice and then appears to get stuck in a loop after it reaches the second field. the other problem is that i still cannot get the fieldnames inside the xml tags. PHP Code:
View Replies !
Strtolower Wont Do His Job
in the following insert the strtolower wont put the chars in lowercase. the code: $qryInsRel = "INSERT INTO "tblrelations" (rid, vcfirstname, vclastname, vccompany, vcfunction, nlangid, ngenderid, nuserid, ntitleid, dtbirthdate, vcbankaccount, vcvatnr, vctraderegisternr) VALUES(" . $relNextVal .", '" . $_POST["txtFirstName"] . "', '" . strtolower($_POST["txtLastName"]) .. "', '" . $_POST["txtCompany"] . "', '" . $_POST["txtFunction"] . "', '" . $_POST["txtLanguage"] . "', '" . $_POST["txtGender"] . "', '" . $_COOKIE["cUserID"] . "', '" . $_POST["txtTitle"] . "', '" . $bday . "', '" . $_POST["txtBankaccount"] . "', '" . $_POST["txtVATNr"] . "', '" . $_POST["txtTradeRegNr"] . "')"; (btw i moved a bit from the layout of the code but the rest is exactly what i have)
View Replies !
PHP Wont Run From Subdirs On IIS?
Just installed the latest version of PHP. My problem is that only PHP scripts in the root web server dir D:/inetpub/wwwroot in my case will run. If I try to run them from a sub dir, e.g. D:/inetpub/wwwroot/signup ala http://localhost/signup, the brower just displays the source of the script instead of running it. Has anyone seen this sort of thing before, and if so what must I do to get .php to running from any dir on the web server?
View Replies !
Wont Work With AOL?
Everyone who uses AOL is unable to log into my site. My site uses a mysql backend , login via form, basic user auth check. Start session cookie.
View Replies !
Mysql Insert Just Wont Have It!!
i have the following query to insert data into a table with 7 fields... one of the fields only need the default value to start with and the other is and auto increasement field. PHP Code:
View Replies !
File Wont Upload
I have a script that i have used in the past to succesfully upload a file to the server. for some reason it will not work for a new site i am building, i think it may have something to do with the paths but have tried everything i can think of. Code:
View Replies !
DreamWeaver Wont Show Php
When I am makeing a simple html site is works, but when i try to add some php it wont show up? Even when I open a new project under php document?It just shows up as a blank page. <html> <head> <title>Untitled Document</title> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> </head> <body> <?php $thisis = "hey heyyye heyyylloooo"; $money yeah = "yeah"; ?> </body> </html> but when I go to Design i get this little symbol that says php?
View Replies !
Php Page Wont Load
I uploaded it to a server and what the goal for this basic class is to have the form submit to the php page. once i click submit on the form page (<form name="form0" method="post" action="formpost.php"> ) Code:
View Replies !
Exec Wont Run A Cpp Program
I'm trying to get Zonminder up and running on FC4 One of the asso programs is zmu.cpp - compiles fine. And runs from the command line IE. /u/l/b/zmu -help returns Usage. zmu -m 2 -z (real cmd) from cmd line does what it should do. However (in xx.php) exec ("/usr/local/bin/zmu -m 2 -z", $ret); doesn't. From what I can tell it doesn't even enter the program. Permissions are 755. If I change the exec to ("ls") - works, date - works. I've compared "env" - nada. SafeMode = Off. Is there ?anything? else that might cause my problem?
View Replies !
Session Wont Create
I am just getting started adding a user system to my site. I do have SSL activated on my site, but when I try to create or read a session I get errors. Here is what happend when I try to create: Warning: session_start(): Cannot send session cookie - headers already sent by (output started at /hsphere/local/home/nicholas/braddanick.com/makesession.php:6) in /hsphere/local/home/nicholas/braddanick.com/makesession.php on line 13 Warning: session_start(): Cannot send session cache limiter - headers already sent (output started at /hsphere/local/home/nicholas/braddanick.com/makesession.php:6) in /hsphere/local/home/nicholas/braddanick.com/makesession.php on line 13 Do any of you know what the problem could be?
View Replies !
PHP.INI File Wont Seem To Read?
trouble getting my PHP extensions to work, since in phpinfo() I can see my extension path is set to "C:php5" which should be "C:phpext". in php.ini I´ve changed to "c:phpext" but it still dont do nothing..? phpinfo() shows that php.ini should be in C:WINDOWS which it is!
View Replies !
Redirect Wont Work
Alright, this is a login validation thing. When leaves the field empty, things redirect to right page. But when the login is a success, the page would not budge. Its like a blank page with nothing in it. i even tried to echo something outside of the if/else, and still nothing. why wont it redirect? Code:
View Replies !
Query Wont Run In Page
i need page that updates a mysql database but when it runs i get no errors and it looks like it ran but it never does. also the query is right because if i take it from the page it runs fine. Code:
View Replies !
Cron Job Wont Run Imagecreatefrompng
So i have a script on my server that creates a set of images from one. When the script is called in the browser the script runs fine. When it runs as a cron job it fails. now to see if i am getting an error i ran the script from the command prompt as the same user that is running the cron job. and i get this error call to undefined function: imagecreatefrompng() but this works in the browser!!! any ideas?
View Replies !
Cookies Wont Work
I set my cookie to a value, then a form reloads my page. The cookie's value is still the same as before it was changed. When I reload the page the cookie is changed. It's like I had to reload the page twice to get the cookies to work.
View Replies !
Mail() - Wont Work?
I have Win2003 webserver. PHP. IIS6. I have some forms that use PHP mail(). My php.ini is correctly configured to point to my SMTP server. However, it for some reason DOES NOT WORK! No emails are generated from the forms. The scripts in the forms are CORRECT. Please do bother replying if you're going to tell me to check my coding on the scripts, as this is NOT the problem (they have been tested on numerous other machines and looked at by contract programmers). Is there anything else I need to do? Have I missed something with my system config?
View Replies !
Code Wont Allow Login
I have a script that wont let members (or admins) log in. I have checked the database to see if the e-mails and passwords were right and they are but I still cannot log in. Here's the index.php code for the members area: Code:
View Replies !
Mail Wont Send
PHP Code: $toaddress = 'ff20946@pfpc.ie' $subject = 'Hello' $mailcontent = 'none' $fromaddress = 'me' error_reporting(E_ALL ^ E_NOTICE); $headers  = "MIME-Version: 1.0"; $headers .= "Content-type: text/plain; charset=iso-8859-1"; $headers .= "From: Training Department"; $send = mail($toaddress, $subject, $mailcontent, $fromaddress); ...
View Replies !
Include File Wont Get Processed By Php?
I have a bunch of includes that are includes of includes included includicly... so they must be linked to the site root. Heres an example... require_once("http://localhost/includes/dbConnect.php"); If I name the include file with an .inc extension or even an .asp extension the code gets processed, but not with a .php extension.
View Replies !
I-frame Wont Properly Load
im making a personal site with 3 sections. home (news), design, and code. in the main design i setup an iframe which includes page.php. page.php contains this code PHP Code:
View Replies !
|
TRACKER
