# Simple PHP/mySQL DELETE FROM syntax question

**URL:** <https://forum.kirupa.com/t/simple-php-mysql-delete-from-syntax-question/118015>\
**Category:** Uncategorized\
**Created:** [August 2, 2004, 2:18am UTC](https://forum.kirupa.com/t/simple-php-mysql-delete-from-syntax-question/118015 "2004-08-02T02:18:52Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![The\_Vulcan](https://yyz1.discourse-cdn.com/flex011/user_avatar/forum.kirupa.com/the_vulcan/32/145_2.png) [@The\_Vulcan](https://forum.kirupa.com/u/The_Vulcan)\
**Post date:** [August 2, 2004, 2:18am UTC](https://forum.kirupa.com/t/simple-php-mysql-delete-from-syntax-question/118015/1 "2004-08-02T02:18:52Z")

</div>

Hey,

I have tried every variation I can think of on this, and used every example I could find but still can’t get this simple line to work.

Can someone please correct the error in this line.

```php
 
$query = "DELETE FROM users WHERE username=user_alpha";

```

---

<div class="post-metadata">

**Author:** ![Yeldarb](https://avatars.discourse-cdn.com/v4/letter/y/51bf81/32.png) [@Yeldarb](https://forum.kirupa.com/u/Yeldarb)\
**Post date:** [August 2, 2004, 2:47am UTC](https://forum.kirupa.com/t/simple-php-mysql-delete-from-syntax-question/118015/2 "2004-08-02T02:47:06Z")

</div>

Try with ’ ’ around the input value like:

```php

$query = "DELETE FROM users WHERE username='user_alpha'";
$result = mysql_query($query);

```

That’s also assuming you have an entry in the database that is “user\_alpha” as the userName.

---

<div class="post-metadata">

**Author:** ![The\_Vulcan](https://yyz1.discourse-cdn.com/flex011/user_avatar/forum.kirupa.com/the_vulcan/32/145_2.png) [@The\_Vulcan](https://forum.kirupa.com/u/The_Vulcan)\
**Post date:** [August 2, 2004, 3:01am UTC](https://forum.kirupa.com/t/simple-php-mysql-delete-from-syntax-question/118015/3 "2004-08-02T03:01:52Z")

</div>

**That did the trick !**

Thanks **Yeldarb** , once again you have solved my delema. 😃

---

<div class="post-metadata">

**Author:** ![Yeldarb](https://avatars.discourse-cdn.com/v4/letter/y/51bf81/32.png) [@Yeldarb](https://forum.kirupa.com/u/Yeldarb)\
**Post date:** [August 2, 2004, 3:06am UTC](https://forum.kirupa.com/t/simple-php-mysql-delete-from-syntax-question/118015/4 "2004-08-02T03:06:58Z")

</div>

Hehe, anytime 🙂  
(last time I don’t think I succeeded hehe ;))