[Resolved] Problem with inserting data into a database

hsob

Could anyone tell me why this is not inserting into my database.This part of my code is to overwrite information that is already stored in the database. So im trying to overwrite it by where the id is eqaul to the row clicked on.
It is taking in the id alright. Im not sure why it isnt inserting into the database.Could anyone help me with this please? thank you

<?php

$id = $_GET["filmID"];
echo $id;

<br><br>

<?php $db = mysql_connect("", "", "");
mysql_select_db("",$db);

# $query contains the SQL statements that will be executed by MySQL

$query = "INSERT INTO CurrentlyShowing (film_name,showing_times,screen_number,official_url,film_image,age_rate) VALUES ('$film','$time','$screen','$link','$image','$rate') where filmId='$id'";
echo $query;

if(mysql_query($query,$db))
	{ echo "<br>Insert successful<br>\n"; }
	else
	{ echo "<br>Insert  not successful<br>\n"; }

/* Closing connection */
mysql_close($db);

nlhowell

Well, I don't know how you're overwriting the data, but if you're just replacing a record, you'd be better off running an UPDATE query:

UPDATE table SET field1='value',field2='value2',field3='value3' WHERE id=1;

I think that's right; someone correct me if I'm wrong.

Assuming you have a primary key on the id field, you can't insert a record if one with the same value already exists; each record has to have a unique id. You'll either have to run an UPDATE query, or run a DELETE query (DELETE FROM table WHERE id=1😉 and then an INSERT query (INSERT INTO table (id,field1,field2,field3) VALUES (1,'value','value2','value3')😉.

Nick

[edit]Damn those smilies[/edit]

hsob

That is great. Thank you