Hello! The table name is 'pages'.. I need to make a search function, where I can submit the field $_POST['search']['s_value'] and check if it is LIKE the fields 'emne' or 'tekst'.. But in that matter I would also like, that my query is ordering by the percentage of matching.. So if I'm searching for "car rental" and I have a page whic...
Just to give you an example: I have a PHP script that manages users votes. When a user votes, the script makes a query to check if someone has already voted for the same ID/product. If nobody has voted, then it makes another query and insert the ID into a general ID votes table and another one to insert the data into a per user ID vote...
Hi guys, So I have a function as detailed below, I believe it is too long and can be shortened. I think I have fallen over in the array manipulation part. Please ignore the strange database syntax So basically this function is given a string like this abc, def, ghi, jkl, mno due to some glitches it can be received with an extra...
Hi there... I have the following table using the MySQL adjacency list model: id | parent | name | order ----------------------------------- 1 | 0 | Kitches | 1 4 | 0 | Chairs | 2 5 | 0 | Sofas | 3 43 | 4 | Blue | 1 44 | 4 | Red | 2 Implemented the Jquery nestedSort...
Hello, I have a curious problem that I hope is something stupid I overlooked. I am getting an error that usually occurs when there is a missing column in a mysql table, or a misspelled php variable: "Unknown column 'Bob' in 'field list'"... Except 'Bob' is not the name of a column, its the VALUE I am trying to assign to the row. Why ...
I'm trying to count how many created vs published posts there are per user in my database. POST ID | USER ID | STATUS ...and an example would be User ID 1 has 5 posts (5 distinct post IDs) with 3 STATUS = CREATED and 2 STATUS = PUBLISHED. I want the output to show the following columns USER CREATED PUBLISHED ---------------...
Hi all, I'm an mssql veteran who's received a job that involves tuning a mysql db. with mssql it was simply a matter of firing up the db profiler and then crunching up the data it collects. I can't seem to find anything similar for mysql. thanks in advance ...
Possible Duplicate: What is the best MySQL Client Application for Windows i am used to using tools like SQL Enterprise Mgr for SQL Server databases and Toad for Oracle. I now (for a few reasons) need to start working with MySQL. What is the best desktop front end for MySql databases? ...
Hello i have a string that is stored in my database separated by comma eg: (new south wales,Queensland,etc,etc) Know my problem is when i try to search Queensland i am not able to get the result but when i try to search for new south wales i get the record. But i want to get the result when i try to search for queen or etc. I am new to ...
Hello everybody, this is a simple question. I have to develop a Real Estate website and i'm trying some alternatives. Have you ever try to develop a Real Estate on Drupal? Have you any concrete thought about how could it be done? Thanks!!!! ...
Hello, I am outputing a simple list of options from dynamic select menus using Codeigniter/MYSQL. CONTROLLER $data['get_custom_fields'] = $this->db->query(" SELECT a.custom_field_name, a.custom_field_id, GROUP_CONCAT('<option name=\"',c.custom_field_value_id, '\" value=\"', c.custom_field_value_id , '\">',c.custom...
Is it possible to prevent someone other than those allowed from tampering with the database. I guess I am asking if there is an method other than the database login to hamper people from tampering with the database? I am aware of privileges and how only access to certain parts of the database for certain users. I am looking for something...
<?php // MySQL database connection file $SERVER = "127.0.0.1"; // MySQL SERVER $USER = "root"; // MySQL USER $PASSWORD = "admin"; // MySQL PASSWORD $link = @mysql_connect($SERVER,$USER,$PASSWORD); $db = mysql_select_db("website"); ?> This is a database connecting code for chat program but it not connecting,Can any one ...
This is a follow-up question to this question. Sphinx mentions on the downloads page: Note that 'beta' only applies to new features (RT indexes etc), everything else is stable. What is the "etc" in the new features? ...
Is there a way to see all generated queries from rails in production environment like you can in development? ...
Hello. Working with Drupal 6, my goal is to order a set of threaded comments similar to how Facebook outputs comments: with the 'anchor' or first comment in each thread sorted DESC, and any 'internal' thread replies sorted ASC so the newest comments are at the bottom. Here's the SQL query from comment_render, with ordering by COMMENT_OR...
i want to show some data in percent. i have a mathematics formula like: (qty(S) + qty(B))/qty(id)*100% could i show the result for example like 25%? how do i do that? ...
Hey guys, I suppose this is partially subjective in that it's probably dependent on everyone's interpretation of "high volume", but for the sake of discussion, I'd like to approach this in a hypothetical way. Also, if this is something that should be exclusive to ServerFault, let me know and I'll happily repost there. Obviously there ...
I'm running the following query, which tells me which agents have ever been scheduled on a project at location 51: SELECT agents.agentid, agents.firstname, agents.lastname, schedule.projectid, projects.locationid FROM agents LEFT JOIN schedule USING (agentid) LEFT JOIN projects USING (projectid) WHERE (projects.locationid <=> 51)...
So I started off with this query: SELECT * FROM TABLE1 WHERE hash IN (SELECT id FROM temptable); It took forever, so I ran an explain: mysql> explain SELECT * FROM TABLE1 WHERE hash IN (SELECT id FROM temptable); +----+--------------------+-----------------+------+---------------+------+---------+------+------------+-------------+ | ...