Strange data being returned:
The query in phpMyAdmin returns 274 rows (with 6 columns fields)
When I refresh, "bad" data is added to results and "bad" data replaces hard coding:
for example:
<td> Field 2 data ðXT€ðXT€ </t àîþ
while the line should be: <td> Field 2 data </td>
What is happening? Thank you!
Code is below:
<?php require_once('../Connections/connEng.php'); ?>
<?php
mysql_select_db($database_connEng, $connEng);
$query_rsTest = "SELECT table1.a1, table1.a2, table1.a3, table1.a4, table1.a5, table2.b2 FROM table1, table2 WHERE table2.b1 = table1.a1";
$rsTest = mysql_query($query_rsTest, $connEng) or die(mysql_error());
$row_rsTest = mysql_fetch_assoc($rsTest);
$totalRows_rsTest = mysql_num_rows($rsTest);
?>
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<table width="75%" border="1">
<tr>
<td>Field 1</td>
<td>Field 2</td>
<td>Field 3</td>
<td>Field 4</td>
<td>Field 5</td>
<td>Field 6</td>
</tr>
<?php do { ?>
<tr>
<td><?php echo stripslashes($row_rsTest['a1']); ?></td>
<td><?php echo stripslashes($row_rsTest['a2']); ?></td>
<td><?php echo stripslashes($row_rsTest['a3']); ?></td>
<td><?php echo stripslashes($row_rsTest['a4']); ?></td>
<td><?php echo stripslashes($row_rsTest['a5']); ?></td>
<td><?php echo stripslashes($row_rsTest['b2']); ?></td>
</tr>
<?php } while ($row_rsTest = mysql_fetch_assoc($rsTest)); ?>
</table>
</body>
</html>
<?php
mysql_free_result($rsTest);
mysql_close();
?>
<?php require_once('../Connections/connEng.php'); ?>
