I am trying to store latitude 39.8162994 and longitude -98.5576019 as floats but turns out be like 0.00000000000 and -98.55760192871, accordingly. What's the problem? I am using float(15,11) as a data type. ...
Hi, How do I combine these two select statements into one query: SELECT SUM( incidents ) AS fires, neighborhoods AS fire_neighborhoods FROM ( SELECT * FROM `fires_2009_incident_location` UNION ALL SELECT * FROM `fires_2008_incident_location` UNION ALL SELECT * FROM `fires_2007_incident_location` UNION ALL SELECT * FROM `fires_20...
What would be the code for creating a table with two foreign keys? I have a USER table and a PICTURE table. Since a USER can be in many PICTURE and many PICTURE can be from a USER, I need a third table with both primary keys. Thank you SO, as usual you are invaluable for a learning novice. :) ...
Okay, so I am modeling a Datacenter with an inventory of Parts for replacement of failures inside a Server. (present models italicized). I have an InventoryEntries model because I have a swap model that a datacenter enters on a form to record that a replacement part(cpu,psu,fan,bbwc) has been taken from inventory and placed in a server b...
There's a way to get which fields were modified after a update query? I want to keep track what field XXX user modified... any ways using active records? ...
Hi, the title might be a little bit confusing, let me explain, ;) I have 3 tables: [names] n_id;name 1;Jeff 2;Adam [books] b_id;title 1;Book1 2;Book2 [read] n_id;b_id The table [read] is a table with read books. if Adam reads "Book1" the item in [read] looks like this: 2;1 so far, so good. Now, is there a way to know which books ...
I am developing a time sheets project, i am using mysql as database, i need to connect to MS access database and pull required data and sore it in mysql database. I have to do this automatically every 30 min. I was wondering if there is anyway i can do this using stored procedure or triggers. I am using java with spring,hibernate,and jsf...
I have the following code: <?php $code = $_POST['code']; // textbox $con = mysql_connect("***","****","****"); if (!$con) { die('Server overload, please try again' . mysql_error()); } mysql_select_db("example", $con); $sql = mysql_query("SELECT code FROM exampletable"); while ($version = mysql_fetch_array($sql)) { // ...
Ive been messing with jqgrids alot of the last couple days, and I have nearly everything the way I want it from the display, tabs with different grids, etc. Im wanting to make use of Modal for adding and editing elements on my grid. My problem that Im running into is this. I have my editurl:"editsu.php" set, if that file is renamed, on ...
I want to add a user score like they have on hacker news where the value of the comments on someones news submission and someones comments are added up and a score appears beside their username so i have 3 tables users/stories/comments what would be the best way to do this in php/mysql? i was thinking... 2 queries one to get all the ...
I have a table 'account' (id, email, pass) in MySQL database. I have stored procedure: DELIMITER $$ CREATE PROCEDURE `LoadAccount`(email_p VARCHAR(100)) BEGIN SELECT pass FROM account WHERE email = email_p; END$$ DELIMITER ; And here's the code: function loadAccount($email, $pass) { // connect to DB // ... $query = "CA...
Hi I want to connect to mySQL database which is located in a web-server (siteground) which is a web hosting company.. can this be achieved , is there a port to connect to the mysql database like (3306). if not , are there any servers online where this can be achieved? PS: I'm using Delphi, and I'm using mysql locally using odbc. ...
I've made a couple of scripts. One is a stock screener that can search through every stock. Another creates a heatmap that tells you what's performed well and badly over the past day. They aren't really that useful, just did them to work on my programming skills. I was able to throw some SQL in my scripts too. Would you call that in...
I am working on a personal project based in PHP and MySQL, and I am doing a bit of research and playing around with rewrites. Say I have a site... http://www.myDomain.com/ And I want to have an index.php, or bootstrap, in the root of the domain. So if you access... http://www.myDomain.com/admin/ It will still load from the index.ph...
Say, I have a whole lot of book titles in the database (more than 500000) and someday I want to add another title in the database, how would I check whether the database already contains this title or not? How would I do it in php? ...
The MySQL documentation for REPAIR TABLE states that It is best to make a backup of a table before performing a table repair operation; under some circumstances the operation might cause data loss. Possible causes include but are not limited to file system errors. I'd like to know if there are any other causes of data lo...
I am using a php/MySQL driven event feed to JSON. I am also trying to use greek html entities (i.e. &Gamma-with the semicolon) in the title for the event. Because FullCalendar will not let me see all the processies in firebug I can't see exactly what is going on but it will not render the , etc. I have tried all the combinations I can...
I'm trying to create a Database object for myself in .net. The constructor takes a connection string and opens a connection to the MySQL db using the MySQL Connector. It has functions like: function executeNonQuery(cmd as String) as Boolean function getOneResultQuery(query as String) as String function getDataReader(query as String) ...
Hi, I have a problem regarding to prevent download and saving of uploaded files. My users can upload multiple files types like doc, pdf, ppt,etc.... This all file types are easily download if any one have url. So what is the better way to prevent the download of the file. Or i convert the uploaded files to some specific format which...
Hi All, I am a beginner to Joomla, I have installed Joomla 1.5 in my server with Fantastico including sample data, also i have installed joomla in my local server. I Don't know how to upload this project from local to real server, when i completed my project , i have exported my database and import this Database in to real server after ...