Jump to content

[SOLVED] PHP HELP


neverett

Recommended Posts

Hi all.  I'd appreciate any help in advance.  I've included some code of an insert function.  What I'm trying to do is insert fields into my table row (done with the insert function).  I have a $submit_date as well and I want to update it b/c I intentionally left it blank in the $sql = "..." (it would normally come after $eval).  Thus it shouldn't have a value.  So I'm trying to update the $submit_date value in the same row that was just inserted.  So basically I'm updating the row that was just inserted in $sql="...".  But when I run the function without the WHERE o_id = '$o_id'" it updates every $submit_date value.  I thought the code below would work, but it apparently doesn't know the value for $o_id (which is inserted as a NULL b/c it's incremented automatically in the table itself).  Please let me know if there is anyway to gather the value of $o_id (which is inserted as a NULL but assigned a number in the table) and then apply the WHERE o_id = '$o_id' to the update.  The reason I'm doing this is b/c the server we are using is hosted on the West Coast (Pacific Time) and I'm wanting to change the time to Eastern Time.  This is the only way I could think of to change the time zones without having to change something every time the daylight savings time begins or ends.  Please email me at [email protected] for any ideas or reply to this post please!  Thanks for all of your help!

 

// insert an OTM
	function insert(){
		$s_id = $this->s_id;
		$school = $this->school;
		$population = $this->population;
		$region = $this->region;
		$nom_name = $this->nom_name;
		$nom_address = $this->nom_address;
		$nom_email = $this->nom_email;
		$prog_title = $this->prog_title;
		$prog_date = $this->prog_date;
		$target_pop = $this->target_pop;
		$attendance = $this->attendance;
		$time_to_org = $this->time_to_org;
		$people_to_org = $this->people_to_org;
		$cost = $this->cost;
		$prog_desc = $this->prog_desc;
		$prog_goals = $this->prog_goals;
		$publicity = $this->publicity;
		$rl_goals = $this->rl_goals;
		$goal = $this->goal;
		$outcome = $this->outcome;
		$effects = $this->effects;
		$eval = $this->eval;
		$sql = "insert into otms values('NULL', '$s_id', '$school', '$population', '$region', '$nom_name', '$nom_address', '$nom_email', '$prog_title', '$prog_date', '$target_pop', '$attendance', '$time_to_org', '$people_to_org', '$cost', '$prog_desc', '$prog_goals', '$publicity', '$rl_goals', '$goal', '$outcome', '$effects', '$eval')";
		$result = mysql_query($sql);
		$result = mysql_query("UPDATE otms SET submit_date = FROM_UNIXTIME(UNIX_TIMESTAMP()+10800) WHERE o_id = '$o_id'");
		return $result;
	}

Link to comment
https://forums.phpfreaks.com/topic/68309-solved-php-help/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.