mysql

Is there a way to LOG RC Selenium test errors/failures into a database?

Im using phpunit & phpundercontrol to run the RC Selenium on every build. ...

Mysql index configuration

Hello, I have a table with 450000 row full of news. The table schema is like this: CREATE TABLE IF NOT EXISTS `news` ( `id` int(11) NOT NULL auto_increment, `cat_id` int(11) NOT NULL, `title` tinytext NOT NULL, `content` text NOT NULL, `date` int(11) NOT NULL, `readcount` int(11) NOT NULL default '0', PRIMARY KEY (`id`), ...

Can't get unique values

I'm using my sql to get unique values from database My query looks as follows, but somehow I'm not able to get unique results SELECT DISTINCT(company_name), sp_id FROM Student_Training ORDER BY company_name sp_id is the primary key, and then company_name is the companies name that needs to be u...

How do I retrieve a random (but unique for a date) primary key value?

I have about 10,000 products in the product table. I want to retrieve one of those items and display it in a section of a web page which stays the same for that particular day. Something like "Product of the day". For example, if today I get product_id 100, then all of the visitors should be viewing this product item for today. Tomorrow...

Multistep form in PHP - MVC App

Hello, I'm about to program a mutistep form in my MVC App (Self-made MVC framework) in which no data is to be inserted until the last step is finished. I got the following issues/questions I'd really like to find a kind of pattern to solve this problem, is there any? I want it to be easy the perform a go back action, and get the data...

mysql escaped string storage

Hello! Could somebody explain me how to store a escaped string in a column limited in size of a mysql table. I mean, if I have a column to which I define a size (let's say varchar(10)), if I insert "abcdefghij" the limit is reached, but if I insert "abcde'ghij" I exceed the limit since the escaped result of this last string is "abcde\'gh...

Extra condition in ON clause is ignored

I have this query: SELECT TA.id, T.duration, DATE_FORMAT(TA.startTime,'%H:%i') AS startTime, TEI.displayname, TA.threatment_id, TE.employeeid, TTS.appointment_date FROM tblEmployee AS TE INNER Join tblEmployeeInfo AS TEI ON TEI.employeeinfoid = TE.employeeinfoid LEFT OUTER Join tblAppointment AS TA ON TE.employe...

MySQL - Not using Index

I'm trying to figure out what I might be doing wrong. This query doesn't seem to be using the index, as its taking way to long. When executing: Explain SELECT a, b, c, d FROM `table` WHERE d = 4013456 id select_type table type possible_keys key key_len ref rows Extra` 1 SIMPLE table ALL...

MYSQL: How can I store/retrieve a value based on the 3+ other values in the same table?

Let's say I'm making a program for an English class. I'd like to store data in this way: ID Object 0 Present Tense 1 1st person singular 2 To Be 3 I am How can I retrieve the value for ID 3 based on IDs 0-2? The only thing I can think of is: ID Object FromIDs 3 I am 0,1,2 The proble...

find documents having no value for sql_attr_multi attribute (Sphinx)

in my sphinx source config I have an attribute like so: sql_attr_multi = uint categories from query; SELECT entry_id, cat_id FROM categories_entries When querying the sphinx index, is it possible to get only records that do not have a category attribute? As a kludgy fix I have executed a query on the database to find all potential ca...

php and mysql selecting 5 rows from mysql

i am tryng to select 5 mysql rows from the database and display them like $row[1] ect.... in php i am not sure how to do it an someone lead me down the right way please Ok i hav looked a bit more i wanted it to come out 1 - 5 and i wanted it to display the names $result = mysql_query("SELECT * FROM table ORDER BY id DESC") or die (m...

How to create SQL query for "Likes in common"

Currently I'm building a system (php and mysql), that on the user profile allows you to add "favorite music artists" to a list. 've been trying to figure out a way to compare the user likes to other users and return a "recommended friends". For example: User A Likes - 1 - 2 - 3 - 4 User B Likes - 1 <- A likes - 5 - 6 - 7 User C Likes...

Find new rows in database

I am looking for a way to know which rows in a database (mysql) are new (or updated) in order to fetch just those from the server and store locally in an application (client). My initial thought was to add a timestamp to each row and have my application remember the time it last got an update, however I am worried of the server clock c...

Mysql auto increment primary key id's

I have some mysql tables that have auto incrementing id's that are primary keys, but I notice that I never actually use them... I used to think that every table must have a primary key so I guess that is why I created them before. Should I remove them all if I don't use them at all? ...

What database field type do you use for yes/no entries in SQL Buddy?

I am new to all this so looking for some help. Sorry if the question is really novice. I am learning all of the char, varchar, etc. ...

Reading Paradox Database files

I'm working with a client who has an existing system, built on what is apparently a Paradox database. I've got the database, in the form of a zip file containing .DB, .MB and .PX files, one for each table. I need to take (some) of this data and import it in to a Web application that's using MySQL. Does anybody have a way for me to ext...

sudden database disconnection in following code

I am recording the time at which the user downloaded a specific file using the following code. However, in this code, initially the download time is coming but later it's disconnecting the data base connection between client and server. If I remove the 'exit' (as shown), everything is coming fine but the downloaded file can be corrupted...

How to generate simple Packing List with MySQL ?

Hi, I need help on how to create a packing list of a shipment with MySQL. Let's say i have 32 boxes of keyboard ready to ship, the master carton can contain 12 boxes. I only have value 32 boxes and volume of 12. The other value in result below is generated by sql command. Not coming from record. So this easily calculate that the numb...

I want to add delete option for table

I have one table which is fetched from MySQL database. I want to add delete options for every row that has to be removed both in server and client side. Can anyone give the steps to do delete option in PHP and MySQL? ...

Mysql Distinct Query returning all records

I have a table user_quotes with the fields quotes_id, quotes_user, quotes_desc, quotes_date, quotes_status, quotes_location. In this quotes_user allows duplication entries. when i execute my query i am trying to avoid duplication entries of quotes_user. so I executed the query like this, select distinct quotes_user from user_quotes; ...