catalinetu

You can make a trigger on insert in first table to make an insert in the secound one.

Hello, You can try this: $initialtitle = 'ABCDEFGHI'; $title = str_pad($initialtitle, 25," ");

Hi, You need a php code that updates db from a form like tis? <?php db_conect(); $action = isset( $_POST['action'] ) ? $_POST['action'] : ""; if($action == "update"){ $query = "update city set name = '".$con->real_escape_string($_POST['name'])."', state = '".$con->real_escape_string($_POST['state'])."', population = '".$con->real_escape_string($_POST['population'])."', zipcode = '".$con->real_escape_string($_POST['zipcode'])."', area = '".$con->real_escape_string($_POST['area'])."', phone = …

It is probably a permission issue Privileges should be : drwxrwxrwt so anybody, including the "mysql" user, can use it. If is not like this you have to run this command from terminal: chmod 0777 /home/ankit/csv Hope this helps!

The sql is creating the table, but why are you using $ in the table name? Maybe you want to do this: <?php $sql = "CREATE TABLE ".$uID." ( Col0 int(10) NOT NULL auto_increment, Col1 varchar(255) NOT NULL, Col2 varchar(255) NOT NULL, Col3 varchar(255) NOT NULL, PRIMARY KEY(Col0) )"; ?

hi, you can try this SELECT SUM(approved) `ones`, COUNT(*)-SUM(approved) 'zero' FROM `table`

Hello, You can find your answer on wikipedia > In computer programming, a software framework is an abstraction in which software providing generic functionality can be selectively changed by additional user-written code, thus providing application-specific software. A software framework is a universal, reusable software platform to develop software applications, products …

I am a junior PHP programmer trying to improve my knowledge in OOP. I have some experience in HTML, CSS, PHP and MySQL but mainly in small projects. It's nice to meet you guys.

Hello, Try this: $query = $this->db->get('mytable', 10, 20); // Produces: SELECT * FROM mytable LIMIT 20, 10 (in MySQL. Other databases have slightly different syntax) or this $query = $this->db->get_where('mytable', array('id' => $id), $limit, $offset);