Introduction
Solved make a query, get results make query again is a process that allows users to quickly and easily obtain the information they need from a database. This process involves making a query, getting the results, and then making another query based on the results. This process can be used to quickly and efficiently find the information that is needed, without having to manually search through the entire database. This process can be used to quickly and easily find the information that is needed, without having to manually search through the entire database.
Solution
SELECT *
FROM table
WHERE condition;
// Get results
// Make query again
SELECT *
FROM table
WHERE condition
ORDER BY column;
Use instead ‘where’, ‘where in’ – where in allows You to serach in array.
for example :
Select id from member where parent_id IN (here array ($y) )
0
solved make a query, get results make query again
Making a query and getting results is a common task for many people. Whether you are a student, a business professional, or a researcher, you may need to make a query and get results from a database. Fortunately, there are a few simple steps you can take to make a query and get results.
Step 1: Identify the Data You Need
The first step in making a query and getting results is to identify the data you need. Think about what information you need to answer your question or solve your problem. Make sure you have a clear understanding of the data you need before you start making a query.
Step 2: Choose the Appropriate Database
Once you know what data you need, you can choose the appropriate database. Different databases have different capabilities, so make sure you select the one that best meets your needs. Consider the size of the database, the type of data it contains, and the features it offers.
Step 3: Construct the Query
Once you have chosen the appropriate database, you can construct the query. This involves writing a statement that specifies the data you want to retrieve. Make sure you use the correct syntax for the database you are using. If you are unsure, consult the database’s documentation.
Step 4: Execute the Query
Once you have constructed the query, you can execute it. This will send the query to the database and retrieve the results. Depending on the size of the database and the complexity of the query, this process may take a few seconds or a few minutes.
Step 5: Analyze the Results
Once you have retrieved the results, you can analyze them. Look for patterns and trends in the data that can help you answer your question or solve your problem. Make sure you understand the meaning of the data before you draw any conclusions.
Step 6: Make a Query Again
Once you have analyzed the results, you may need to make a query again. This could involve changing the parameters of the query or adding additional conditions. Make sure you understand the implications of any changes you make before executing the query.