catalinetu

Hello Guys I want to insert into two tables with one query in mysql the first table contains a primary key and other stuff the second table contains a foreign key and other stuff I'm wondering how this would happen ? and if so how would be the query of …

Hello to everyone, I am trying to get a some values from the database. My issue is that I want some results stored into a variable to be exactly 25 caracteres long. When the result($title) is > 25 caracters long there is no problem with this substr($title, 0, 24), but …

i got complete details in html table and willing to update 2 values

use people; SELECT 'first' UNION SELECT first from e where skills regexp "javapl" INTO OUTFILE '/home/ankit/csv/tablename.csv' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n'; this runs without problem to /var/tmp folder but other folders gave error:13 can't write please help

Hello, I am trying to create a table in MySQL with the following data: $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) )"; However, I keep getting a syntax error. Can someone pls. …

Hi ! I need to have a single mysql query which should get COUNT of two different values in a single field, suppose i have a field in a table 'approved', and there are only two values ie. approved=0 or approved=1, and have suppose 100 rows for them,so how to …

I know that libraries contain functions for certian fields of work but what is a framework? Is it simply just a collection of libraries?

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 I have use 'LIKE' query in Model $this->db->like('job_title','keywords','both'); $query = $this->db->get('job_description',$data); which generate Query Output like SELECT * FROM (`job_description`) WHERE `job_title` LIKE '%keywords%' LIMIT 1 **Problem:** How could i remove the LIMIT that automatic generate in Query **OR** can i given Infinite LIMIT in CI Query. Can you …