Hello. I already have done this: mysql_set_charset("utf8",$link); at the connection mysql_query("SET NAMES 'UTF8'"); at the connection + on every table in database changing from latin1 to utf8 collation + character for every table + columns file have meta utf8 + header('Content-Type: text/html; charset=utf-8'); plus the files itself ...
I have a MySQL DB with a user that has access only a few tables. This user has been granted CREATE TEMPORARY TABLES for this database and by watching the query logs, I can see them create a temporary table and then fail while trying to select from it. Doing GRANT SELECT ON TABLE 'db'.'tmp_tbl' TO 'user'@'localhost'; doesn't work as the t...
Hey all, I am looking for a way to query my database table only once in order to add an item and also to check what last item count was so that i can use the next number. strSQL = "SELECT * FROM productr" After that code above, i add a few product values to a record like so: ID | Product | Price | Description | Qty | D...
I'm using mysql-php-memcached and I want to realize something like that: http://www.facebook.com/directory/people/ to browse users by name. Suppose I have hundred of thousands username, how can I handle it? The problem is: I don't know what is the efficient way to realize it. Do I have to use Sphinx search engine? Any idea? ...
I am building a web app, and I am thinking about how I should build the database. The app will be feed by keywords, then it will retrieve info for those keywords and save it into the database with a datestamp. The info will be from different source like, num of results from yahoo, diggs from the last month that contains that keyword, et...
i get the data from DB and display it in a div... what i want to do is when i click a link it should change the content of the div one option is to pass parameter through URL to itself and reload the page... I need to do it without reloading\refreshing... <?php $id = '1'; function recp( $rId ) { $id = $rId; } ?> <a href="#"...
I want to test the load a MySQL server can handle using a couple versions of a query and for that I'm looking for something like apachebench (but for mysql). I'm hoping to run 500 or more concurrent requests every second for a couple minutes and see if MySQL is up to the challenge. ...
Hey there everyone. I was wondering for some time, and searching the nets, for an efficient way of displaying an image dynamically using PHP, depending on the result of a query. Per example, there is a field called "devicetype" in my asset table, and I would like to display a different icon depending on the type of device. Anyone could...
I have 2 tables - sentiment & comments - that I'm trying to join averages and counts from based on a set of derived time ranges in mysql. Here's what I have that works individually: SELECT ROUND(AVG(sentiment.sent_value)) AS sentiment, ROUND( FLOOR( (sentiment.sent_video_time) /5000 ) *5000 ) AS start_time, ' - ', ...
I'm developing a web application that needs to interface with a MySQL database, and I can't seem to find any really good modules out there for Python. I'm specifically looking for fast module, capable of handling hundreds of thousands of connections (and queries, all within a short period of time of each other), without an significant i...
Hi , I have customer details , have lastname column , Some of records contain white space in the name front and back , i want to do the alphabetical order , but not working properly, plz chk this screen shot , i cant able to guess wha tis the exact reason , ...
I got items rated by both ratings, and use an ORDER BY key to order them by positive, but with an example table: //(item)-(pos)-(neg): item 1 - 50 - 200 item 2 - 24 - 0 item 3 - 15 - 12 But item 1 is really less rating than the others, how would I fix this? ...
I have sphinx installed for my search engine, and it works great, but now I'm trying to add a few extra features to the search using setFilter() which should allow me to do WHERE/AND clauses, but whenever I try a search, it returns no results when there should. This is my working code: require_once ( "sphinxapi.php" ); $cl = new Sphi...
Hi, I have a MyISAM table in MySQL which consists of two fields (f1 integer unsigned, f2 integer unsigned) and contains 320 million rows. I have an index on f2. Every week I insert about 150,000 rows into this table. I would like to know what is the frequency with which I need to run "analyze" and "optimize" on this table (as it would ...
Hi every body! i want to split a product table into many smaller one, and put the table in diffrent server. but there has some problems with me: if i sharding the database with the product id. how can i get all product belong to some categorys when someone list one product category. anybody get a good ideals ? ...
As the title states, what is a fulltext index and when should I use it? ...
I have two database tables: "places" and "translations". The translations of places names are made by selecting records from "places", which don't have the translations to the specified language yet: SELECT `id`, `name` FROM `places` WHERE `id` NOT IN (SELECT `place_id` FROM `translations` WHERE `lang` = 'en') This worked fine with 7 ...
SOF Related Questions Algorithm is a very good. Can anyone tell me the algorithm like this. EX a mysql query. ...
I have this SQL query which due to my own lack of knowledge and problem with mysql handling nested queries, is really slow to process. The query is... SELECT DISTINCT PrintJobs.UserName FROM PrintJobs LEFT JOIN Printers ON PrintJobs.PrinterName = Printers.PrinterName WHERE Printers.PrinterGroup IN ( ...
Well, it can, but I can't query ;) Here's my query: SELECT code.id AS codeid, code.title AS codetitle, code.summary AS codesummary, code.author AS codeauthor, code.date, code.challengeid, ratingItems.*, FORMAT((ratingItems.totalPoints / ratingItems.totalVotes), 1) AS rating, code_tags.*, tags.*, users.firstname AS authorname, users.id ...