Wednesday, May 21, 2008

Hello all- I am slightly new to the programing world. I have read some articles and some people are saying not to run mysql and apache on the same machine for security reasons. Is this correct? And if I am intstalling ubuntu lamp (server edition) all on one machine- is it possible to intall apache as a virtual server in order to take care of the security issue. Thanks in advance for any advice may have.

i am wondering in terms of speed and performance which one has the most power and ability?
i am currently using MySQL but i have heard that it cannot handle more than 2000 users at the same time and it would get really slow after that- is it true?
if it is true- which one will support that many users easily? what kind of database system is MeegaVideo or YouTube using?

I m trying to pull records from a range of datetime fields. The results are coming together as expected- however the high range doesn t display any results. So if I query records between 2008-05-04 and 2008-05-08 the records stop without displaying the 2008-05-08 records- however anything beween 05 and 07 will show up...weird.

Here s my query- i ve tried many variations and they all have the same result


SELECT * FROM timecard WHERE time_in >= 2008-05-03 AND time_in <= 2008-05-08


I could put a bump into my php to add a day to the date- but I d rather figure out what I m doing wrong and fix it within the query

any help will be much appreciated - thanks!

Can you please tell me the exact order I need to do thses things for a brand new website?

I need the following for my first Ecommerce site but Im not sure what I need to do FIRST to even begin- thanks! :)


Templates ( do I buy one?)

database to store all items


shopping cart


Is that all I need and HOW do I start working on my site if I havent been hosted yet- and HOW do I create a database in MYSQL without hosting? Is that possible ?


Thanks again :)

I realize this is more of a server question than a networking one- but hopefully somebody could shed some light on this for me.

We have a client running a .net setup across IIS; we ve convinced them to install PHP an MySQL on their system. They re wondering what type of performance impact or footprint these installs will leave on their system. I just don t know enough about servers to answer it effectively; I stick to coding and leave the server stuff to more capable people.

Oh- btw - they re also going to be running MS SQL Express on the same box for some legacy applications they have in place.

Any help would be appreciated - thanks!

i connect to a Database and want to check if there is a field in that DB named for example X or not
can any 1 plz help me ? :D
p.s i can connect to db - also can select db - i just want a command to check if there is any field in this db called x or not

No comments: