Welcome Guest, Not a member yet? Register   Sign In
Inserting data
#1

[eluser]nws123[/eluser]
Hello.
How in "Codeigniter style" make these query's

Code:
mysql_query("UPDATE mailng_list SET name = '$name', surname = '$surname'
WHERE mail_id = '$mail_id' AND userId = '$userId' ");

mysql_query("UPDATE mailng_list_entry SET email = '$email'
WHERE mail_id = '$mail_id' ");

i know userId and mail_id

More information:

mailng_list
===========
mail_id
userId
name
surname


mailng_list_entry
=================
mail_id
email

relationship: mailng_list.mail_id -> mailng_list_entry.mail_id (LEFT JOIN)

Any help please.
#2

[eluser]sl3dg3hamm3r[/eluser]
CI's active record class is very well described. Why not give it a try reading first?
#3

[eluser]James Bolongan[/eluser]
Hello......

Code:
$this->db->query("UPDATE mailng_list SET name = '$name', surname = '$surname'
WHERE mail_id = '$mail_id' AND userId = '$userId' ");

$this->db->query("UPDATE mailng_list_entry SET email = '$email'
WHERE mail_id = '$mail_id' ");

Just try to read the Database Class in code igniter user guide....just have fun in CI...its really good to have this framework..




Theme © iAndrew 2016 - Forum software by © MyBB