These two irritating problems

Goonboonie

Hi,

I have a regristration page made with PHP which puts data in the database, things like name, address, zip code, phone number.
The page works except for some reason ( and it is not in the code right now) the zip code, phone number default to a value of 127.
This was a value that I typed in the form the very first time I tested it. I don't know why it is still a value that is going in the database. The other problem with the form is that the pulldown menus are submitting the first value in the list not the one the user selects.

The other frustrating problem is that I created a delete button for the administration page but it is not deleting the information all that happens is that the record displayed with all its information reloads with empty values. I have the form action = to the page itself this is the code:

if (!$db) {
echo "Could not change into the database";
exit;
}
if(isset($_POST['submit'])) {

$query = "Delete FROM registerINFO_table WHERE register_id='$register_id'";

//This diplays the individual record

} else {

$query = "SELECT * FROM registerINFO_table WHERE register_id='$radiobutton'";
$result = mysql_query($query) or die("Cannot perform reg record query.");
$row = mysql_fetch_array($result);

?> <table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>

--------------------------------HTML CODE DISPLAYING RECORD--

</table></center></td>
</tr>
<tr>
<td><center>
</center></td>
</tr>
</table><?php
}
?>
</body></html>

I really appreciate your comments

Thanks!

😃

leatherback

Hi,

The 127 problem: My first reponse is that that might be a cutof point for the database field you are using. Have you tried setting it to text, or long integer?
For the pulldown menus you'd have to show the sourcecode of th epulldown menu. It probably has to do with value settings or improper ending of field. But post the code, and we can have a look

The delete: Do you set the $register_id variable? You will most likely need to get the value from the post array:

$register_id = $_POST[register_id]

Hope this helps,.

Jelle.

dnast

Also, you set $query to the string that will delete the record, but you never actually perform the query (when 'submit' is set).

Goonboonie

Thanks for the ideas. The pulldown works well now that I have a default value like "Select one" for what ever reason ???
You were right about the variable type I switched to one that stores more info.

I am not sure about your advice for the delete. I am not sure what I need to do to fix it yet.

Thanks again

Goonboonie

dnast

What I was saying is that you just have:

if(isset($_POST['submit'])) {

$query = "Delete FROM registerINFO_table WHERE register_id='$register_id'";

}

When 'submit' is set, all you have it do is set $query to "Delete FROM registerINFO_table WHERE register_id='$register_id'"

Just add the mysql_query($query) on the next line (inside the curly brackets).

Goonboonie

Hi Dnast thanks for the suggestion. I tried:

if(isset($_POST['submit'])) {

$query = "Delete FROM registerINFO_table WHERE register_id='$register_id'";
mysql_query($query);

}

The delete function still doesn't seem to work. Did I miss something?

dnast

Put an echo $query; before the line with mysql_query...

$register_id might not be set. If it isn't, changing $register_id to $_POST['register_id'] should do the trick if that's the name you used in the form.