Data dodania Pytanie
2017-02-02 12:02 Anchor tags with same class not returning value on button click in jquery »
I have the following HTML: <a class="sortorder" data-order="asc" >sort ascending</a> <a class="sortorder" data-order="desc">sort d...
(3) odpowiedzi
2017-02-02 07:02 Getting an incorrect AVG() value for column in sql »
I'm writing a sql query that would groupby a column and return it's min, max and average values. Here's what I'm doing: CREATE TABLE Nums ( patient_i...
(4) odpowiedzi
2017-02-02 01:02 MAMP MySQL Server wont start »
Apologies if this is a repeat, I have had a look at the other questions and cant find a solution. I'm not really very knowledgable about this stuff so...
(1) odpowiedzi
2017-02-01 22:02 Eloquent returns POINT data as UTF8 »
I'm using Eloquent to get some data from the database. My database has a column that uses the POINT data type. The columns have values such as POINT(5...
(1) odpowiedzi
2017-02-01 22:02 Check PostgreSQL table column for value and return boolean »
I am just learning SQL and apologize if this is repetitive, but I have searched and not found an answer. Writing in python with a PostgreSQL DB. I wa...
(2) odpowiedzi
2017-02-01 18:02 Fetch returns only one item in collection »
Table info: The Image table contain a foreign key mediaid for its the parent table Media ---------- id | mediaid | url ======================== 104...
(1) odpowiedzi
2017-02-01 09:02 How can I order selected rows alternatively »
Here is my query: SELECT pr1.id AS user_id, pr1.title AS user_name, pr2.id AS liker_id, pr2.title AS liker_name, x.which AS which_table, ...
(3) odpowiedzi
2017-01-31 18:01 Storing a folder hierachy laravel »
I am currently in the process of building a application that allows users to log in and collaborate on a project. I have used laratrust so that I can ...
(1) odpowiedzi
2017-01-31 10:01 insert lots of data row by row with relationship check and possible bad data »
I have read through many articles and questions here similar to this but havnt found anything close enought. I have 40,000 rows in a 10 column excel ...
(3) odpowiedzi
2017-01-31 10:01 Connect to database without writing warning/error messages »
I am using simple method to connect to my database: $conn = mysqli_connect($servername, $username, $password, $dbname) or die("Unable to connect to M...
(2) odpowiedzi
2017-01-31 10:01 Slow query from getting the intersection of news_tags and users_tags »
I have two tables: "news_tags" and "users_tags". Now I want to get the appropriate users for a particular news. I get the right results with my query,...
(1) odpowiedzi
2017-01-31 08:01 How to Fetch Data using Date Condition in php »
Hello I am working with Word Press and I want to fetch records according to the the date.MySQL database has a table wp_evr_event with end_date colu...
(2) odpowiedzi
2017-01-30 20:01 Laravel 5.4 sometimes uses different database credentials »
Laravel 5.4 randomly (sometimes not always, or even frequently) tries to connect to a database using the default forge credentials... I've changed th...
(1) odpowiedzi
2017-01-30 16:01 MySQL Query to get individual item from another table »
I have two tables- 1. Feed 2. Seller Feed table is like this seller_id item_id end_date ========= ======= ========= 1 ...
(3) odpowiedzi
2017-01-30 08:01 Does Django (w/ MySQL) do only 1 table lookup or multiple when counting with CASE »
Lets say we have a model of the form class Person(models.Model): is_gay = models.BooleanField() is_tall = models.BooleanField() is_nice ...
(1) odpowiedzi
2017-01-30 05:01 NodeJS much slower than PHP? »
I run a tiny scale web server under Apache + PHP + MySQL at the moment and would like to explore the option of using NodeJS instead. The server litera...
(1) odpowiedzi
2017-01-29 20:01 Variables in stored procedure MySQL »
I got a problem with this SIMPLE stored procedure. I want to save LAST_INSERT_ID in a variable and then assign it for next insert. DELIMITER // ...
(2) odpowiedzi
2017-01-29 18:01 problems with validating input and query optimization »
im creating a management system where teachers can manage students final projects and the formers can see what other students created im a laravel ne...
(1) odpowiedzi
2017-01-29 15:01 How Can I Associate Records From A Connected Tables? - Ruby on Rails »
So Basically I Have 3 Tables that are associated together and one extra table for the table with each other: Students, Teachers, Subjects and Enrolled...
(2) odpowiedzi
2017-01-29 06:01 Parse PHP into HTML style parameter »
I want to make the style parse from the information given in the query. I have the bgcolor & text color that I want displayed listed in my table,...
(0) odpowiedzi
2017-01-29 01:01 Undefined property: Illuminate\Support\Collection::$id in Laravel 5.2 »
I have a confusion and I need a help to solve. I am trying to add a record to a table that depends on the initial record, it is an event log table re...
(2) odpowiedzi
2017-01-29 00:01 Storing a Node.js Date in a Knex dateTime()/MySQL DATETIME field »
I'm having some trouble finding a date format that is common to Node.js, knex, and MySQL (via Bookshelf). I set up a table with the Knex schema build...
(1) odpowiedzi
2017-01-29 00:01 get column data and insert into a row with id given in another column - sql nodejs »
I have made a certain form with a table layout the table is kind of like this below: UAN NAME DESIGNATION No. of Days Present 87982 JOHN...
(1) odpowiedzi
2017-01-28 10:01 Getting a specific column value from a pivot table »
The problem I've got three tables, shops, products, and product_shopas the pivot table. The Shop and Product are related using a belongsToMany (Many ...
(4) odpowiedzi
2017-01-28 09:01 Why do I have to use BACKTICKS when identifier is not a reserved word or with spaces? »
No ERROR on backticks. DB [XXX]> create temporary table `123456e6` (`id` char (8)); Query OK, 0 rows affected (0.03 sec) ERROR when not using ba...
(2) odpowiedzi
2017-01-28 02:01 Optimize MySQL self-join query »
I have c_regs table that contains duplicate rows. I've created index on form_number and property_name columns. Unfortunately this query still taking t...
(4) odpowiedzi
2017-01-27 17:01 MySQL bitwise NOT operation isn't returning desired value »
I'm trying to convert some PHP code into MySQL code. Here's what happens: In PHP: I'm trying to use bitwise not on a number and this is the result I...
(1) odpowiedzi
2017-01-27 16:01 Sql find only one hashtag not two »
How to find in a MySQL database?: # Some title (In a text field most of the titles are: ## Some title. But there are some mistakes with only one #...
(2) odpowiedzi
2017-01-27 15:01 Active Record DB Modeling - Ruby on Rails »
Ok guys, this might be a little bit confusing so stick with me. Let me start by introducing my tables. Basically I created four tables upon migration....
(1) odpowiedzi
2017-01-27 11:01 mysql muliple joins from same colums with different keys »
I need some help making the second join with the tables below. I got some help from here previously where it was suggested I need to add a second JOIN...
(3) odpowiedzi
2017-01-27 09:01 Select yesterday date in MySQL »
I have one table with three columns, ID, SETTLE_DATE_TIME, STATUS . I trying to select the data which the SETTLE_DATE_TIME is yesterday and the STATUS...
(4) odpowiedzi
2017-01-26 17:01 SQL - How to use wildcard in LIKE as a normal character »
if I have a column with some values that starts with "%" like this: [ID]-----[VALUES] 1--------Amount 2--------Percentage 3--------%Amount 4--------%...
(4) odpowiedzi
2017-01-26 14:01 Show lowest value in a select »
I am trying to get 1 result of the lowest value from a set. So I have a set of number (averages) i just need to show the lowest one of the set: ...
(2) odpowiedzi
2017-01-26 05:01 Assistance with VB.net query »
Here is my current query: select No, (select count(no) from textvote group by no) / (select count(no) from textvote where no like '%Gin...
(1) odpowiedzi
2017-01-25 19:01 Display Results on page, then Insert Multiple Records into MySQL table using ColdFusion »
I created the following page that displays which managers have accrued time for the current month. - First, I need to display the records to "Insert" ...
(0) odpowiedzi