displaying records in a table on a browser

Ikem

I have used this snippet to send a set of records to display on a table on the browser, However, it does not work properly, it displays a table with the right amount of rows , but each cell contains 1, 1; 1,2; 1.3; and so on. Can you help, this is my first PHP dev.

<?php

include("connect.php");

$sql = "Select * From qryAwards WHERE EventsID = $EventsID AND EventStatus = 'Active'"; 

$result = odbc_exec($connection, $sql); 

 echo ("<table border=1 width=400>");

echo ("<tr><th>Ref Number</th><th>Title</th><th>Description</tr>");

while  ($MyRows = odbc_fetch_row($result) == true) {

	print ("<tr><td>$MyRows, 1</td><td>$MyRows, 2</td><td>$MyRows, 3</td></tr>");

	}

	echo ("</table>");	

include("disconnect.php");

sks1024

you need give the field names along with the result variable in your case $MyRows

[field_name] these are the names of your fields in your db

you have

print ("<tr><td>$MyRows, 1</td><td>$MyRows, 2</td><td>$MyRows, 3</td></tr>");

should be

print ("<tr><td>$MyRows['field_name'], 1</td><td>$MyRows['field_name'], 2
</td><td>$MyRows['field_name'], 3</td></tr>");

Stan

pete_bisby

You are using $MyRows not as the resulting row, but as the returning row being successful, which is why you are displaying a 1.

Use odbc_result($MyRows, x), where x would be the field number from your SELECT query, or the name of the field itself.

e.g.
$column0 = odbc_result($MyRows, 0);
$column1 = odbc_result($MyRows, 1);

... then use these variables in your print statement

Also, try using the field names instead of * in your SELECT query - if you alter the table structure in any way, it could affect the display results in your queries later on.

sks1024

<?php

include("connect.php");

$sql = mysql_query("Select * From qryAwards WHERE EventsID = $EventsID AND EventStatus = 'Active'");

$result = odbc_exec($connection, $sql); 

print "<table cellpadding=0 cellspacing=0 border=1><tr><td align=center><b>Field 1</b></td><td align=center><b>Field 2</b></td><td align=center><b>Field 3</b></td></tr>"; 

while ($MyRow = mysql_fetch_array($sql)) { 
$field1 = $Myrow["1"]; //change the number 1 to the first field name in your database
$field2 = $MyRow["2"]; //change the number 2 to the second field name in your database
$field3 = $MyRow["3"]; //change the number 3 to the third field name in your database

print "<tr bgcolor=$color><td>$field1</td><td>$field2</td><td>$field3</td><td>$field4</td></tr>"; 
} 
print "</table>"; 
?>