[Witchfinder]

Alright,
I've got a problem with the php in relation to updating a mysql database. I've created a dropdown menu which is formed using the rows from the database to select a product to update. That part of the site works fine but when it loads the web page with the form to update that products details I get the following error including printing post:

[Hunch]

A quick glance at the errors would suggest the following:

It's saying that $_POST['cycleID'] doesn't exist - you need to check the code on the previous page - it's probably because your <select> is called 'edit' for some reason and not 'cycleID'.

However, PHP is very forgiving, so this is just a notice, not a fatal error, and the code continues to execute. Presumably when it gets to the SELECT statement,

SELECT * FROM cycles WHERE cycleID = $cycleID <-missing

$cycleID has no value and so the SQL is invalid because one of the parameters is missing.

Bear in mind your code is horribly insecure at the moment - be absolutely sure you nail down the referrer, or use prepared statements and mysqli otherwise you're a sitting duck for SQL Injection attacks.

[datahound]

<select name = "edit">

should be

<select name = "cycleID">

perhaps?

[Hunch]

Too slooooow

[Witchfinder]

Bingo, cheers for the speedy replies.

[datahound]

Originally Posted by Hunch

Too slooooow

All credit to you on that, I just concluded your lead.

[Hunch]

Hehe - just kidding. He probably read mine, then read yours and just did what you said.