I am practicing writing an app which use MySQL to manipulating data. My concern is if my client machine doesn't have have MySQL pre-installed, it's not be able to run my app, is it?. So is there anyway to embed the database server right into the app, or to run the app without the data server. I wonder how all the softwares out there man...
This is my table: id id_1 camp 1 0 x1 2 0 x2 3 0 x3 4 1 x4 5 1 x5 6 1 x6 7 3 x7 8 3 x8 9 3 x9 I am in need of a SQL that, if there are no rows with id_1 of "x", it should retur...
Web application PHP,Mysql. Users can write articles. How to build algorithm that allows users to subscribe (follow) to other users articles and then see list of last articles added by subscribed users? Algorithm must scale, so that one user can subscribe to 10 000 users and 10 000 users can subscribe to one user and all parts works quick...
Could SQLite be an alternative for mysql in high traffic web sites? Thanks ...
I'm adding SQLite support to a Rails 2.3 codebase designed for MySQL. Most of the changes so far have been fairly straightforward, but I've now found some examples like the following code: SomeModel.find(:first, :conditions => ["? LIKE CONCAT(some_attribute, '%')", a_variable] ) I can't just use the ANSI concatenation operator beca...
I wish to save some semantic information about data in a table. How can I save this information in MySQL, such that I can access data and also search for the articles using the semantic data. For example, I have a article about Apple and Microsoft. The semantic data will be like Person : Steve Jobs Person : Steve Ballmer Company : Apple...
Hello, I'm doing a small DataBase with MySQL Workbench. I have a main table, called "Immobili", which has a Primary Key composed by four columns: (Comune, Via, Civico, Immobile). Now, I also have three other tables, wich have the same primary key (Comune, Via, Civico, Immobile), but these fields are also referenced to the table Immobili....
I'm thinking of starting a facebook style website with bio pages, friend requests etc, roughly what sort of database tables would be advisable? Ie. Users, status? A rough list would help? Thanks ...
i have written a daemon to fetch some stuff from mysql and make some curl requests based on the info from mysql. since i'm fluent in php i've written this daemon in php using System_Daemon from pear. this works fine but i'm curious about the best approach for connecting to mysql. feels weird to create a new mysql connection every coupl...
Hi, What is wrong with this query? SELECT *, (SELECT COUNT(*) FROM ( SELECT NULL FROM words WHERE project=projects.id GROUP BY word HAVING COUNT(*) > 1 ) T1) FROM projects MySQL returns 1054 Unknown column 'projects.id' in 'where clause' Thanks ...
Hello, I'd like to combine these four queries to get this result: Vendors ----------- select i_vendor, name as Vendor from Vendors Customers ----------- select i_customer, name as Customer from Customers Calls ----------- select i_vendor,i_customer, id as Call, date_format(connect_time,"%Y-%m-%d %H") as Date, duration from CDR_Vendors...
Hi, I need help with an algorithm to allocate rooms to people. I need to shuffle through a list of rooms to assign a room to a person and after the fourth person is assigned to the room, it should be out of the list(should be unavailable). I have not had any luck with PHP shuffling and sorting functions yet. Any help (pointers, referenc...
Hi.. My purpose is to setup a forum in php just locally on my Windows 7 machine to test how it works. I have installed Apache HTTP Server and PHP v5 successfully. Then I downloaded and extracted the phpbb-forum software and put it in my root folder. Then I realized that I needed some kind of database so I downloaded and installed MySQ...
I have two mysql database tables: 1) CARS TABLE: with following columns i)car's name and ii)manufacturer's name. 2) RECORDS TABLE: with the following columns i)name of the user ii)rating given iii)car's name. Now i want the each user to give rating( rating will be a text input box) to each and every car in two ways. 1) ONE BY ONE: ...
the below code shows a table with users to be accepted or declined. the code as it is has a dropdown on the end allowing to either accept it, deny it or leave as is. there is a button on the bottom to submit the form and after that there should be a php script that decides which user is accepted, denied or still pending. what would be ...
When a user registers I am wondering how to create them a dynamic directory (which will show they're profile), such as Facebook / MySpace. I want the directory to be that of their username. The username is stored on the database. Technologies being used Database: MySQL Front End: PHP I've looked at using the PHP MKDIR command to cre...
I have some entries in my database, in my case Videos with a rating and popularity and other factors. Of all these factors I calculate a likelihood factor or more to say a boost factor. So I essentially have the fields ID and BOOST.The boost is calculated in a way that it turns out as an integer that represents the percentage of how oft...
Hello, I facing a problem regarding the import of an excel file into mysql through php. i have used phptriad as a local server to test my web application(site). The application imports the excel file present on the client side computer. the code works fine when accessed through local server. recently i have registered a subdomain at or...
i need to check login credentials against a mysql database and my coding seems to be off ... any suggested coding would be greatful ...
Need a field with a 10 character alpha-numberic field for use as a customer ID. I'm going to try and be as specific as possible here, so I have broken it down into a list of questions. How do you create such a field in MySQL? -Needs to be both numbers and letters -Needs to be able to not duplicate -Needs to be auto generated -Needs to ...