Hi,
I upgraded php from php 4.0.5 to 4.2.2 and i also upgraded to the latest apache 1.3.something version and started the configuration files from scratch.
now my php scripts don't seem to pull information from the database. phpMyAdmin works perfectly but my scripts return blank information no errors or anything.
Does anyone have any idea what may be causing this.
here is an example of my code:
--mysqlconnectinfo.php
<?php
// MySQL Information
$dbhostname = "info";
$dbusername = "info";
$dbpassword = "info";
$dbbase = "info";
?>
--tbtrainers.php
<?php
include("mysqlconnectinfo.php");
// Create Connection
$connection = mysql_connect($dbhostname,$dbusername,$dbpassword) or die("Couldn't make connection.");
//Select Database
$db = mysql_select_db("$dbbase", $connection) or die("Couldn't select database");
// create SQL statement
$sql = "SELECT UserName, FName, LName, Phone, AHPhone, Fax, Mobile, Email, WebSite, AreaServiced FROM Trainer_Details WHERE State = '$ts'";
// execute SQL query and get result
$sql_result = mysql_query($sql,$connection) or die("Couldn't execute query.");
echo "<h3><font face=Verdana, Arial, Helvetica, sans-serif color=#343681>Official ToolBox Trainers In $ts</font> </h3>";
while ($row = mysql_fetch_array($sql_result))
{
$AreaServiced = $row["AreaServiced"];
$UserName = $row["UserName"];
$FName = $row["FName"];
$LName = $row["LName"];
$Phone = $row["Phone"];
$AHPhone = $row["AHPhone"];
$Fax = $row["Fax"];
$Mobile = $row["Mobile"];
$Email = $row["Email"];
$WebSite = $row["WebSite"];
echo "<table width=480 border=0 cellspacing=0 cellpadding=3 align=center>
<tr bgcolor=#343681>
<td colspan=2>
<div align=center><b><font face=Arial, Helvetica, sans-serif size=2 color=#FFFFFF> $AreaServiced </b></font></div>
</td>
</tr>
<tr>
<td width=147><b><font face=Arial, Helvetica, sans-serif size=2>Name:</font></b></td>
<td width=493><font face=Arial, Helvetica, sans-serif size=2> $FName $LName </font></td>
</tr>
<tr>
<td width=147><b><font face=Arial, Helvetica, sans-serif size=2>Phone:</font></b></td>
<td width=493><font face=Arial, Helvetica, sans-serif size=2> $Phone
</font></td>
</tr>
<tr>
<td width=147><b><font face=Arial, Helvetica, sans-serif size=2>AH Phone:</font></b></td>
<td width=493><font face=Arial, Helvetica, sans-serif size=2>
$AHPhone
</font></td>
</tr>
<tr>
<td width=147><b><font face=Arial, Helvetica, sans-serif size=2>Fax:</font></b></td>
<td width=493><font face=Arial, Helvetica, sans-serif size=2>
$Fax
</font></td>
</tr>
<tr>
<td width=147><b><font face=Arial, Helvetica, sans-serif size=2>Mobile:</font></b></td>
<td width=493><font face=Arial, Helvetica, sans-serif size=2>
$Mobile
</font></td>
</tr>
<tr>
<td width=147><b><font face=Arial, Helvetica, sans-serif size=2>Email Trainer:</font></b></td>
<td width=493><font face=Arial, Helvetica, sans-serif size=2> <a href=traineremail.php?uname=$UserName>
Contact $FName $LName
</a> </font></td>
</tr>
<tr>
<td width=147><b><font face=Arial, Helvetica, sans-serif size=2>Web
Site:</font></b></td>
<td width=493><font face=Arial, Helvetica, sans-serif size=2> <a href=$WebSite target=_blank>
$WebSite
</a> </font></td>
</tr>
<tr>
<td colspan=2> </td>
</tr>
</table>
";
}
echo "<hr><p align=center><font size=3 color=#FF0000 face=Arial, Helvetica, sans-serif><b>Professional
National Telephone Support Service<br> 7am to 10pm - 7 days</b></font><font face=Arial, Helvetica, sans-serif size=2><br>
<a href=nationalsupport.php>[For More Information Click Here]</a></font></p>
<hr>
<p align=center><font color=#333333 size=2 face=Arial, Helvetica, sans-serif><font color=#000000><a href=trainersb.php>[How
To Become an Official Toolbox Trainer]</a></font></font></p>
</div>
";
echo "<a href=training.php><font face=Arial, Helvetica, sans-serif size=2><div align=center><b>[Back to Training page]</font><b></a></div>";
?>
Any help would be greatly apreciated
Yours Sincerely,
Anthony Irwin
