[RESOLVED] Getting Int Value From DB

[obrienkev]

Hi all,

I want to store numbers in a db table(MS SQL Server)

I set the data type to int.

Then I want to display the values in the table...

echo '<h1>'.$row2['result1'].'</h1>';

However, 'No' is always printed out.

Why is this?

Thanks.

[jheitz]

Supply all the code and the CREATE TABLE script as well as some data in it... with the info you supplied I can't give you and answer...

[obrienkev]

$query = "SELECT * FROM tbl";
$result = mssql_query($query);

Table name = tbl{result1 int 4 NULL}

Any ideas?

[jheitz]

That looks fine, but there is something missing still from your PHP code:

How do you retrieve the rows? (ie: when do you assign a value to the variable $row2 that you are later referencing?

[obrienkev]

OK my table names are now this..

results{ results ID, int primary not null
class_ID int not null
ffnumber varchar 180 not null
result1 int NULL
result2 int NULL
result3 int NULL
attempts int NULL}

DB values are retrieved by..

while($row2 = mssql_fetch_array($result))
{
echo '<input type="text" class="results" name="result1['.$value.']" id="result1" value="'.$row2['result1'].'" />';
echo '<input type="text" class="results" name="result2['.$value.']" id="result2" value="'.$row2['result2'].'" />';
}

For some reason result1 value is displayed as 'NO'

Every other value is displayed correctly.

Then if I change result1 name in the database to result or result2 it works fine.

Any ideas why this is?

Thanks.

[jheitz]

No idea sorry, very odd. Bear in mind that you mention that result1 is displayed as NO while other values are displayed correctly (eg: result2) and they are both integers, so obviously that is not your problem....

I can only suggest the following as maybe helpful to find any issue:

On SQL Server run the following query: SELECT result1 FROM results

Does it bring values for all records? (maybe some records have a NULL value in this column)

[obrienkev]

Well the values don't get inserted in the first place.

Heres my code in full..

1/ Display Form Fields..

	 // get matching data from training table
 	 $query2 = "SELECT DISTINCT training_ID, t.class_ID, t.ffnumber, firstname, surname, attended ".
	 				 	 "result1, result2, result3, result4, attempts ".
	 					 "FROM training t ".
						 "INNER JOIN results r ".
						 "ON t.ffnumber = r.ffnumber ".
	 					 "WHERE t.class_ID = '$class'";
	 //echo '<p>'.$query2.'</p>'; 
	 $result2 = mssql_query($query2) or die('Select Error');
	 $num_results2 = mssql_num_rows($result2);
   //echo '<br />RESULTS:'.$num_results2.'<br />';

   // display ffnumbers from results
	 while($row2 = mssql_fetch_array($result2))
	 {
	 	   $value = $row2['ffnumber'].'-'.$row2['class_ID'];
 	 	   echo '<tr><td>'.$row2['ffnumber'].'</td> '.
			      '<td>'.$row2['firstname'].'</td> '.
			 			'<td>'.$row2['surname'].'</td> '.
			 			'<td>'.$row2['attended'].'</td> '.
						'<td><input type="text" class="results" name="attempt['.$value.']" id="attempt" value="'.$row2['attempts'].'" /></td> '.
						'<td><input type="text" class="results" name="result1['.$value.']" id="result1" value="'.$row2['result1'].'" /></td> '.
						'<td><input type="text" class="results" name="result3['.$value.']" id="result3" value="'.$row2['result2'].'" /></td> '.
						'<td><input type="text" class="results" name="result4['.$value.']" id="result4" value="'.$row2['result3'].'" /></td> '.
						'<td><input type="text" class="results" name="result4['.$value.']" id="result4" value="'.$row2['result4'].'" /></td> '.
	 		 			'<td> '.
						'</td></tr>';
	 }

2/ Declare Variables

$attempt = $_POST['attempt'];
$result1 = $_POST['result1'];
$result2 = $_POST['result2'];
$result3 = $_POST['result3'];
$result4 = $_POST['result4'];

3/ Update Table...

// UPDATE RESULT1 SCORE
foreach($result1 as $i => $j)
{
   echo $i .' => '.$j;
	 list($ffnumber, $class_ID) = split('[/.-]', $i);

 if($j != '')
 {
     $query2 = "UPDATE results ".
		 	         "SET result1 = '$j' ".
			     		 "WHERE ffnumber = '$ffnumber' ".
			  	 		 "AND class_ID = '$class_ID'";
   echo $query2.'<br />';
 		 $final_result = mssql_query($query2) or die('Update Query2 Error');
 } // end if

} // end foreach


// UPDATE RESULT2 SCORE
foreach($result2 as $i => $j)
{
   echo $i .' => '.$j;
	 list($ffnumber, $class_ID) = split('[/.-]', $i);

 if($j != '')
 {
     $query2 = "UPDATE results ".
		 	         "SET result2 = '$j' ".
			     		 "WHERE ffnumber = '$ffnumber' ".
			  	 		 "AND class_ID = '$class_ID'";
   echo $query2.'<br />';
 		 $final_result = mssql_query($query2) or die('Update Query2 Error');
 } // end if

} // end foreach

// etc...

Any ideas?

[obrienkev]

Was missing a comma in the query. For some reason mssql didnt give any error.

Thanks for the help.