[The Knowing]

Thanks, I found the WHERE issue about 10mins ago. I know the issue with the ereg. I plan to change it once I get the other parts of the script working. For the mysql_query code I am having trouble with the updating.

The code up above will not work for updating, but when I add the actual value it updates. What do I need to do so this is automatic? Grab the current price and post it into the where? This isn't making much sense to me.

[wirehopper]

Have you echoed or var_dumped what ereg is creating?

[The Knowing]

Yes. It is right below the mysql queries.

[wirehopper]

Could you post the output of the ereg calls?

The code up above will not work for updating, but when I add the actual value it updates.

This sounds like the ereg calls are not creating the data you expect, using echo/var_dump to display the values will allow you to see what the code is trying to put in the database.

[The Knowing]

From what I understand the issue is with the WHERE. When I input the WHERE data manually it works, but when I use the $row['Item'] it doesn't work. It should be using the Item name for the place to enter the data shouldn't it? It works when I put the price that is stored in the database though.

BTW this problem has nothing to do with the ereg. It is an issue with the mysql_query.

[wirehopper]

Then echo out the mysql_query to see what is being sent to MySQL. Have you used PHP: mysql_error - Manual

It would be much easier for people to help you if you would post some of the requested output - even if it is exactly what you expect. You could also post the database schema.