Jump to content

684425

Members
  • Content Count

    63
  • Joined

  • Last visited

Community Reputation

0 Neutral

About 684425

  • Rank
    Regular Member
  1. Is there any function in php lib that does the following $a = 1238; $n = 48; // 1*2*3*8 or I will have to create one for my script? (I want to do it for both client and server sides based on request sent by user. I actually want it in php that is why i asked it here, but if the solution (as function) is available in javascript (not jQuery) please share or guide me.)
  2. I was trying it with a subquery and got confused. Thank you 🙂
  3. I have a column (unix_values) in table where multiple values are stored in unix timestamp which i want to convert into date yyyy-mm-dd and copy to another column (date_values) using single query Any help please?
  4. Agree with you sir but the problem here is that DB is already created and filled with data. I tried to move data to a new DB and i was discussing the matter here. In the middle i was stopped from doing this, so i have to continue with the old one. Here in my first post i pasted a sample of only those fields on which i wanted to run queries like as query total amounts paid by each customer, find number of customers whose total payments are (1. less than given input, 2. equal to given input, 3. greater than given input) What i am facing here is, old DB is not normalized, also (dynamic?
  5. 1. You are right sir. this column should be named as customerid but it is named as invoice and i am not allowed to change it. 2. There is only one duplicate in history data but that account is closed. After that every customer is assigned a unique invoice.
  6. Sir, i have reached at this SELECT customers.invoice, customers.downpay, SUM(installments.payments) AS paid FROM customers LEFT JOIN installments ON customers.id = installments.invoices GROUP BY customers.id Please guide me if i am wrong
  7. Sorry sir, it is... TableA is customers (id, invoice, downpay) TableB is installments (id, invoices, payments) TableC is the result of query that i want to run on both customers and installments Sir i am not allowed to modify DB structure and i do not want to do that because it already is filled with lots of records. I can run only queries on data.
  8. In another query i will need to repeat the same and then also i will have to count records from result where BBB + CCC = 10000. Please guide me🙂
  9. I have two tables as shown in image, I want to join sum of records from table B based on keys in both tables to get the desired result as mentioned in third table. Please guide🙂
  10. I have added an image, User requirements are: Vendors, items by vendors and payments to vendors How many vendors are there? Which vendor has sold him what on which date (and what is the status of registration, file, copy and plates)? How much amount (each transaction by date) has been paid to a specific vendor and what is the current balance? Clients, items by invoice number and payments collection from clients Which client has bought of which vendor's item on which date? Who handled the client, filled the form and received advance from client? (There ar
  11. No sir, A are the companies (always sellers), C are individuals (always buyers) Agree sir, I am confused in both database structure and frontend, so i added this. But it is not added now. Currently i am working on Excel, i will post screenshots tonight in next reply IA.
  12. Sir, this is only for bikes. I am sorry i forgot to mention it in my post.
  13. Sir, I think it is... 1. Vendors table (vendor ID, name, contact) 2. Items table: (Item ID, invoice number 'varchar', Here every item is a bike 'varchar', different brands but duplicates 'varchar', different models but duplicates 'year', only two colors mostly red so duplicates 'varchar', engine number unique 'int', chasis number unique 'int', registration number unique 'varchar', statuses of registration, file, copy and plates are as 1 of 3 or 1 of 4 choices (radio buttons will be used on frontend), deal date 'date', delivery date 'date' 3. purchase table: (vendor ID, it
  14. I am working on a database (filled with history data) for the following, Person A is running a business as a third party between multiple sellers B and multiple buyers C 1) A purchases bikes from B and maintains the following data: "Invoice ID of C (or blank), Name of B" , "Bike brand, model(year), color(red or black), engine number, chasis number, registration number, registration status (1 of 3 posibilities), file status (1 of 4 posibilities), copy status (1 of 4 posibilities), number plates status (1 of 4 posibilities), price, deal date, delivery date" 2) A sells bikes to C
  15. i forgot to answer this. Most of the queries in the project execute at the time of page load and these pages display expected data accurately that comes from the database. The session variable error that i am getting is coming from one page only but that page too is displaying exactly the same data which is stored in database. PS: Right after my previous reply, I did wrap my code in a condition to confirm that the session variable is set or not and used a redirect if it is not set. Php redirected me to the other page and told that the variable is not set. The other mistake that i hav
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.