Maq

Then make up a fake record and hard code the number in instead of using $Id to make sure everything works.

Exactly. What else is this going to lead to? It's scary...

Try debugging, like this: mysql_query("DELETE FROM events WHERE CONVENTION_ID='$del_id'") or die (mysql_error()); You should also try echoing out your query to make sure your vars have the correct values:

Put this in for error debugging: At the beginning of your PHP script: ini_set ("display_errors", "1"); error_reporting(E_ALL); And this on the end of this line: $result = mysql_query($sql) or die(mysql_error());

Do this for error debugging: mysql_query($query) or die(mysql_error());

Did you read my last post?

The WHERE clause belongs at the end of the query statement. Look at: http://www.tizag.com/mysqlTutorial/mysqlupdate.php

Out of curiosity why don't you have this submitted when the user clicks a submit button? and not just having the page run?

F1Fan is right, you should check this with PHP and javascript in case the user has javascript disabled.

You can check these field with javascript. Have a function like: function IsEmpty(aTextField) { if ((aTextField.value.length==0) || (aTextField.value==null)) { return true; } else { return false; } } This help?

Could you post your current query?

That's your responsibility. Look at the lower left (I think) there's a link for "Topic Solved".

That's pretty much the same thing I have except you're echoing the JS (javascript) in PHP rather than, in my script, exiting out of php "?>", inserting the JS redirect and going back into PHP "<?php".

its from a form that submits to the same page does it need a where clause? it just updates the record its displaying The database doesn't know what record you're displaying. You need the WHERE clause to update the desired record. Like F1Fan said, if you don't have the WHERE clause it will update every record in that table.

Sorry, JS is an acronym for Javascript. Try this instead: <br /> <!--<br /> window.location = "http://www.google.com/"<br /> //--><br />

NP, glad I could help.

Ain't that the truth. I'm graduating this semester and my 4 years of school I remember about 1 snow day a year where classes were canceled. This sounds so weird... Don't worry I'm sure the genius engineers will come up with a solution, if the oil/gas companies haven't bought the patents for these inventions yet >

Don't worry Zanus, it works now! I don't know what was going on... Sorry if I scared you, k let me read this.

NP, glad I could help!

@maq You can't use header() if he outputs a success message on that page! That's what I thought. That's also why I suggest the JS solution instead.

I'm not sure, they both still give the, "Page Not Found" error. I've been browsing the web all night without any errors too... ???

header('Location:http://www.php.net'); Or you could use JS if this throws you an error (about headers), but it shouldn't.

No, same error. This IS weird. Can anyone else confirm this error? (I hope not)

Where do you $_GET this value, "?galleryId=2"? You would need to change your query to: $QueryString="SELECT * FROM $table WHERE gallery_id = $_GET['galleryId']"; Is this what you're looking for?

I forget the exact syntax but something like: SELECT DISTINCT date