Arduino ethernet webclient php script and mysql

I'm still unable to get the Arduino web-client to accept commands from a server PC.

Well, it looks like you have a mix of client and server in your code which I haven't tried. I suggest you work on the client part first. A client sends a request to a server, and the server sends info back to the client. For the client to do something like turn on lights and such, the client needs to evaluate the info returned from the server for what to do. The below simple client code shows what is received by the client from a server. The actual requested info contained in the returned material is the "woohoo...zoomkat" part. The rest is standard HTTP stuff. For the client to act on the returned info, the "woohoo...zoomkat" part would need to be extracted and evaluated for commands.

//zoomkat 11-13-10
//simple ethernet client test code
//for use with IDE 0021 and W5100 ethernet shield
//modify the arduino lan ip address as needed
//open serial monitor to see what the arduino receives
//push the shield reset button to run client again

#include <SPI.h>
#include <Ethernet.h>

byte mac[] = { 0xDE, 0xAD, 0xBE, 0xEF, 0xFE, 0xED };
byte ip[] = { 192, 168, 1, 102 };
byte server[] = { 208, 104, 2, 86 }; // zoomkat

Client client(server, 80);

void setup()
{
  Ethernet.begin(mac, ip);
  Serial.begin(9600);
  Serial.println("starting simple arduino client test");
  Serial.println();

  delay(1000);

  Serial.println("connecting...");

  if (client.connect()) {
    Serial.println("connected");
    client.println("GET /~shb/arduino.txt HTTP/1.0");
    client.println();
  } else {
    Serial.println("connection failed");
  }
}

void loop()
{
  if (client.available()) {
    char c = client.read();
    Serial.print(c);
  }

  if (!client.connected()) {
    Serial.println();
    Serial.println("disconnecting.");
    Serial.println("==================================");
    Serial.println("");
    client.stop();
    for(;;);
  }
}