[PHP] info from database

K lol im stuck and got no idea what im doing atm, but trying get this echo

Code:

---

Update TPLEVELLIST SET dwNeedExp = dwNeedExp(<-- load that value from db) where wTpLevel = wTpLevel(<- load that value from db)

---

but heres how it look it says me

Code:

---

Update TPLEVELLIST SET dwNeedExp = Select wTpLevel, dwNeedExp from TPLEVELLIST where bCharType = 4where wTpLevel =

---

and my code

Code:

---

$string1 = "Update TPLEVELLIST SET dwNeedExp = ";
$string2 = "where wTpLevel = ";
$msconnect=odbc_connect("xiah","xiah","xiah");
$msquery="Select wTpLevel, dwNeedExp from TPLEVELLIST where bCharType = 4";
$msresults=odbc_exec($msconnect,$msquery);
echo $string1, $msquery, $string2;

---

ye i know i suck :(, help the newbie plix

manually copy pasting those infos will take about 3hours so is this even possible to do aka make php that says values and so on for 900 rows of data :D

You need brackets around the nested sub-query, and I would only select dwNeedExp...I don't have a full understanding of subqueries, you might take a look at mysql.com, or find any tutorials on multiple queries in one.

I fiqured it out, aka copy pasted this http://www.w3schools.com/php/php_db_odbc.asp and changed few values soon i start learning php i think so forgive me this copy pasting xD