Ask a question

Search Forums:

• Search Expression Web and SuperPreview Forum
• Search All Expression Studio Forums
• Search All Microsoft Expression Forums

 

Database code problem

• Thursday, November 05, 2009 1:05 AMRahkashimaster

   
  

  0

  Sign In to Vote
  Hey, i'm looking for some PHP and mysql database experts!

  
  

  I set up a mysql database (I would have used SQL, but my book told me how to use MySQL) through my hosting control panel, and I wrote the PHP code needed to populate it. When I insert the variables into the piece that sends it to the database, it doesn't send form results, it sends the Values I put in: $Name, $Email, etc.

  
  

  Here is the code:

  
  

   <?php

  $Name=$_POST['Name'];

  $email=$_POST['email'];

  $message=$_POST['message'];

  $connection=mysql_connect ("server","username", "password") or die ('I cannot connect to the database.');

   mysql_select_db ("databasename", $connection) or die ("Unable to select database");

  $query = 'INSERT INTO `databasename`.`tablename` (`ID`, `Name`, `email`, `message`) VALUES (\'\', \'$Name\', \'$email\', \'$message\');';

   mysql_query($query);

   mysql_close();

   ?>

  
  

  Any ideas as to why it sends the $name, $email, $message instead of the form results?

  
  

  ~Rahkashi~
  • Reply
  • Quote