7,368 Topics
| |
Hi Guys, I am looking to query a db having multiple brands of cars then from those results I want to further filter it based on the type of oil they use. I have written the below but it does not work and I am not sure how I can … | |
hello all i have allready created table and wan to add Composite primary key into that so for that i am using following statement [CODE] ALTER TABLE pqrimasterdetail ADD primary key (PQRIMasterID,Type,Year,PhysiciansID);[/CODE] but in not executed successful it gives the query could not be Executed. Multiple Primary key Defined if … | |
Hi all fri, i'd like to know how to pro-grammatically insert variable data to MySQL database . I m succeed in fixed data insert only. i wanna import variable data which might be generated by user on run time. Here's my code. I use MySQL Command Line Client . It … | |
Hello friends. I need a good article or book that compare storage engins _such as MyISAM, InnoDB, Falcon and etc_. if any one know a good source please introduce me. Tanks if help me. | |
Im having trouble importing the text file from my desktop into the database,i tried it both ways but it doesn't seem to work, does the file have to be somewhere specifically for it to import. please help [code] load data local infile 'userdata_import.txt' into table tags fields terminated by ',' … | |
Hi All. I am building a project assuming that there is a mehtod for intercepting incoming and outgoing mail from a mailserver. If it is not possible please let me know, I am new working with mail servers, so any material that you could provide would be greatly appreciated. I … | |
Hello all, This isn’t a strictly MySQL issue, it has to do also with PHP Apache and cPanel but I believe the core is MySQL so I decided to post it here. Recently I had a SQLSTATE[08004] [1040] Too many connections issue. I use PHP PDO for the connection and … | |
Hi, we are running mysql 5.0.16-nt in windows 2003 server... we are getting frequently some warnings in the event viewer like "Changed limits: max_open_files: 2048 max_connections: 450 table_cache: 794" Once this warning arise, then the site has broken indicating "too many connections".. I have gone through many of the threads … | |
I've been knocking my brains for a while with this one. I need to search a particular table for any records that contain an equal sign [B][COLOR="Red"]=[/COLOR][/B]. This works for any criteria except [B][COLOR="Red"]=[/COLOR][/B] : [CODE]SELECT id, mystuff FROM db1_user WHERE email LIKE '%=%'[/CODE] | |
please help me to correct my answer: [B] STUDYCASE:[/B] The Following tables from part of a database held in a relational Database Management System (DBMS). Hotel ([U]HotelNo[/U], HotelName, City) Room ([U]RoomNo[/U], [U]HotelNo[/U], TypeHotel, Price) Booking ([U]HotelNo[/U], [U]GuestNo[/U], DateFrom, DateTo, RoomNo) Guess ([U]GuestNo[/U], GuestName, GuestAddress) Note: Underlined words is primary key … | |
Hi everyone. I'm using sqlite3 in Linux and I currently have a problem. I have a database and 2 tables in it: db1 and db2. db1 has 3 columns: empID, empName, empAddr. db2 has just 1 column: empID and its value is set to 0 by default. I created a … | |
I really want this echo to not include people not listed as 1 in the row "activated" in my database. So if its 0 they wont show. [CODE] // Print each user while($row = $result->fetch_assoc()) { echo " <tr> <td>{$row['username']}</td> <td><a href='{$row['website']}' class='example7'>{$row['website']}</a></td> <td align='center'>{$row['disabled']}</td> </tr>"; } // Close table … | |
I want to export some of the records of a table to a file in Linux. Is there any command for this? | |
Hello Friends, I've around 1000 records in mysql database. in content table im using image source url like 'img.mydomain.com' so today I've registered new domain. so i want to find replace following domain and update my new domain in image path url. so please let me know how to find/replace??? … | |
THe project is about to design a calender (that should be embedded on a website) that will be able to read from database and pick up event for chosen day and place | |
This looks like a repeat of a previous thread, but I still haven't cracked it. I'm doing everything on a single Windows XP pc, so no servers or clever stuff involved. I blew the space on MS Access so I'm attempting to return to plan A of using MySQL. Installed:- … | |
the problem is that its an undifined varible ($last) intill i type the second word, i [code=php] if($_POST) { $q=$_POST['searchword']; $q = explode(' ', $q); $first = $q[0]; $last = $q[1]; $sql_res=mysqli_query($mysqli, "select * from dogs where firstname like '%$first%' and lastname like '%$last%' order by id LIMIT 5"); while($row=mysqli_fetch_array($sql_res)) … | |
| Hi, After completing a PHP website, with html, javascript and mysql connections - What can I do to ensure good security and what threats should I be aware of? Thanks, Ashton. |
I am creating a website where when an unregistered user comes to the site they'll only be able to access a limited amount of the site. It's only when they pay for access to the site that they can receive the full content. I'm wondering how I should go about … | |
Hi, I need some help with this MySQL Update I've got three tables as below. tbl1 id eid quantity 1 3 2 2 4 3 tbl2 tid eid qnty status type 1 3 1 1 1 2 3 0 1 0 3 4 1 1 1 4 4 0 1 … | |
Hi, I am working on a script that populates a table with a user's news entries. First I get the username from the URL, then go to the database and get the user_id. From the user_id, I query the news table for the user's news entries. [CODE] $idgrabber = "select … | |
| Alright this is a little hard to explain, but I have two tables of very different data. Both tables have a date timestamp. The timestamps are not going to match, but I need to join table2 on to table1 via the next date equal to or less than. So.. Table1 … |
I cannot get this mysql update query to work. Please help. I am new at this.:) <?PHP session_start(); ?> <?php //it's getting the data from the post fine. I know this part is working. $ud_id=$_POST['ud_id']; $ud_fname=$_POST['ud_fname']; $ud_lname=$_POST['ud_lname']; $ud_type=$_POST['ud_type']; $ud_used=$_POST['ud_used']; $ud_sdate=$_POST['ud_sdate']; $ud_edate=$_POST['ud_edate']; if ($ud_id == "") echo " No record ID … | |
am using MySQL database. When I execute a query which the main table(20 thousands of rows) is joined with the other 5 tables, it takes 90 seconds to return me the result. I then added indices into each of the criteria(where clause). Then the execution time drops from 90 seconds … | |
Let's say that I want to retrieve rows from just one table and exclude rows with certain ID's. Hypothetical table: [CODE] +----+-------+------+ | id | value | type | +----+-------+------+ | 1 | foo | cool | +----+-------+------+ | 2 | bar | cool | +----+-------+------+ | 3 | lor … | |
Hello, I have a mysql field that is a blob and I use encode to encrypt the values for that field. One of the values is: 62756d7069886d66 When I use the salt: ulabula to decode it via phpmyadmin, the correct value returns: 62756d7069886d66 However when I do the exact same … | |
Hello! I run SQL queries from JAVA program (an example is shown below). My question is: Is it possible to run SQL query, if column names are defined in an array and the array size is not known apriori? Thanks! [CODE] public void setQuery(String query) { try { int rs … | |
Hello! I’ve got three tables that I want to link together. When I try to upload images and text throught a form, the web browser show this error message: [QUOTE]Error, query failed 1452-Cannot add or update a child row: a foreign key constraint fails (`mn000532_almacen`.`images`, CONSTRAINT `images_ibfk_1` FOREIGN KEY (`itemID`) … | |
[CODE]<?php include("includes/connection.php");?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <title>Untitled Document</title> </head> <body> <?php echo $sql= "SELECT * FROM forms WHERE today >= CURDATE() - INTERVAL 30 DAY"; $result=mysql_query($sql); while($row=mysql_fetch_array($result)) {echo $City= $row['City']; echo $Name=$$row['Name'];} ?> </body> </html> [/CODE] i just … |
The End.