Results 1 to 5 of 5

Thread: SQL PHP Update/Delete/Add

Threaded View

  1. #1

    Thread Starter
    Addicted Member
    Join Date
    Mar 2009
    Posts
    156

    SQL PHP Update/Delete/Add

    This is my code so far for updating...

    PHP Code:

    $namereq 
    $_REQUEST['namefield'] ;
    $emailreq $_REQUEST['emailfield'] ;
    $messagereq $_REQUEST['messagefield'] ;
    $datereq $_REQUEST['datefield'] ;

    $con mysql_connect("server""username""password");
    if (!
    $con)
      {
      die(
    'Could not connect: ' mysql_error());
      echo 
    "update failed";
      }

    mysql_select_db("database"$con);
    global 
    $customernumber;

    mysql_query("UPDATE enquiryform SET name=$namereq WHERE customerno = $customernumber LIMIT 1");
    mysql_query("UPDATE enquiryform SET email=$emailreq WHERE customerno = $customernumber LIMIT 1");
    mysql_query("UPDATE enquiryform SET message=$messagereq WHERE customerno = $customernumber LIMIT 1");
    mysql_query("UPDATE enquiryform SET startdate=$datereq WHERE customerno = $customernumber LIMIT 1");

    mysql_close($con);

    echo 
    $namereq
    echo $emailreq
    echo $messagereq
    echo "Update Compleated"

    $_REQUEST['field'] have been retreved for previous page and everything echos/prints ok but nothing changes on the database table?!
    I've checked field/database/passwords/etc what am I missing?
    Last edited by LingoOutsider; May 14th, 2009 at 03:17 AM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width