JJBlaha

if($read == '0') { $sql2 = "UPDATE privatemessages SET read = '1' WHERE id='$id'"; $result2 = @mysql_query($sql2,$connection); if($result2) { echo "great success!"; } else { echo "you fail!"; } } outputs you fail! i know the id whatever is there, and i know the read is set to 0 there so why doesnt the script work?

Thanks alot, thats exactly what i needed :). 

sorry if i was not clear enough, ill try to explain exactly what i need to do. <? $n1 = 0; include('dbconn.php'); $sql = "select * from formfields WHERE category='$category' order by formfield"; $result = @mysql_query($sql, $dbh); while ($Array = @mysql_fetch_array($result)){     $formfield = $Array['formfield'];  $n1 = ($n1 + 1); echo "<tr><td>$formfield: <br><select name=\"title$n1\">"; $sql2 = "select * from formoptions WHERE formfield='$formfield' order by formoption"; $result2 = @mysql_query($sql2, $dbh); while ($Array = @mysql_fetch_array($result2)){ $formoption = $Array['formoption']; echo "<option name=\"$formoption\">$formoption</option>"; } echo "</select></br>"; } ?> which creates a bunch of forms that looks like ExampleForm1: <select name="info1"> bunch of options </select> ExampleForm2: <select name="info2"> bunch of options </select> ExampleForm3: <select name="info3"> bunch of options </select> etc... the variable $formfield is the name of the form. in this case ExampleForm1, ExampleForm2, etc after the user has filled in the forms i want to input both the name of the form and the user input into a database.  so for each form made i would do something similiar to <? $info = $_POST['info1']; $formfield = ??????; $sql3 = "insert into forms (title, info) values ('$formfield', 'info')"; ?> I hope this makes it clearer :)

I forgot that, then something along the lines of $n = 1; while (whatever){ $b = $Array['b']; $a{$n} = $b $n++ } echo "$a5'; should output the fifth part of $Array['b'];

i want to make a variable with a variable name in it. something like $n = 1; while (whatever){ $b = $Array['b'];  ${$n}a = $b $n++ } then later on in the script to get the value of $b at the first run of the while statement i would use $1a and echo "$5a'; should output the fifth part of $Array['b'];  Is there any way i can do this?