Hi I'm trying to make a website in which a user inputs details on one screen, and they are posted onto the following script. This script is meant to store these details in a database along with a unique integer ID (which it does), and then generate two links containing the unique ID of the record just created. Since the database creates...
The company I work for creates applications for the Blackberry platform. We've been working on a proprietary "analytics system" that allows us to embed code within our applications and have the applications report back some stats to our central servers every time they're run. Currently, the system works ok; however it's only in beta wit...
Trying to persist Guid's in a MySQL db from C# (.NET). MySQL column is of type BINARY(16). Any sugestion on how to persist the guid and later get the guid back to from MySQL? Looking for a code answer here :-) ...
Hi, I have a view consisting of 2 natural joins over the id field which is a foreign key for the second column referencing the first and a foreign key for the third referencing the second. When I try to insert in this view there is no error but only one row is inserted in the first table. Do I have to use triggers to make it updatable? ...
create table check2(f1 varchar(20),f2 varchar(20)); creates a table with the default collation latin1_general_ci; alter table check2 collate latin1_general_cs; show full columns from check2; shows the individual collation of the columns as 'latin1_general_ci'. Then what is the effect of the alter table command? ...
I am trying to come up with a query to report revenue. It will require 2 tables: clicks and offers. Revenue is calculated by the number of conversions * commission for the offer. Conversions are stored in the clicks table in a field called "conversionDate", and the commission for each offer is stored in the offers table. There needs ...
Hi there, I need to build a reporting interface to an application I'm working on which requires administrators to visualise huge quantities of collected data over time. Think something similar to Google Analytics etc. Most of the data that needs to be visualised sits in a basic table which contains a datetime, 'action' varchar and oth...
I've got xampp installed on my laptop runing XP, and it's been running without any problems for ages. I've just tried installing cakephp, and have altered the database config and enabled mod_rewrite. But now I get the following on the welcome page: Your tmp directory is writable. The FileEngine is being used for caching. To ...
I am currently working on building a baseball website. On one side of the page I want to display information on the next upcoming game. I am using mysql ver. 5.0.45. My table is built as so: opposingTeam, date, time, score Date is in the mysql date format (yyyy-mm-dd) I have found the datediff(date1,date2) command and tried experiment...
I have a MySQL database, it is getting larger and larger and I want to move the whole database to another mount point, where I have enough storage. I want my current data to be transferred, and that new data get saved to the new position. software stack: MySQL 5 running on FreeBSD 6 ...
I was wondering how to trigger a notification if a new record is inserted into a database, using PHP and MySQL. Thanks. ...
I have two tables in MySql Company : (cname,city) works : (ename,cname,salary) I want to display number of employees working for every company, even if that number is zero. for e.g. for Company : Microsoft Bangalore IBM NY works : emp1 Microsoft 10000 emp2 Microsoft 90000 output should be : Microsoft 2 IBM 0 But the fo...
Hi, I'm trying to run a query, but I get an "unknown column 'MyField' in 'where clause'" error. This is my query: SELECT id, sum(lineValue * quantity) as TotalLine FROM myTable WHERE (TotalLine BETWEEN 10 and 500) group by id How can I perform a similar query? Thanks ...
ActiveRecord objects of the class 'Location' (representing the db-table Locations) have the attributes 'url', 'lat' (latitude) and 'lng' (longitude). Lat-lng-combinations on this model should be unique. The problem is, that there are a lot of Location-objects in the database having duplicate lat-lng-combinations. I need help in doing ...
Hello Everyone Ok here is the deal i am building a messaging system by php,ajax,jquery and mysql i add the new message and i add in 2 rows now what i want to do is to send an ajax request to server and recieve an updated version of the table but sorted So how can i do so //here i add and call the message the message function addMsg()...
Hi, I have in a MySQL table a DATE column that represents the date in this format: YYYY-MM-DD. I wanto to retrieve the date from the database using PHP but display it like this: DD Month, YYYY. From '2009-04-13' to '13 April, 2009' for example. Witch is the best way to do it?? ( I know how to get the date from the DB. I only need to k...
I want to use naive bayes to classify documents into a relatively large number of classes. I'm looking to confirm whether an mention of an entity name in an article really is that entity, on the basis of whether that article is similar to articles where that entity has been correctly verified. Say, we find the text "General Motors" in a...
So I'm setting up an installer for my web app, and have input fields for database credentials. Part of my validation process includes testing the database connection (using PHP's PDO library). If the connection fails, I want to be able to differentiate between a bad password, bad address, nonexistent database name, etc. so I can referenc...
I have a table called auctions, which has various columns such as username, auction id(the primary key), firstname, lastname, location etc, as well as a category column. The category column is blank by default, unless it is filled in for a particular record by a user. I have made a new users table, which has username and category colum...
Hypothetical example: I have Cars and Owners. Each Car belongs to one (and only one) Owner at a given time, but ownership may be transferred. Owners may, at any time, own zero or more cars. What I want is to store the historical relationships in a MySQL database such that, given an arbitrary time, I can look up the current assignment...