Variable HTTPPARA URL

At the moment, I am able to send data to my database by using constant values with:

Serial1.println("AT+HTTPPARA=\"URL\",\"http://xx.xx.xx.xx:xx/aard/InsertCrash.php?ID=8&MID=2&TIME=1&locationX=1&locationY=1&locationZ=1\"");

However, I need to have the values be variables. I have tried the following, and cannot figure out why it isn't working even though it returns OK:

Serial1.print("AT+HTTPPARA=\"URL\",\"http://27.32.93.185:90/aard/InsertCrash.php?");  
  Serial1.print("ID=");  // This is the value name
  Serial1.print(ID); // value of...
  Serial1.print("MID=");  // This is the value name
  Serial1.print(MID); // value of...
  Serial1.print("TIME=");  // This is the value name
  Serial1.print(TIME); // value of...
  Serial1.print("locationX=");  // This is the value name
  Serial1.print(locationX); // value of...
  Serial1.print("locationY=");  // This is the value name
  Serial1.print(locationY); // value of...
  Serial1.print("locationZ=");  // This is the value name
  Serial1.print(locationZ); // value of...
  Serial1.println("\"");

Help on this would be awesome ASAP

I have tried the following, and cannot figure out why it isn’t working

Change Serial1 to Serial, and see if it is REALLY sending what you think it is.

Keep in mind that the original had &s between the name=value pairs and the new method does not.

AT

OK
AT+CSQ
AT+CGATT?
AT+SAPBR=3,1,"CONTYPE","GPRS"

+CSQ: 9,0

OK
AT+SAPBR=3,1,"APN","live.vodafone.com"

OK
AT+SAPBR=1,1

OK
AT+HTTPINIT

OK
AT+HTTPPARA="URL","http://xx.xx.xx.xx:xx/aard/InsertCrash.php?ID=5MID=1TIME=1locationX=1locationY=1locationZ=1"
AT+HTTPACTION=1

ERROR
AT+HTTPREAD

OK

AT+HTTPTERM

OK

That is the response I got for:

Serial.print("AT+HTTPPARA=\"URL\",\"http://xx.xx.xx.xx:xx/aard/InsertCrash.php?");  //ID=8&MID=2&TIME=1&locationX=1&locationY=1&locationZ=1\""
  Serial.print("ID=");  // This is the value name
  Serial.print(ID); // value of...
  Serial.print("MID=");  // This is the value name
  Serial.print(MID); // value of...
  Serial.print("TIME=");  // This is the value name
  Serial.print(TIME); // value of...
  Serial.print("locationX=");  // This is the value name
  Serial.print(locationX); // value of...
  Serial.print("locationY=");  // This is the value name
  Serial.print(locationY); // value of...
  Serial.print("locationZ=");  // This is the value name
  Serial.print(locationZ); // value of...
  Serial.println("\"");

You need the & symbols.

It's always the little things haha, it working now with:

Serial1.print("AT+HTTPPARA=\"URL\",\"http://xx.xx.xx.xx:xx/aard/InsertCrash.php?");  //ID=8&MID=2&TIME=1&locationX=1&locationY=1&locationZ=1\""
  Serial1.print("&ID=");  // This is the value name
  Serial1.print(ID); // value of...
  Serial1.print("&MID=");  // This is the value name
  Serial1.print(MID); // value of...
  Serial1.print("&TIME=");  // This is the value name
  Serial1.print(TIME); // value of...
  Serial1.print("&locationX=");  // This is the value name
  Serial1.print(locationX); // value of...
  Serial1.print("&locationY=");  // This is the value name
  Serial1.print(locationY); // value of...
  Serial1.print("&locationZ=");  // This is the value name
  Serial1.print(locationZ); // value of...
  Serial1.println("\"");

thank you guys so much!!!