[Hoe powerfull is mysql]

This depends on TONS of different things, but here are a few to watch our for :

 

1) Your server - Is it shared amongst other users? How fast is the CPU/Disk/Memory?

2) How well optimized are your queries, table structures, indexes etc..

3) Are you using persistent connections?

4) Do you have other applications running on the server?

[Newbie : Array Field]

You should probably create another table that just keeps track of which suppliers stock which products. Since you have a \"many-to-many\" relationship it should not be stored with your products.

[mysql nested query]

I don\'t believe this is possible in one query. I scoured the mySQL page and couldn\'t find anything about this. I know it is definately possible using oracle, but not currently in mySQL. You could easily parse this recordset into PHP and get what you need.

[Checking IP address and reporting]

What operating system are you running?

[Mergeing/Overwriteing/Archiving Tables.]

I\'m not following what you mean? If the user visits then their record would not get archived. Basically the live table would have all of your \"fresh\" records and the archive would have everything else. If you needed to do some sort of reporting on all of the customers you could just UNION the two tables.

[How to keep session data in multiple Apache servers?]

The easiest way to make this work is just to use a common database between the two servers. Have all of your user session data stored here. Then either server can access the data at any time.

[Couple Questions, query related.]

You can order by any formula you wish

 

Either of these will work :

 

select col1, col2/col3

from table

order by col1/col2

or

 

select col1, col2/col3

from table

order by col2/col3

[Mergeing/Overwriteing/Archiving Tables.]

Referrers ------

This is the easy one. I would archive everything from this table into another on a daily baisis. Make sure that you are running all of your stats out of the archive table so you don\'t degrade the \"production\" performance.

 

Customers --------

I would pick a field like last_visit and prune everyone that hasn\'t visited in XX days. Move each of these records into an archive table. If you use this method you should just to a delete from the archive table for each record that exists (and is moving) from the live table. This will keep you from getting duplicate records in the archive.

[How do i duplicate a mysql data base?]

There is a hot backup plugin available for mySQL

 

http://www.mysql.com/press/partners/release_343.html

 

Since the mySQL databases are stored as files on the server you could also setup something yourself to archive the files somewhere else every so often.

 

http://www.mysql.com/doc/en/Backup.html

[mySQL and PHP syntax error]

You can also specify the Column names in a list first and use the values statement ie :

insert into table (id,name) values (1,\'Me\');

[php doubts]

The way they are doing that is by creating a folder and putting an index.php in it.

 

Example :

www.webglimmer.com/community

 

would be showing www.webglimmer.com/community/index.php

[Seeking help with getting resultset from multiple tables]

I would recommend storing some sort of access level in your tables and letting mySQL filter the results based on that.

 

 

select t1.*,t2.*, t3.*

from table1 t1,

inner join table2 t2 on t1.id=t2.id

inner join table3 t3 on t2.id=t3.id

where t1.user_level<=$user_level

and t2.user_level<=$user_level

and t2.user_level<=$user_level

order by t1.date_published

[SQL query help]

You need to use an outer join : Here is an example

 

SELECT e.id, e.posterid, e.titletext, m.username

FROM phpnews_news e

LEFT JOIN phpnews_posters m ON e.posterid = m.id

ORDER BY e.id DESC

 

This will pull all of the data from phpnews_news and only the records in phpnews_posters that match. If you wanted to reverse this (pull all from posters and only those in news that match) you could change it to a RIGHT JOIN

 

http://www.mysql.com/doc/en/JOIN.html

[ASP on Unix?]

There are a few addons that you can purchase that support ASP on unix. The one that I thought looked best was Chilisoft!ASP (I think SUN now owns this.

[MySQL relational tables]

MySQL does support referential integrity and cascading deletes/updates etc as you asked. It only supports it for certain table types, so be careful of that. If you would like to read more about it visit http://www.mysql.com/doc/en/ANSI_diff_Fore...reign_Keys.html

[Beginner Needs Help!]

I know that the new Dreamweaver MX 2004 will allow you to connect to a mySQL database via your forms without much of a problem.

 

http://www.macromedia.com/support/dreamwea...ysql_config.htm