I know how to print data from database on html table but i have one task that i can not understand, and i can not do it. I have a table in database and when i select those data i want them to display on html table but something like this: ...
I don't know if I've chosen the appropriate title for this question (if not, please change it accordingly) but consider the following simplified table structure I'm working with: ---------------------------------------------- | date | i | j | k | x | y | z | ---------------------------------------------- | 100209 | 1 | ...
on my website a user can post comments and group these into categories. eg. category: good quotes links: "some quote 1", "some quote 2", and so on. so the nr of categories and comments are determined by the users. im thinking how i should organize this in the mysql database. i cant have one table for each category because there wo...
I have a column which is a Timestamp. It records something like: 2010-02-08 12:10:22 Then I use this in php: $postdate = date( "j F", strtotime( $row['modify_date'] ) ); And it can output something like: 8 February My Q is, how can I change the date-text so it outputs the month name in another language (swedish specifically)? Ex:...
Hi, we're writing a scientific tool with MySQL support. The problem is, we need microsecond precision for our datetime fields, which MySQL doesn't currently support. I see at least two workarounds here: Using a decimal() column type, with integer part corresponding to seconds since some point in time (I doubt that UNIX epoch will do, ...
I have this to select a date from a mysql db, and compare it to an array of month-names in swedish language. $monthnames = array("","Januari","Februari","Mars","April","Maj","Juni","Juli","Augusti","September","Oktober","November","December"); $postdate = $monthnames[date("n", strtotime( $row['modify_date'] ))]; //Outputs something lik...
I have a problem with the following MySQL query: SELECT * FROM TPDSessions WHERE TPDS_Morning = 0 AND TPDD_Id = 1 AND TPDS_Chair1_idPerson = 16785 OR TPDS_Chair2_idPerson = 16785 The row returned has TPDS_Morning with a value of 1 in it, and I don't get why. This is the table structure: CREATE TABLE `TPDSessions` ( `TPDS_Id` int(...
These are the ones I've come across: Inability to change the body of a stored procedure with ALTER PROCEDURE One should use DROP PROCEDURE and CREATE PROCEDURE. PREPARE doesn't accept local variables. This won't work: DECLARE sql VARCHAR(32) DEFAULT 'SELECT 1'; PREPARE stmt FROM sql; FETCH [cursor_name] INTO .. doesn't accept global va...
I have a "games" table which contains player_id and player_action. player_id | player_action 1 | move 1 | move 1 | attack 2 | attack 2 | attack 3 | move 3 | move And I have to get all player with "move" action but only one row per player, result should looks like ...
In a table I've got 3 columns: id tag1 tag2 id is a primary key. And i only want one unique tag1-tag2-combination in that table. eg if one entry looks like: id: 1 tag1: cat tag2: dog I dont want a second entry like this one beneath to get inserted: id: 2 tag1: cat tag2: dog So i made all 3 columns primary keys but the problem...
I'm trying to find a way to do a conditional DELETE on an InnoDB table which contains millions of records, without locking it (thus not bringing the website down). I've tried to find information on mysql.com, but to no avail. Any tips on how to proceed? ...
I'm building a spreadsheet app using MySQL as storage, I need to identify records that are being updated client-side in order to save the changes. Is there a way, such as some kind of "internal record identifier" (internal as in used by the database engine itself), to uniquely identify records, so that I'll be able to update the correct...
I have this table (simplified): CREATE TABLE `my_table` ( `id` INT NOT NULL AUTO_INCREMENT , `item_name` VARCHAR(45) NULL , `price` DECIMAL(10,0) NULL , PRIMARY KEY (`id`) ) I need to select all items from the table, ordered this way: 1. items with price > 0.00 first, ordered by price ASC 2. items with price = 0.00 last, orde...
Right, so I have a set of dropdowns on my page. Depending on whether a value is selected, I want to add it to an SQL query string in PHP. Example: select1: options("*" "op1", "op2) select2: options("*" "op1", "op2) select3: options("*" "op1", "op2) '*' refers to anything. i.e the data should not be filtered by that query option. Now, ...
If I run this code: http://www.danny92.pastebin.com/m1f84b972 You will see that my Database connection connects then disconnects after actionPerformed.... why? :( ...
SELECT Concat(mp.cHospital ,',',mp.cHospital1,',',mp.cHospital2) as Hospital FROM TBL I dont want to return null value, how to check not null or how to make isset cond in query ...
I have a bunch of date data in a mysql table like this: 2010-02-13 1:00:00, "soma data" 2010-02-13 1:25:00, "soma data" 2010-02-13 1:37:00, "soma data" 2010-02-13 2:12:00, "soma data" I want to select a report which shows the data grouped by hour, for example: On Feb 13, during the hour from 1:00 pm to 1:59 pm, there were 3 data poin...
Hello, I am new to php syntax and am looking for advice on creating the most acceptable or correct code. I focus on front end design, but I like to make sure my code is proper. I am in a digital media program, my instructor has given us this code for connecting to our MYSQL databases. <?php mysql_connect("localhost", "root", "root")or d...
Hi, I want to create my very first web app using HTML, MySQL, PHP and the Model View Controller. It will be very simple for starters: a couple of pages that allows users to input/delete data to/from the database and display the contents of the database. However I am new to MVC, and I really wish I could have found MVC tutorials approp...
Hello. I have made this code for giving out +1 point, but it doesn't work properly. mysql_query("UPDATE member_profile SET points= ' ".$points." ' + 1 WHERE user_id = '".$userid."'"); the $points variable is the user´s points right now.. I want it to plus one to it.. so example if he had like 5 points, it should be 5+1 = 6.. but it do...