I CANNOT use port 3306 to access MySQL db we need
to do it using port 80.... You have any ideas or suggestions??

Thanks!

I have a Xampp for Linux installed on a Debian 4 Linux box.

I have to login as root and issue the following to start.

/opt/lampp/lampp start
... starting apache
....starting mysql
...starting ....

However when I reboot- I would like this to be automated.

I can t remember if it has to do with the "inet" or do I have to write a separate script with "sh" or something?

any help would be great.

So I have a query pulling subcategories from a table of museum exhibits. It looks something like:

SELECT subcategory FROM exhibits;

and returns the subcategory for all 200+ entries. The problem is that I need to generate a list of the different subcategories- and I d rather not have a separate table of subcategories. That is- I need something like this:

SELECT subcategory FROM exhibits {BUT ONLY SHOW EACH SUBCATEGORY ONCE};

PHP string functions are a totally valid option... My first thought was to use strcompare()- but I can t quite reason out how to do it.

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?