Using the REPLACE INTO command

[jwduncan]

I have a PHP script that takes data from the variable "HomeFirstLine" and puts it into the field "HomeFirstLine" in the table "calendar" in the database "test". How can I update/replace the info that is put into row 1 every time the variable "HomeFirstLine" is changed? Right now the script below is adding the changes to the variable into row 2, row 3, etc., instead of replacing what is in row 1.

Below is the script I am using:

<?php

//Setup and connect
$server="localhost";

$user="myusername";

$pass="mypassword";

$flashbase ="test";

$bilz_table="calendar";

//Make the connection
$hookup = mysql_connect($server, $user, $pass);

//Select the database
mysql_select_db($flashbase,$hookup);

//Variables from Flash become data for MySQL ($HomeFirstLine)

$sql="REPLACE INTO $bilz_table (HomeFirstLine) VALUES('$HomeFirstLine')";
mysql_query($sql,$hookup);

?>

Thank you for your help!

[Pig]

UPDATE $bilz_table SET HomeFirstLine = '$HomeFirstLine' WHERE id='1'

this assumes that you have an id column.

[jwduncan]

Thank you so much!!! It works!!!! You don't know how many times I have asked people this question and they give me everything but the right answer. Thank you again! I really appreciate this. I've been trying to get this working for over 2 weeks.

[Pig]

np