[RESOLVED] if/else inside print

[lilRachie]

//get table info
$query = "SELECT * FROM `VORVER`";
if($result = mysql_query($query)) {
    while ($row = mysql_fetch_array ($result)) {
        //print table info
        print "<tr><td align=center height=30>". $row["account_number"] .  "</td><td align=center height=30>". $row["consumer_last_name"] . ", ".$row["consumer_first_name"] . "</td><td align=center height=30>";

	if($row["VbyMail"]=NULL) {
		print "<input type=\"text\" name=\"VbyMail\" style=\"font-family: serif; font-size: 12px;\" size=\"25\"></td>"
//line12
		}else{
//end line12
			echo $row["VbyMail"] . "</td>";
		}

    print "<td align=center height=30>";

	if($row["VbyFax"]=NULL) {
		print "<input type=\"text\" name=\"VbyFax\" style=\"font-family: serif; font-size: 12px;\" size=\"25\"></td>"
	}else{
		echo $row["VbyFax"] . "</td>";
	}

    print "<td align=center height=30>";

	if($row["Returned"]=NULL) {
		print "<input type=\"text\" name=\"Returned\" style=\"font-family: serif; font-size: 12px;\" size=\"25\"></td>"
	}else{
		echo $row["Returned"] . "</td>";
	}

    print "</tr>";
}// end while
}// end if

Parse error: syntax error, unexpected '}' in /home/vortab.php on line 12

Anyone see what's wrong here?

lilRachie🙁🙁

[bpat1434]

Missing ";" to end the statement on line 12.

[lilRachie]

ok thanks that fixed that error but the input fields aren't showing at all

[lilRachie]

VbyMail has a value but i'm getting nothing

$row["VbyMail"] etc are not filling in correctly not carrying into the if/else within the if/while.

Anyone dealt with this before?

lilRachie

[bradgrafelman]

Your problem is with all of your if() statements like this:

if($row["VbyMail"]=NULL) {

That statement is first assigning the value 'NULL' to $row["VbyMail"] since you used the '=' assignment operator. I suspect you instead want to use a comparison operator (such as '==').

[lilRachie]

yes thanks
guess i had major brain issues with this script