MySQL problem w PHP Code

perrio

Can anyone tell me why this code does not UPDATE my imagepath field. ( I have tested and tested this and it won't work, even though mysql_query() returns 1 and prints to a text file show the query text string is accurate)(imagepath is of type text)

function remove_image_by_update(){

$c = $this -> certificate_code;
$d= $this -> viewandedit_id;

$query = "UPDATE ac_details SET imagepath = '#' WHERE cert_code = '$c' AND un_id = '$d'";

$g = mysql_connect("glider.pxxg.com","je","pasword");

mysql_select_db("charter_db");

$result2 = mysql_query($query, $g);
mysql_close();

paulnaj

The actual SQL looks OK, but have you tried just printing it to the browser to check.

One possible problem (could be just how this forum has laid out your code):

This ...

$c = $this -> certificate_code;

... might have to be ...

$c = $this->certificate_code;

... with no spaces.

Also, it's not clear here what the $this is referring to ... is this a class method?

perrio

THe call to the method (function) with the apparent problem was actually ok. There is a list of manipulations for my form validation that calls on this method THEN it resumes and if no errors it updates or inserts all new values into the db.

WHat i had to do was to UNSET the variable immediatly after the call to update/insert (in another method). (i am using sessions so all values maintain state -from previous transactions and the effect of my problem was double writing to the db)

My technique to validate form data uses one where by I post to a short script that calls the validata function with HTTP_POST_VARS as an argument. THen uses the header(Location: ) function to have my browser redirect back to the form (at the top of the form i check for errors if so then i load them if not then i refresh the form - everthing was ok)

any suggestions , i just think it seems a little ineficcient to have my browser make an additional request. as this is a trend I use , with authentication, other forms, etc...