₦airaland Forum

Please i need a help to create an sql queries for the following question.

1. A query that will demand for a particular date range, a list of all dairy tittles,creation date and thier creators email addresses. the user should be prompted for the start and end date of the required period, produce the sql code only.

Are you sure you know what you are saying? SQL query and you talking about prompting? please check your question,

cryingbaby

1. i am interested. but, i need your question in English?. 2. i need the list of Fields to report after your query filter have being commanded to?.

if query on date range? what are the values you are expecting and the date range for prompt solution?. i am waiting for your responses?


ok.

OP, code something out first, show us then people can work on it!

cryingbaby,

We are still waiting for the question?. if it is difficult to explain. just post a scanned copy for solution.

best queries ebooks plz

Na wa o, see as they guys them wan chop am. Post codes keh? If na me, i go just jar commoth for hia quick quick.

@op, you need to write some php codes and then some sql queries to run inside your php codes.
MySQL is (as them programmers will say) - a middleware application. . .

A lot of these question who come on here to ask questions do not bother spending time doing their homework first, to at least understand what it is they really need to ask. How can SQL Prompt user for input?

That is possible, for example in oracle,


select * from account where id = &id;

I think they are called bind variables or something

SQL can prompt for input. Just as wassolidas stated, these prompts can be in the forms of literals, substitution and bind variables. What the OP needs is a substitution variable, i.e precede the input prompt variable with an ampersand. (select * from departments where dept_id = &deptID)

Bind variables are explicitly predefined variables for repeated use in the current session (declaration: var par_name, Usage: select name into :par_name from users)

@cryingbaby

Sounds like you're trying to get an assignment done for you. Best learning practice would be you pasting excerpts of your independent attempt(s) and get guide from peeps here.

sql prompt? as in gui prompt?

Am beginning to wonder to