PHP & mySQL record update error

You need to put single quotes around the your WHERE clause criteria. i.e.
WHERE id ='1'

Port

"E-Star" <unix_core@linuxmail.org> wrote in message
news:290720031607357437%unix_core@linuxmail.org...
> I'm using my machine as localhost to develop a website using php &
> mysql.
>
> My setup:
>
> =======================================
> test.php: contains a simple form using html
>
> <form action="test2.php" method="POST">
> <input type="text" name="mytext">
> <input name="Update" type="submit" value="Update">
> </form>
> =======================================
> test2.php: updates the text entered into the database
>
> <?php
> require_once('Connections/main.php');
> $sql = "UPDATE mydata SET mytext='".$_POST['mytext']."' WHERE id=1";
> mysql_query($sql) or die("Error in query");
> header("Location: test.php");
> ?>
> =======================================
>
> My problem is that every 5th time I enter data, I'm getting a "Error in
> query". (ie. if I enter '1' then click 'Update', click back, enter
> '2', etc
>
> What could this possible be? It almost seems like something is not
> clearing, and a buffer overflows on the 5th time. maybe?

On Tue, 29 Jul 2003 23:33:42 GMT, "Darryl Porter"
<dporter3@woh.rr.com> wrote:

>You need to put single quotes around the your WHERE clause criteria. i.e.
>WHERE id ='1'

Nonsense. Numbers don't need quoting.

--
Andy Hassall (andy@andyh.co.uk) icq(5747695) (http://www.andyh.co.uk)
Space: disk usage analysis tool (http://www.andyhsoftware.co.uk/space)

In article <qvDVa.34780$ib2.9739044@twister.neo.rr.com>, Darryl Porter
<dporter3@woh.rr.com> wrote:

> You need to put single quotes around the your WHERE clause criteria. i.e.
> WHERE id ='1'

I tried that...then I removed them trying to get it working.