Php and Mysql problem

[Anon]

Ok what i'm trying to do is look at a database and see if a certain entry exists if it doesn't exist to create it and add some info, but if it does exist to update the info this is what i have.

$query = "SELECT * FROM table WHERE filename = $file_name";
$exist = mysql_query($query, $mysql_link);

if(!$exist){
$create_query = "INSERT INTO file_rating (value1, value2, value3) VALUES ('$value1', '$value2', '$value3')";

$create = mysql_query($create_query, $mysql_link);

}
else{
$get = mysql_fetch_array($exist);
$score = $get['value1'];
$score += $rating;
$numaccess = $get['num_access'];
$numaccess++;
$update_query = "UPDATE file_rating SET num_access = '$numaccess', total_score = '$score' WHERE filename = '$file_name'";
$update = mysql_query($update_query, $mysql_link);
}

[Anon]

the variable are off, i was changing them to help with this post, actually num_access should be value1 and filename = value2 and so forth, sorry for the confusion, all i would liek to know.

[Anon]

And is it working? Or is there an error? If so, what error?

Please give all details of the question to allow someone to help.

Thanks

D

[Anon]

Oh yea that would help wouldnt it? Ok, what i get is it always goes into the first if statement even when it exists on the database. So there would be multiple instances of it. I've tried a few things, like instead of putting if (!exist) i put
if (exist == "") or if(my_errno()) and i couldn't get any of those to work. if i use mysql_num_rows(exist) i get an error message stating that it can't find that particular thing in the database. kind of stumped

[Anon]

did you try mySQL 'REPLACE INTO table...'?

see http://www.mysql.com/documentation/manual.php?section=REPLACE

[Anon]

I guess your problem is you're checking the result (which has no effect) rather than the row count IN that result. You should not say:

if (!$exist){
// Blah blah blah
}

But use:

if (mysql_num_rows($exist) > 0) {
// Update
}
else {
// Create
}

Hope this helps you through.

Greetz,

Vincent Driessen
Venlo, The Netherlands