I have an issue getting data from three tables, which I want to return using one query. I've done this before using a query something like this one: $query = mysql_query("SELECT maintable.`id`, maintable.`somedata`, maintable.`subtable1_id`, subtable1.`somedata`, subtable1.`subtable2_id`, subtable2.`somedata` FR...
My iphone app connects to my php web service to retrieve data from MySql database? a request can return 500 results; So what is the best way to implement paging and retrieve data 20 items at a time? Let's say i receive the first 20 ads from my database. Now how can i request for the next 20 ads in my database? ...
Hello, This is MySQL Query: SELECT `TABLE_SCHEMA` , `TABLE_NAME` , `COLUMN_NAME` FROM `COLUMNS` WHERE `TABLE_SCHEMA` = 'zfk' How can I make multi dimensional arrays: Level 1 TABLE_SCHEMA (The above query is just a demo, else real query has no where clause). Level 2 TABLE_NAME Level 3 COLUMN_NAME MySQL Output: ...
I'm trying to work my way through a Java Tutorial. The author wrote the tutorial to work with MS SQL. I'd like to follow the tutorial using MySQL. I'm not completely sure how to translate the MS SQL script which uses "IDENTITY", "CONSTRAINT", and "CLUSTERED" as you'll see below: CREATE TABLE [event_person] ( [event_id] [int] NOT NU...
ok.. Im a complete noob at SQL and having trouble... Im trying to convert a table from varchar to int.. The reason for this is because Im trying to order the numbers on my website by the highest first.. Thats not the problem but because its a varible its odering them wrong. When I try changing the table in PhpMyAdmin to an INT I get thi...
What is the easiest way to retrieve data from the database, and convert the data to a JSON String? Is there any kind of helper class? or am I supposed to loop through the columns in my dataset to create the JSON string? sample code would be great ...
Hi All, I've got a database (all MyISAM tables) and the machine where MySQL was running is no longer bootable. However, we have all the MySQL data files from the data directory. How can I restore the data from the MYD and FRM files, or whatever other files I should be looking at in the data directory? I've been doing some searching o...
I'm using the following query to extract a random row from the ones with the minimum date difference within a subgroup (as defined by an ID1,ID2 pair). It is not working, as the steps that ranks the rows by date difference assigns rank=1 only to the first observation (i.e. even if the second has the same date difference and should recei...
Hi. I'm trying to figure out how to write a statement in my first CI app (and only second PHP app ever) and I'm stuck. I have a junction table that holds book_id and user_id from their respective tables. I want to find out who has read a book and echo that back out, but I need the formatting to make sense. Here is the query: $readQuer...
I have something like SELECT * FROM table WHERE id IN (118,17,113,23,72); If I just do this it returns the rows in ID ascending order. Is there a way to get back the rows in the order given in the IN statement? ...
I am not totally sure I am naming this right, but please bear with me. I am wondering if is possible to do something like this in SQL(MySQL specifically): Let's say we have tree-like data that is persisted in the database in the following table: mysql> desc data_table; +------------------------+---------------------+------+-----+--...
I am building a website using php+mysql. I have a registration page and its already implemented in php. Now i would like to make the page more dynamic and interactive using ajax.That is i would like to have a feature in which when user moves to next tab it should display message in previous field saying right/wrong depending on user ente...
I have a table setup like this (simplified for example): user_id item_id click_dt Each item_id has many user_id's. Basically it's storing the clicks on items, associated to a user_id. I want to query through this and list only the latest user_id for each item_id, based on click_dt. So if there are 5 clicks for item_id 55, the last ...
I don't have shell access. Database of 8,000 database entries with images and max I can get at a time with the max_allowed_packets parameter is about 30-35. Tried bigdump to no avail. Also downloaded numerous other items. Shell access is not working on the server. Tried to change the max_allowed_packet param in php.ini, my.ini, ...
Hi all, I have a specific question on mysql sub-partitioning using hash on a date/datetime column. I have partitioned by site_id, and I want now to subpartitioned by month (1 to 12), so the partitions number is fixed in time (sp_dec, sp_jan, ...) Current cut (columns and other partitions) table structure : CREATE TABLE IF NOT EXISTS `...
Hi i using this mysql code to generate this data below: code: SELECT L.LEAVETYPE, LA.IDLEAVETYPE, LA.IDLEAVETABLE, SUM( LA.NOOFDAYS ) FROM LEAVETYPE AS L LEFT JOIN LEAVEAPPLICATION AS LA ON LA.IDLEAVETYPE = L.IDLEAVETYPETABLE GROUP BY L.LEAVETYPE When i add the Where condition it will only show the LeaveType with value. How can i ...
I need to select all data in table created not less than 24 hours ago. Anyone know how to do this? ...
How to use grouping correctly in this query: $sQuery = "SELECT id,DATE(A.Inspection_datetime) AS Date, A.Model, COUNT(A.Serial_number) AS Qty, B.name FROM inspection_report AS A LEFT JOIN Employee AS B ON A.NIK=B...
I have the following situation. I have a database of transactions about multiple contracts. I am looking for the first transaction where alpha < alphaBound and the contract has a future, meaning there are records after the date for the same contract ID. To do this, I have been doing: select transactionID, date, alpha, ...
Hi, I have a bunch of data from a scientific experiment stored in a MySQL database, but I want to use MongoDB to take advantage of its map/reduce functionality to power some web charts. What is the best way to have new writes to MySQL replicate into Mongo? Some solution where I inspect the binary MySQL log and update accordingly, just...