[Pbpixels]

Hi all, I have troubles declaring values inside a <select> option.
I want it to select an email from a list created from a cmslogin database and then delete it after a push on the button.
I feel like trying everything but I somehow can't get it to work.
My code goes like this:

<?php
  
  require_once('connectvars.php');
  
  //Connects to your Database 
 require_once('connectvars2.php');
 $data = mysql_query("SELECT * FROM cmslogin") 
 or die(mysql_error());
 
 $select = $_POST['select'];

  if (isset($_POST['execute'])) {
  
 $id = $_POST['id'];
 $email = $_POST['email'];
 
 $data = "DELETE FROM cmslogin WHERE id = $id";
 $result = mysql_query($data);
 
  }
   //Connects to your Database
 require_once('connectvars2.php');
 $data = mysql_query("SELECT * FROM cmslogin")
 or die(mysql_error());
 
  echo '<form method="post">';
  echo '<select name="select">';
  
 while($row = mysql_fetch_array( $data )) {
 
 echo "<p><option value=" . $row['id'] . ">" . $row['email'] . "</option></p>";

 }
 
  echo '</select>';
  ?>
<input type="submit" name="execute" />
 </form>
<?php
}
?>

The connectvars contains my database login.
Thanks in advance

[JackOfAllTrades]

Quote

I somehow can't get it to work.

Does your computer melt down or explode?

[Pbpixels]

JackOfAllTrades, on 04 October 2012 - 02:21 PM, said:

Does your computer melt down or explode?

Relevant posts please?

[JackOfAllTrades]

Something more than "I can't get it to work", please?

Read this

For example:

1. Is it giving you errors?
2. Is it giving you a blank screen?
3. If neither of these, what does the generated HTML look like?

[CTphpnwb]

Pbpixels, on 04 October 2012 - 05:28 PM, said:

JackOfAllTrades, on 04 October 2012 - 02:21 PM, said:

Does your computer melt down or explode?

Relevant posts please?

Pot, meet kettle.

Read the text that shows in the background when posting! It's there for a reason.

[Pbpixels]

well, I thought I would make a short post since this problem should be rather simple to solve.
My problem is that as said, I can't declare a variable in my <option> html.
The reason for this script is that it should delete a user inside a database when a button is pressed, the values contains the id and the option contains the emails, but the $id doesn't get recognized once the button is pressed.

You don't get an error for this, $id just doesn't get a value when the button is pressed. Nothing more than that, nothing happens when you press the button.

"I can't get it to work" If I could make it work, I wouldn't be sitting here writing to you guys. It is hard to tell what my problem is when it doesn't give me any errors, hence I'm writing here.

Any ideas?

[Pbpixels]

Oh yeh got it working.
The only thing that had to be changed was:

 $data = "DELETE FROM pbcmslogin WHERE id = $id";

to

 $data = "DELETE FROM pbcmslogin WHERE id = $select";

Thanks for your help. lol