insert data from ....

[trigger8]

How do I insert data from titletext1 and bodytext1 into combined1 (same to all the rows)?


id title body combined
-------------------------------------------
1 titletext1 bodytext1 combined1
2 titletext2 bodytext2 combined2
3 . . .
4 . . .

[MattR]

What you want is to "update" each *existing* row in the database.

this would be done something like this:

UPDATE table
   SET combined = title + body

Or I think you may need to use the concat function.

[cupid]

If there's a single operation in mysql that you can use like MattR had suggested (you can tell that my mysql knowledge is lacking ;p), you'd want to use that. The following is another approach.

$query = mysql_query("select id,title,body from tablename");

while ($result = mysql_fetch_object($query)) {

  mysql_query("update tablename set combined1='".$result->title.$result.body."' where id='$result->id'");

} 

[Paul S]

Try this,

$sql = 'SELECT id,title,body FROM yourtable';

$result = @mysql_query($sql):

if ($result) {
  while ($row=mysql_fetch_array($result)) {
      $combined = $row['title'].$row['body'];
      $sql = "UPDATE table SET combined='$combined' WHERE ID=".$row['id'];
      if (@mysql_query($sql))
         echo "Rows combined\n";
      else
         echo "Database problem\n";
  }
} 

I'm assuming that by combined you mean just merge title and body fields. It's that not what you want, change line $combined = $row['title'].$row['body'];

[Paul S]

Wow, so many options

[trigger8]

Is there anything wrong in the following script?

<?
MYSQL_CONNECT($hostname, $username, $password) OR DIE( "Unable to connect to database");
@mysql_select_db("$dbName") or die(  "Unable to select database"); 

$sql ='SELECT id,Topic,Frequency,Heading FROM tablename'; 

$result = @mysql_query($sql);

if ($result) { 
while ($row=mysql_fetch_array($result)) { 
$combined = $row['Heading'].$row['Topic'].$row['Frequency']; 
$sql = "UPDATE table SET keyword='$combined' WHERE ID=".$row['id']"; 
if (@mysql_query($sql)) 
echo "Rows combined\n"; 
else
echo "Database problem\n";
} 
}
?>

[trigger8]

Now I got it right.

But how do I seperate the values from each columns so that they don't really combined together.

The output that I get now is 'text1text2text3'. How to make it 'text1 text2 text3'?

Also, Is there anyway to only insert text without special characters..like \()_-...

Thanks!

[Paul S]

Hi,
you can do it by adding,
$combined = $row['Heading'].' '.$row['Topic'].' '.$row['Frequency'];