/    Sign up×
Community /Pin to ProfileBookmark

HTML FORM and PHP MYSQL Delete stumper

I know this should be easy but it isn’t…here is a code snippet

[code=php]<?php
mysql_select_db($d, $w);
$query_buysell = “DELETE FROM buysell WHERE passcode = ‘ <what goes here> ‘”;
mysql_query($query_buysell, $w) or die(mysql_error());
?>

….

<p>Please enter your passcode:</p>
<form name=”form1″ method=”post” action=”<?=$PHP_SELF?>”>
<p>
<input type=”text” name=”code”>
</p>
<p>
<input type=”submit” name=”Submit” value=”Submit”>
</p>
</form>
<p>&nbsp;</p>
[/code]

I have a form that takes a user inputted passcode…I’m trying to pass it in to the SQL query at the top of the program…<what goes in here>…I tried $_POST[‘code’] but it gives me a blank screen when I run it…it sounds like an easy fix but I’m stumped…any help would be appreciated.

to post a comment
PHP

1 Comments(s)

Copy linkTweet thisAlerts:
@QuansinauthorJul 07.2006 — Never mind... LOL
×

Success!

Help @Quansin spread the word by sharing this article on Twitter...

Tweet This
Sign in
Forgot password?
Sign in with TwitchSign in with GithubCreate Account
about: ({
version: 0.1.9 BETA 5.19,
whats_new: community page,
up_next: more Davinci•003 tasks,
coming_soon: events calendar,
social: @webDeveloperHQ
});

legal: ({
terms: of use,
privacy: policy
});
changelog: (
version: 0.1.9,
notes: added community page

version: 0.1.8,
notes: added Davinci•003

version: 0.1.7,
notes: upvote answers to bounties

version: 0.1.6,
notes: article editor refresh
)...
recent_tips: (
tipper: @AriseFacilitySolutions09,
tipped: article
amount: 1000 SATS,

tipper: @Yussuf4331,
tipped: article
amount: 1000 SATS,

tipper: @darkwebsites540,
tipped: article
amount: 10 SATS,
)...