Tag: mysql

DB query foreach rows that are equal calculate the values from other column

I have a db table with in one column the province name of a country. And in another column of the same table the amount of people living in this province. There are many more columns in the table and also postal codes. As the postal codes are unique you can see in this table that the province column has

How to separate commas into separate row from laravel form add?

laravel mysql php

I am getting Argument 1 passed to IlluminateDatabaseGrammar::parameterize() must be of the type array, string given this error when i use explode() to add in mysql database Here is my code Answer Here issue is you are trying to insert an array as string. To save this you have too do this as given below:

How do I display values from other tables in a database in php?

html mysql php

I am displaying all the items in my database table There is a category table in my database as well that has these values Table item has attributes(ItemID, Name, Price, categoryID(FK)) Table category has attributes(categoryID(PK), Name, Description) Now when I display the items it gets displayed in this order…

Proper Laravel way to get a relation basing on both tables

eloquent laravel mysql php

I do have 2 tables linked with each other. Items that has an ID and quantity column, as well as Attendees that have id, item_id and some other data. I would like to be able to see all the items that have: a) no attendees at all. b) less attendees than the quantity. c) as many attendees as the quantity.

Table 1 record should not be present in Table 2

left-join mysql php sql subquery

I have two tables in the same database in mysql: Table 1 Table 2 I am using phpmyadmin and php. I have the column ‘teamid’ in both the tables and table 1 contains several different events columns. …

I need to list the only latest versions of the products with php – mysql

database datetime greatest-n-per-group mysql php

I’m just trying to list the only latest versions of the products. Not all versions with the same product name. So this: Instead of this: *tables are not so important I just want the code to get the data. *tables are not so important I just want the code to get the data. This is my code but lists nothing

Speed-up/Optimise MySQL statement – finding a new row that hasn’t been selected before

mysql performance php query-optimization sql

First a bit of background about the tables & DB. I have a MySQL db with a few tables in: films: Contains all film/series info with netflixid as a unique primary key. users: Contains user info “ratingid” is a unique primary key rating: Contains ALL user rating info, netflixid and a unique prima…

How can I use mysqli to SELECT and both DELETE and RETURN a single row based on WHERE condition

mysql mysqli php select sql

How can I do a mysqli php query so a SELECT request both RETURNS the row AND DELETES the same row in the MySQL DB? This php script works fine to query and return a single row based on max numerical zipcode (an example) but my modifications do not complete the delete row: I tried adding this line in various

how to make a query with database as a variable

mysql php

I have two databases – lorem and nts.lorem – and need to operate with both of them everything works fine until db is a variable in an ajax request – for example: js php any help? Answer Choose connection according to $db value: