Welcome Guest, Not a member yet? Register   Sign In
need help vor mySQL Query!!
#1

Aloha,

I have a sql query looks like this 1:1 test query this is it how I have to used it.

Code:
insert into files (created,name,timestamp)values (now(),'xxxx', '2015-08-26 00:00:00')
ON DUPLICATE KEY UPDATE created=NOW(),status='NEW';

and I like have it so ,for exampel.

PHP Code:
public function get_select_file() {
 
$this->db->select 'id' );
 
$this->db->from 'table' );
 
$this->db->where 'name''xxxx' );
 
$this->db->where 'timestamp''2015-08-26 00:00:00' );
 
$query $this->db->get ();
 return 
$query->result_array ();
 } 

or some thing like this pleas help my !!
Reply


Messages In This Thread
need help vor mySQL Query!! - by Harry05 - 09-04-2015, 10:05 AM
RE: need help vor mySQL Query!! - by rtorralba - 09-04-2015, 11:20 AM
RE: need help vor mySQL Query!! - by Harry05 - 09-11-2015, 02:18 AM



Theme © iAndrew 2016 - Forum software by © MyBB