i need a data base built for a christian site im working on and maybe some one could help us out feel free to email or im me

Hi ppl !
I got this problem. I got x tables- that starts with clients ID- example 1_invoices- 2_invoices....till the last client on the clients table. Now- i need to make a total query to all this tables to find the quantity for each product- but grouping them . Column named "prod" in this tables where the product id comes from a query before and the date is the asked date.
This clients tables has all the same structure.
Do anyone has any idea how to join them or i dunno ? I could do only one part- i mean just getting all the products but not grouped- the same product doesnt appears 1 time but everytime it is used.
Actualy i thought the queries wont be that slow if i divide invoice tables. Can u immagine how much time it will take getting informations from a table where u put everyday thousands of rows. And clients will be quering everyday their invoices- reports or totals. I know its very simple to make an unique table but this wont resolve this problem at all. At the 11. month can u immagine what will be the weight of this table ?:P i prefer using the temp table idea. thnx for ur answear!
And this query im trying to make with this method is only for the administrator. The rest of queries- reports or statistics for each client its more but more simple. When they will log in they will have only read access in their table.
thnx for the answers ppl- i already solved my problem using a temp table i create when page opens and drope it after all results r
showed.
It was very eficent. This was the last thing i needed to finish this version.I used this method for dayli report and monthly report. This is the final query :
SELECT prod as productid- SUM(q) as quantity FROM temp_invoices GROUP by productid ORDER by quantity DESC

in my search engine script- i have the "select * from table1 where column1 like %$_POST[search]% or column2 like etc". But when i conduct the search- things appear to be case sensitive. For example- when searching for date- e.g. June- if i typed june- i couldn t find anything- only if i typed June.

i could use the "strtoupper" function like:

$_POST[search]=strtoupper($_POST[search]); before the query above- and then search all in CAPS?

any other solutions which will make things case insensitive?
or put differently: how do you make a query result case insensitive?

how to make a form in html or php to make 5 field with a certain field one field (ie- with the serial )to cheak mysql database and want to reply with a username and password to the sender please help with the code

like this http://eset.com/purchase/register.php

please

and please add also the mysqldatabase query code

please

thank you

I have a login script and it works great but- when I call to the database to check username and password- all I seem to be able to select is the username or any other prededermined values such as $tm and $ip. But I want to display information already put in the database (via signup.php). However- I only know how to display info when the fields are given- but I can t expect or even want people to signup every time they visit. So what I am saying is- I want to display info already existing in the table or an other table without the form fields haveing to be typed in. Here is what I m working with:
<?
$userid=mysql_real_escape_string($userid);
$password=mysql_real_escape_string($password);

$tm=date("Y-m-d H:i:s");

$ip=$_SERVER[ REMOTE_ADDR ];

echo $ip;
$rt=mysql_query("insert into plus_login(id-userid-ip-tm) values( $_SESSION[id] - $_SESSION[userid] - $ip - $tm )");

This all works- But need a query for table signup to display this info for the same username.

yes i need a web hosting.
no need for php mysql or cpanel.
Just a simple one like tabulas- googlepages- geocities. But i can put favicons. Upload Htm-html etc files. Thats all- simple looking and decent dashboard. Thanks
FREE ones i forgot