PHP - Updating Mass Entrys In Db

Problem: I'm trying to build a junction table for a many to many relationship. Table A contains a title string that contains in it names that are stored in Table B. Both tables have nearly a million rows.

Bad solution: The method I'm using right now is using PHP I fetch and store one table into an associative array. I then do a mysql_fetch loop on the second table and run this code to populate an array that is used to build the multi-insert SQL.

$title = preg_replace ($names, $keys, $title);
if (preg_match_all ('/(\d+)/', $title, $matches))
                   foreach ($matches[1] as $m)
                      $inserts[$row['id'].'-'.$m] = 1;

This works, but I'm looking for possibly a less cpu/memory intensive method. My remote server can't handle it, and we're talking hours and hours on a local server. It seems the bottleneck is with the preg_replace. I've also tried str_replace, which is only slightly faster. So, a method where I wouldn't have to pass around such large arrays, or an entirely different approach is what I'm looking for. Any ideas?

Hello, I found some little php code to check google index of any site.
Code: [Select]
<?php
 
function checkSite($www)
{
  $ch = curl_init('http://www.google.pl/search?hl=pl&q=site%3A'.trim($www).'&btnG=Szukaj&source=hp');
  curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
  $sHtml = curl_exec($ch);
  preg_match('#\<div id=resultStats\>.*([0-9,]+) wynik#Ui', $sHtml, $aMatches);
  curl_close($ch);
  return (int)str_replace(',', '', $aMatches[1]);
}
 
echo checkSite('domain.com');
?>
But to check any site I must edit this code and add new site manually. I'm big beginner in PHP.
 I want to have a area on browser side to add many sites, and receive result, like in this code which I add. above.
Can anybody help me with this?

PS. Sorry for my poor English.

I have dozens of tables that a client needs to download through the web. I can use PHP to convert the tables within the database to a CSV however I have to split the files into 10k result chunks otherwise the server gets overloaded with memory.

I already raised the memory limit within the script that is downloaded (ini_set('memory_limit', '512M') which is able to make this happen.

Downloading these files piece by piece is a really time consuming. Is there a memory safe and efficient way to combine all my tables as CSV's and into one zip them into one master download? PHPMyAdmin seems to do this smoothly, however, I need an online interface for the client to export the data directly...

Hey.   Got a slight issue, originally occured during the NodeJS version of the application, but it's also existing in the PHP version. (Yes, I have two versions, I know it's stupid) The issue at hand is that I've got a Script that calls an API for data around 5 times each time the script is executed. So imagine http://Mywebsite/mypath/generate

public function doGenerate() {
$restRequestHelper = new RestRequestHelper(...);
$data1 = $restRequestHelper->fetch(...);
...
...
$data5 = $restRequestHelper->fetch(...);
}

As you can imagine it hits a bit on the API's CPU since there's a lot of concurrent requests involving database operations. I know it's inevitable to optimize the API as well, but first I want to solve the client side of things, namely the mass refresh issue.   If a Client has entered /generate/ and starts refreshing the page over and over again (or a Client just sending GET requests), the script keeps going for however many times they've refreshed and eventually the API will crash. You can think of it as a DOS attack, sort of.   In the PHP version it's not nearly as harsh, but still harsh. It will keep doing it X amount of times and eventually show the response on the last request in the loop. In the NodeJS version, it's way worse. It's way faster, resulting in more concurrent requests on the API, making it crash faster. Same reason here, the spam.   Anyone got a good way of blocking this kind of behavior of the client? PHP or NodeJS solutions will help.    Think of the problem like this:

$requestCount = 0;
while($requestCount < 20) {
$data1 = $restRequestHelper->fetch(...);
$data2 = $restRequestHelper->fetch(...);
$data3 = $restRequestHelper->fetch(...);
$data4 = $restRequestHelper->fetch(...);
$data5 = $restRequestHelper->fetch(...);
$requestCount++;
}

Edited by Alex_, 13 November 2014 - 12:47 PM.

I have an auctions website and I want to create a feature that is similar to ebay in which users will receive an email if one of the auctions they are watching will end in less than 3 hours. I will be using a cron job to call up this page every 15 minutes. When the cron job executes, I would like it to send 1 email per auction to every user that has that auction on their watchlist if the auction will be ending in 3 hours. I don't know whether it needs to be a separate email for each user or one mass email where their emails are hidden.

The 4 tables in my database we are concerned about are "auctions, "users, "watchlists" and "products."

I am trying to use the script phpMailer to execute the code because I heard it was the best one. Anways here is what I have so far. I am missing alot because I had no clue what to do.


<?php
require("class.phpmailer.php");


$holder = mysql_connect("localhost", "user", "password");
mysql_select_db("database", $holder);

// NEED TO FIX THIS // Need to get ALL of the auction id's where the end time is less than 3 hours and the notification hasn't already been sent //
$auctionid = mysql_query("SELECT id FROM auctions WHERE DATE_ADD(NOW(), INTERVAL 3 HOUR) <= end_time AND notification = 0", $holder);

// get the auction title of  EACH of the auctions selected above which is not stored in the auctions table but in the products table..will be used for body of email /// AGAIN, NEED THIS TO GET ME ALL OF THE NAMES OF AUCTIONS THAT ARE ENDING IN 3 HOURS//
$auctiontitle = mysql_query("SELECT name FROM products LEFT JOIN auctions ON auctions.product_id=products.id WHERE auctions.id = $auctionid", $holder);

// PROBABLY NEED TO FIX THIS // Need to get ALL of the email addresses  who have ANY of the above auction ids on their watchlist //
$email = mysql_query("SELECT email FROM users LEFT JOIN watchlists ON users.id=watchlists.user_id WHERE watchlists.auction_id = $auctionid", $holder);

// Update the auctions table. Turn notification to 1 so the notification for that auction can't be sent again // AGAIN NEED THIS FOR ALL OF THE AUCTIONS ENDING IN 3 HOURS //
$query1="UPDATE auctions SET notification = '1' WHERE id = '$auctionid'";
mysql_query($query1) or die(mysql_error());



$mail = new PHPMailer();

$mail->From = "no-reply@domain.com";
$mail->FromName = "Site Name";


// Getting and error message for the foreach but I saw a similar example and this is what I was told to do // NEED THIS TO ADD EACH OF THE EMAIL ADDRESSES INDIVIDUALLY //
foreach ( $email as $recipients ) {
$mail->AddAddress ($recipients);
}
$mail->WordWrap = 50;                                 // set word wrap to 50 characters
$mail->IsHTML(true);                                  // set email format to HTML

$mail->Subject = "Your Watched Auction is Ending Soon";

// Sample Body // WANT TO DISPLAY THE TITLE OF THE AUCTION (NAME OF PRODUCT) FOR THE AUCTION ID USING $auctiontile FROM ABOVE //
$mail->Body    = "Your auction titled $auctiontile is ending soon";

// Same as above //
$mail->AltBody = Your auction titled $auctiontile is ending soon";


if(!$mail->Send())
{
   echo "Message could not be sent.";
   echo "Mailer Error: " . $mail->ErrorInfo;
   exit;
}

echo "Message has been sent";


?>

$sqld = "SELECT * FROM orders WHERE `id`='$delete' AND `name`='$inf2[name]' AND `email`='$inf2[email]' LIMIT 1";
$csql   = $db->query($sqld);
$ccheck = $csql->fetch(PDO::FETCH_NUM);
$cinf = $csql->fetch(PDO::FETCH_ASSOC);

$quantity = $cinf[quantity];
$code = $cinf[code];

$stmt11 = $db->prepare('UPDATE feeds SET quantity=quantity-:quantity WHERE code=:code');
$stmt11->bindValue(':quantity', $quantity, PDO::PARAM_STR);
$stmt11->bindValue(':code', $code, PDO::PARAM_STR); $stmt11->execute();

$id = $delete; 
$name = $inf2[name]; 

$stmt2 = $db->prepare("DELETE FROM orders WHERE id=:id AND name=:name"); 
$stmt2->bindValue(':id', $id, PDO::PARAM_STR); 
$stmt2->bindValue(':name', $name, PDO::PARAM_STR); 
$stmt2->execute();

OK, i have just been told i should start using PDO instead of mysql to update my tables. This code works to delete the order but doesn't update the feeds section.   All this is new to me so far and i think i am getting the hang of it. Should i still be using the quantity=quantity-:quantity or is there another way to do it with PDO?     Sorry, i posted this in the wrong forum. Hope someone here can help until it's moved
Edited by Self_Taught_Still_Learning, 30 May 2014 - 03:30 PM.

So, I am making a CMS for my school and I am having some trouble.

It's a magazine sort of CMS and what I want is that when you click on a certain thing it continues onto the next page. Through the CMS you can create pages - when you do this each page gets a unique PID. To access the pages you have to enter the PID on the end of the URL, e.g. : http://www.myschool.com/magazine/index.php?pid=x. What I need is a code that when an image gets clicked the PID number in the URL goes up by one.

Thanks

I'm back, I have a code that based on my understanding should work, but needless to say doesn't

<?php
$sql ="select * from `piprice`";
$result = mysql_query($sql);
$count = mysql_num_rows($result);

echo "<table border=1><tr><td>Product Name</td><td>Item ID</td><td>Price</td><td>Enabled</td>";
echo "<form action=main.php?id=test1.php method=post>";
while ($row = mysql_fetch_array($result)) {
echo "<tr><td>".$row['product name']."</td>";
echo "<td>".$id[] = $row['item id'];$row['item id']."</td>";
echo "<td>".$row['price']."</td>";
$enabled[] = $row['enabled'];
echo"<td><select name=".$enabled."><
<option Value=".$row['enabled'].">".$row['enabled']."</option>
<option Value=Yes>Yes</option>
<option Value=No>No</option>
/select></td</tr>";
}
echo "<input name=submit type=submit value=Update>";
echo "</form></table>";
if(isset($_POST['submit']))
{

for($i=0;$i<$count;$i++){
$sql1="UPDATE `piprice` SET `enabled` = '$enabled[$i]' WHERE `item id` ='$id[$i]'";
$result1=mysql_query($sql1) or die (mysql_error());

}
}
?>

Basically I want to be able to pick yes/no and have it update in the database.

One a side note is there a good site for me to learn php on (I just know the basics) besides asking 101 questions here 

Hi,

I'm using php to access the mysql database using mysqli and I have a field on my table called "timestamp" and it's set as a timestamp and has current_time (I think in phpmyadmin it was a tick option so I clicked it) and when I update that row in my table the field "timestamp" doesn't update with the timestamp from when it was last updated/modified. I thought the field option timestamp automatically did that? I'm guessing not.. is there a way I can update the timestamp with the current time in my query?

                 $query1 = "select * from movies where title = '".$title."' ;";
 $result1 = mysql_query($query1) or die('Could Not Execute The Query');
 while ($row = mysql_fetch_assoc($result1) )
                       {
                       for($f=0; $f<$parts[$current_k]; $f++ )
{
        touch("$base_folder/{$hos}/".$linking[$sum].".php");


$old_part_href = $row['href_parts'];

$updated_part = $old_part_href.$new; 
$query_href = 'update movies set href_parts = \''.$updated_part.'\'';
mysql_query($query_href) or die('COULD NOT EXECUTE THE QUERY FOR PARTS HREF');
$new = "{$base_folder}/{$hos}/".$linking[$sum].".php";


$sum++;
}
                      }

what i am trying to do is take the value of href_parts and add the new href of the page to the existing value on the href_parts and update the href_parts field in my db.. but i am not getting the desired results.. all i am getting in the db is the last value that is passed in the loop in the db.. i want to save the values which are exisiting in the db and add the newly created values to itt.. can anyone help please..

well here my page i tryed and tryed to get it working but it shows the data but it dont update it

Code: [Select]
[php]<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head><?php include "../config.php";

$id = $_GET['id'];
$con = database_connect();
$sql = "SELECT * FROM anime1 WHERE animeid ='$id'";
$result = mysql_query($sql);
while ($row = mysql_fetch_assoc($result)) {

$title = $row['title'];
$type = $row['type'];
$episode = $row['episode'];
$year = $row['year'];
$genre = $row['genre'];
$status = $row['status'];
$summary = $row['summary'];
$pictures = $row['pictures'];


}mysql_query($sql) or exit(mysql_error());
mysql_close($con);
?>

<script type="text/javascript" src="jquery.js"></script>
<script type="text/javascript">
$(document).ready(function(){
$(".flip").click(function(){
    $(".panel").slideToggle("slow");
  });
});

</script>
 
<style type="text/css">

</style>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Transdmin Light</title>

<!-- CSS -->
<link href="style/css/transdmin.css" rel="stylesheet" type="text/css" media="screen" />
<!--[if IE 6]><link rel="stylesheet" type="text/css" media="screen" href="style/css/ie6.css" /><![endif]-->
<!--[if IE 7]><link rel="stylesheet" type="text/css" media="screen" href="style/css/ie7.css" /><![endif]-->

<!-- JavaScripts-->
<script type="text/javascript" src="style/js/jquery.js"></script>
<script type="text/javascript" src="style/js/jNice.js"></script>
</head>

<body>
<div id="wrapper">
    <!-- h1 tag stays for the logo, you can use the a tag for linking the index page -->
    <h1><a href="#"><span>Transdmin Light</span></a></h1>
       
        <!-- You can name the links with lowercase, they will be transformed to uppercase by CSS, we prefered to name them with uppercase to have the same effect with disabled stylesheet -->
        <ul id="mainNav">
        <li><a href="#">DASHBOARD</a></li>
        <!-- Use the "active" class for the active menu item  -->
        <li><a href="./anime.php" class="active">Anime</a></li>
        <li><a href="#">DESIGN</a></li>
        <li><a href="#">OPTION</a></li>
        <li class="logout"><a href="#">LOGOUT</a></li>
        </ul>
        <!-- // #end mainNav -->
       
        <div id="containerHolder">
          <div id="container">
            <div id="sidebar">
              <ul class="sideNav">
                <li><?php echo $lbox1 ?></li>
                <li><?php echo $lbox2 ?></li>
                <li><?php echo $lbox3 ?></li>
                <li><?php echo $lbox4 ?></li>
                <li> <?php echo $lbox5 ?></li>
                <li><?php echo $lbox6 ?></li>
              </ul>
              <!-- // .sideNav -->
            </div>
            <!-- // #sidebar -->
            <!-- h2 stays for breadcrumbs -->
            <h2><a href="#">Anime</a> &raquo; edit &raquo; <?php echo "$title"; ?></h2>
            <div id="main">
              <form action="<?php echo $_SERVER['PHP_SELF']."?id=$id" ; ?>" method="post" class="jNice">
            <h3>Editing <?php echo "$title"; ?>, when finished click submit</h3>
              <fieldset>
                <p>
                  <label>Series Title -- (Put the Title of the Series you are adding into here)</label>
                  <input name="title" type="text" class="text-long" id="title" value="<?php echo $title ?>" />
                  </p>
                  <p>
                    <label>Type -- (Put what type of anime is it?)</label>
                    <select name="type" id="type">
                      <option selected="selected">Select one</option>
                      <option>TV Series</option>
                      <option>OVA</option>
                      <option>TV Special</option>
                      <option>Movie</option>
                      <option>Web</option>
                      <option>DVD Special</option>
                      <option>Other</option>
                    </select>
                  </p>
                <p>
                  <label>Episodes -- (How many Episode are there?)</label>
                  <input name="episode" type="text" class="text-long" id="episode" value="<?php echo $episode ?>" />
                  </p>
                <p>
                  <label>Year -- (What year was the anime release in?)</label>
                  <input name="year" type="text"  class="text-long" id="year" value="<?php echo $year ?>"  />
                  </p>
                <p>
                  <label>genre <a href="./genre">(click this for the list and FAQ for adding in genre)</a></label>
                  <input name="genre" type="text"  class="text-long" id="genre" value="<?php echo $genre ?>"  />
                  </p>
                  <p>
                    <label>status -- (What Is the status of the anime, Completed, Ongoing or Stalled)</label>
                    <select name="status" id="status">
                      <option selected="selected">Select one</option>
                      <option>Complete</option>
                      <option>Ongoing</option>
                      <option>Stalled</option>
                    </select>
                  </p>
                  <p>
                    <label>Summary -- (Put in the Summary for the anime)</label>
                    <textarea name="summary" cols="1" rows="1" id="summary"><?php echo $summary
 ?></textarea>
                  </p>
                <p>
                  <label>Pictures -- (link to the Anime Pictures you upladed)</label>
                  <input name="pictures" type="text" class="text-long" id="pictures" value="<?php echo $pictures ?>" />
                  </p>
                  <?php
  $con = database_connect();
  $sql="UPDATE anime1 
SET title='$title', type='$type', episode='$episode', year='$year', genre='$genre', status='$status', summary='$summary', pictures='$pictures' WHERE animeid = '$id'";


$con = database_connect();
$title = $_POST['title'];
$type = $_POST['type'];
$episode = $_POST['episode'];
$year = $_POST['year'];
$genre = $_POST['genre'];
$status = $_POST['status'];
$summary = $_POST['summary'];
$pictures = $_POST['pictures'];
$title = mysql_real_escape_string($title);
$type = mysql_real_escape_string($type);
$episode = mysql_real_escape_string($episode);
$year = mysql_real_escape_string($year);
$genre = mysql_real_escape_string($genre);
$status = mysql_real_escape_string($status);
$summary = mysql_real_escape_string($summary);
$pictures = mysql_real_escape_string($pictures);
error_reporting(-1);

if (!mysql_query($sql,$con))
  {
  die('Error adding anime database: ' . mysql_error());
  }





?>
                  <h3>&nbsp;</h3>
                 
              <?php

$con = database_connect();
$sql1 = "SELECT * FROM episodea WHERE animeid = '$id'
UNION ALL
SELECT * FROM episodeb WHERE animeid = '$id'";
$result1 = mysql_query($sql1);
while ($row = mysql_fetch_assoc($result1)) {
$ep = $row['ep'];
$epname = $row['epname'];
$animeid = $row['animeid'];
$video = $row['video'];
$video2 = $row['video2'];
$video3 = $row['video3'];

mysql_query($sql) or exit(mysql_error());





 
              echo "    <div class=\"panel\">\n";
echo "<p>\n";
echo "                         <label>Episodes -- (When this box says Anime episode finished, you have added in all the episodes)</label>\n";
echo "                         <input name=\"ep\" type=\"text\" class=\"text-long\" id=\"ep\" value=\" $ep\" readonly=\"readonly\" />\n";
echo "                       </p>\n";
echo "                       <p>\n";
echo "                         <label>Episodes Name-- (What is the name of the episode you are adding? --- If the episodes has no name enter episode number)</label>\n";
echo "                         <input name=\"epname\" type=\"text\" class=\"text-long\" id=\"epname\" value=\" $epname\" />\n";
echo "                       </p>\n";
echo "                       <p>\n";
echo "                         <label>Viewable -- (Is the episode your are adding in SUBBED or DUBBED or RAW?)</label>\n";
echo "                            <select name=\"viewable\" id=\"viewable\">\n";
echo "                            <option selected=\"selected\">Select one</option>\n";
echo "                             <option>SUBBED</option>\n";
echo "                             <option>DUBBED</option>\n";
echo "                             <option>RAW</option>\n";
echo "                            </select>\n";
echo "                           </p>\n";
echo "                       <p>\n";
echo "                            <label>Video 1 -- (enter the embed code for the episode you are adding in)</label>\n";
echo "                          <textarea name=\"video\" cols=\"1\" rows=\"1\" id=\"video\"> $video</textarea></p>\n";
echo "                          <p>\n";
echo "                            <label>Video 2 -- ( If you have a 2ed embed code </label>\n";
echo "                            <textarea name=\"video1\" cols=\"1\" rows=\"1\" id=\"video1\"> $video2</textarea>\n";
echo "                          </p>\n";
echo "                          <p>\n";
echo "                            <label>Video 3 --( If you have a 3ed embed code </label>\n";
echo "                            <textarea name=\"video4\" cols=\"1\" rows=\"1\" id=\"video4\"> $video3</textarea>\n";
echo "<h3>\n";
echo "<a href=\"#submit\">IF you finished editing ep, click me to go to submit button</a></h3>\n";
echo "                          </p>\n";
echo "</div>\n";
echo " \n";
echo " <br />";
echo "<br />";
echo "<p class=\"flip\">Click here to edit all Episodes For $title </p>\n";

echo " <br />";
echo "<br />";
  
   }
  ?>
  <h3>
                   
                   
            remember to click submit before changing the page</h3>
                  <h3>&nbsp;</h3>
                  <h3>
                    <a name="submit" id="submit"></a>
                    <input type="submit" value="Submit Query" />
                  </h3>
                </fieldset>
              </form>
            </div>
            <!-- // #main -->
            <div class="clear"></div>
          </div>
          <!-- // #container -->
      </div>
        <!-- // #containerHolder -->
       
        <p id="footer">Feel free to use and customize it. <a href="http://www.perspectived.com">Credit is appreciated.</a></p>
    </div>
    <!-- // #wrapper -->
</body>
</html>
[/php]

Okay, I have a useredit page in where a user can manage their account info. All the text field and SQL connections work fine, and they all update perfectly. But when I go ahead and add my own text field (first name) and hit submit, it says success - but in my SQL it hasn't actually updated ... What the Ef?

Here are my snippets of my codes:
--useredit.php--

<form action="process.php" method="POST">

<input type"text" name"firstname" value="<? if($form->value("firstname") == ""){    echo $session->userinfo['firstname']; }else{    echo $form->value("firstname"); } ?>">

<input type="hidden" name="subedit" value="1">
                        <input type="submit" value="Edit Account">

--process.php--

function procEditAccount(){
      global $session, $form;
      /* Account edit attempt */
      $retval = $session->editAccount($_POST['curpass'], $_POST['newpass'], $_POST['email'], $_POST['firstname']);

      /* Account edit successful */
      if($retval){
         $_SESSION['useredit'] = true;
         header("Location: ".$session->referrer);
      }

--session.php--

function editAccount($subcurpass, $subnewpass, $subemail, $subfirstname){
      global $database, $form;

if($subfirstname){
         $database->updateUserField($this->username,"firstname",$subfirstname);
      }

--database.php--

 function updateUserField($username, $field, $value){
      $q = "UPDATE ".TBL_USERS." SET ".$field." = '$value' WHERE username = '$username'";
      return mysql_query($q, $this->connection);
   }


If you need to see more code, let me know.

Would appreciate the help, thanks!
Ollie!

i have this small problem trying to update the database....

what i have is a members site in which they can view a variety of topics, however i want the user to be able to say delete a topic they are not interested in but still keep that topic open to other users who have not blocked it

I'm tying to figure out how to do this, i initially had the following code:

$update_db = mysql_query("UPDATE topics SET view='2' WHERE topicID='$topicID'") or die(mysql_error());


I had it set to to 2 meaning that all the topics that were set to 1 were visible to the user, only those they blocked were set to 2 and only be blocked to those users who blocked them not everyone

The problem with that was that it blocked it to everyone

Can anyone help me?

Hi all, for my website ive got a fuel station which ive coded so users can fill up there there car fuel tanks, but the code all works part from one part of it.

The code:

The part of the code which isnt working:

<?php
$usermoney = $fetch->money;
$costs2 = $fetch_fuelstation->price * $fueldiff;
if ($costs2 > $usermoney){
echo "You dont have enouth money.";
} elseif ($costs2 <= $usermoney){
$nmoney = $usermoney - $costs2;

mysql_query("UPDATE users SET money='$nmoney' WHERE username='$username'") or die (mysql_error());
}
?>

Ive got a varibal called $usermoney which selects the users current money from the database, but what im trying todo is take the fuel price away from there current money, but its not subtracting the money as it should.

Anyone see why its not taking the money?
Thanks.

Hey Guys,

Im slowly updating our website to php/mysql, im getting there slowly but stuck at the minute. Im try to create a form where we can edit one of the pages text and then update the text in the database if that makes sense 

Basically at the moment i have a form where you can see the pages text like so:

<table width="400" border="0" align="center" cellpadding="3" cellspacing="1">
<tr>
<td><strong>Edit About Us English </strong></td>
</tr>
</table>

<table width="400" border="0" align="center" cellpadding="0" cellspacing="1">
<tr>
<td><form name="form1" method="post" action="send_update_english.php">
<table width="100%" border="0" cellspacing="1" cellpadding="3">

<tr>
<td>Detail</td>
<td>:</td>
<td><textarea name="detail" cols="50" rows="4" id="detail">

[b]<?php

mysql_connect("localhost", "web148", "123") or die(mysql_error());
mysql_select_db("web148") or die(mysql_error());

mysql_query("SET names 'utf8'");

$result = mysql_query("SELECT body FROM aboutenglish WHERE ID = '1'");


$row = mysql_fetch_array( $result );

echo nl2br($row['body']);


?>[/b]

</textarea></td>
</tr>
<tr>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td><input type="submit" name="Submit" value="Submit"> <input type="reset" name="Submit2" value="Reset"></td>
</tr>
</table>
</form>
</td>
</tr>
</table>

Ive got that php bit in the middle to pull out the text thats on that page but not sure if thats correct or not. But anyways on the 'send form' page i have:

<?php

// Details
[b]$message="$detail";[/b]

mysql_connect("localhost", "web148", "123") or die(mysql_error());
mysql_select_db("web148") or die(mysql_error());

mysql_query("SET names 'utf8'");
$result = mysql_query("UPDATE aboutenglish SET body = '$message' where ID = '1'");


?>


the update query works if i put text in there, but when i use '$message' the database is left blank.


This is only my second week doing all this stuff, so bare with me 

I appreciate your answers.