problem with getting data from database
Posted: Fri Jun 03, 2005 10:43 am
I am having problems I have a database which I am trying to get data from. I seem to be opening this with the sql database as I am not getting an error message and if i change the sql statement i do. my problem is that is is not reading the data for me and displaying it. The code is:
Any help appreciated as getting very frustrated here.
Code: Select all
<?php
$name = $_POST['swimmer'];
$linkID = @mysql_connect("localhost", "root", "");
mysql_select_db("lpsc", $linkID);
// $linkID = @mysql_connect("localhost", "astokes3","beebo1");
//mysql_select_db("leicester-penguins_co_uk_-_register", $linkID);
$sql ="select * from tblpbs where Name = '$name'";
$resultID = mysql_query($sql, $linkID)or die(mysql_error());
if(mysql_num_rows($resultID) < 1)
{
print "Sorry Swimmer not recognised.<p>";
}
else
{
Print "<font color='#CC0033' size='2' face='Arial, Helvetica, sans-serif' align='centre'><strong>Personal Best times for $name </strong></font>";
print "<table width='100%' border=1 bordercolor='$border' align = 'center' font color='$font'><tr><th><font color='#006666' face='Arial, Helvetica, sans-serif'>Distance</th> <th><font color='#006666' face='Arial, Helvetica, sans-serif'>Freestyle</th><th><font color='#006666' face='Arial, Helvetica, sans-serif'>Backstroke</th><th><font color='#006666' face='Arial, Helvetica, sans-serif'>Breastroke</th><th><font color='#006666' face='Arial, Helvetica, sans-serif'>Butterfly</th><th><font color='#006666' face='Arial, Helvetica, sans-serif'>Individual Medley</th>";
while ($row = mysql_fetch_assoc($resultID))
print "<tr align='center' bgcolor='#ffffff'>";
{
print "<td>25m</td>
print "<td>$row['25mfs']."</td>";
print "<td>".$row['25mbs']."</td>";
}
print "</table>";
}
mysql_close($linkID);
?>