i count to some row form my database in five condition use the sql query it’s work with 0 if i put the number more than 0 then it not show any result. please help . it’s work with script $query33=…
Tag: php
How can I get the information from one field in a query to use in another query?
I am still trying to finish fixing my details page and I need one more piece to fix it. I start with this query. NOTE:recordID actually comes in from the previous page by clicking an item. Also, name, img, item_code, and type_id are fields in my table not outside sources. Now, I have created this to determine…
Merge Multiple Queries Into 1 Query – On the same Row
I have 1 table called itemmovement : It has Item Id , Quantity In , Quantity Out , Invoice Id, Date. I need to make in one query to show how many pieces are sold and beside the sold column there will …
How to convert PostGIS polygon coords into lat and lng?
From a json API, I am fetching data of an area displayed as a polygon. An endpoint example can be found here: https://admin.udinaturen.dk/api/v1/facilityread/?format=json&subcategory=40&limit=1 Here is a preview of the polygon displayed on the platform I am fetching the data from: http://udinaturen.dk…
Why is this not saving to the database?
I’m trying to save a new product into the database, this product has exportation factors which i’m also trying to save, why is this not working? if ($request->has(‘export_factors’)) { $…
PDO changes query
I want to have result of my query as it was before I replaced db connection using PDO. How can I get the query as i t was before I implemented PDO? This is my query: $query = “SELECT `…
Pulling Queries from Database Clears Results on Error vs. Stopping
We have a script that pulls queries from a database every couple of minutes. Those results are then shown in a table on a webpage. It works great, until that database responds with an error code (for …
Laravel save a input with extra value data
i am trying to save a input value from a time data: On mi example i am saving the data 3:30 for a calendar form, but to use on the calendar i need save …
Trying to connect two tables together by using id value from one table on the other
So i’m pretty new to sql and i’m trying to figure out how to connect two tables together. I have a table named customers and a table named pets and i want to assign the pets to specific customers. I am able to assign them a customer value but only as the id, i can’t figure out how to take
Referencing the count in object PHP
I’m trying to reference COUNT(*) from the object below. I grab the date using $the_date = $obj2->the_date as per the below example, but how do I reference count? Of course using COUNT(*) will throw …