[Greetings From Good Old Germany]

Oh yeah, I totally forgot about that. I will get dressed in my sada-maso outfit first, solve a couple of engineering problems and then get the beer xD

[Using a Color Scheme with Putty?]

Btw there is actually a nice alternative to putty if you don't bother installing cygwin on your windows system.

 

http://smarterware.org/1118/mintty-gives-cygwin-a-native-windows-interface

 

The look and feel is like a native linux terminal even with transparancy.

I have recently switched from putty yo mintty

 

Setting the colors there is described here

http://code.google.com/p/mintty/issues/detail?id=145

[Handling Several Form Inputs]

Not too sure If I got you right.

 

If it is a single form with multiple rows of input and other fields you could name your fields as so

<input name="row1[mydate]">
<input name="row1[myname]">
<input name="row2[mydate]">
<input name="row2[myname]">

 

If you have multiple forms, then just give the forms itself different names and set hidden fields for the row ids

[Counting Two Fields In One Query]

Probably like this

SELECT
artist,
title,
url,
FirstExtracted,
   DATE_FORMAT(`FirstExtracted`,'%m-%d') AS Seconddate,
(SELECT COUNT(FirstExtracted) FROM results WHERE DATE_FORMAT(`FirstExtracted`,'%Y-%m-%d') = DATE_FORMAT(`LastExtracted`,'%Y-%m-%d')) AS FirstCount,
   (SELECT COUNT(LastExtracted) FROM results WHERE DATE_FORMAT(`FirstExtracted`,'%Y-%m-%d') = DATE_FORMAT(`LastExtracted`,'%Y-%m-%d')) AS LastCount
FROM results
WHERE DATE_FORMAT(`FirstExtracted`,'%Y-%m-%d') = DATE_FORMAT(`LastExtracted`,'%Y-%m-%d')
GROUP BY Seconddate
ORDER BY DATE_FORMAT(`FirstExtracted`,'%Y-%m-%d') DESC
LIMIT 20

 

But why do you do a count in combination with a limit...?

[install libssh2 on freebsd 8]

Not too sure if you rather mean to enable it in php, as it is a php extension.

On my FreeBSD9 Box, apache only has the ssl, but not ssh option.

For PHP check this:

http://php.net/manual/en/ssh2.installation.php

 

Basically it says to enable the option in the ini file

extension=ssh2.so

[localhost won't work anymore after virus.]

Try to check if it is accessible via 127.0.0.1, if yes check your hosts file. I think it is somewhere in C:\windows\system32\drivers\etc\hosts.

But anyway, you should consider re-installing your system.

[How To Stop Flooding Of A Form?]

You would need to store the last access time and IP address in a database table.

 

But if you take the IP as an identifier then all people behind a single NAT with the same IP will be treated as a single user.

Imagine a large university network with only a couple of external IPs and many thousand users.

[Cent OS, Red Hat or Ubuntu]

You might also take FreeBSD into consideration, depending on the purpose of your server.

With FreeBSD you will get the advantages of using ZFS (v28 currently) for a good performant file server and the ability to use jails - FreeBSD instances inside FreeBSD (sort of light-weight virtualization with the ability to nullfs other directories into them)

[Dual Booting Windows And Linux]

Make sure you install your chosen distribution AFTER windows, as Windows has a greedy bootloader that will not pick up your other OS's.

 

It does work, not automatically though.

I also have a dual setup. Windows and FreeBSD and installed Windows first.

I copied the bootfile from FreeBSD to the C partition of windows and adjusted C:/boot.ini (only added the last line)

[boot loader]
timeout=5
default=multi(0)disk(0)rdisk(0)partition(1)\WINDOWS
[operating systems]
multi(0)disk(0)rdisk(0)partition(1)\WINDOWS="Microsoft Windows XP Professional" /noexecute=optin /fastdetect
c:\boot1="FreeBSD"

 

With this, you will see the normal windows bootloader showing two options.

You might need to go for a research what exactly this boot1 file is for linux.

[Personal Linux Server]

I am not sure If Ubuntu ships with an email server by default and if not you might consider installing one like sendmail or postfix in order to be able to use the php mail functions.

[Greetings From Good Old Germany]

Hi everybody,

 

just came across this forum through google. I read a couple of threads and it looks like there are many knowledgeable people here.

I myself am a PHP developer for SweanyPHP and other freelance projects.

 

I hope we can help each other in the new future with questions and answers.

And maybe I can find a few people here willing to join sweany.

 

So greetings to everybody.

 

Pantu