Kirsten - 2013-02-23 03:57:31
$sqlconn = mysql_connect ("mysql5.xxx.xx:3305", "medschool_xer", "********")or die ("Could not connect");
$result=mysql_db_query("medschool","select id,Name,Sponsor,Eligibility,Awards,Deadline,Contact,Email,Phone,Address,Website,Fax from slusom_funding where Name='$search' group by Name ASC;", $sqlconn);
while ($row = mysql_fetch_array ($result))
{
if ($td == "0")
{
echo "<tr BGCOLOR=\"white\">";
$td="1";
}
else {
echo "<tr BGCOLOR=\"#f1f1f1\">";
$td="0";
}
echo "<td align='left' valign=top><font face='Arial,Helvetica' size='2'>\n";
echo "<a href='view_scholarship.php?id=" . $row["id"] . "'><b>" . $row["Name"] . "</b></a></td>\n";
echo "<td align='left' valign=top class=sfs><b class=sfs>Deadline: </b>" . $row["Deadline"] . "<br><b class=sfs>Contact:</b> " . $row["Contact"] . "<br>\n";
echo " " . $row["Phone"] . "<br>\n";
echo " " . $row["Fax"] . "<br><a href='mailto:" .$row["Email"] . "'>" . $row["Email"] . "</a> </font></td>\n";
echo "</tr>\n";
What that heck is wrong.
when this works to view search results by name etc. in mysql3..
I really could use some direction and an example. to migrate to the newest version mysql5
Thanks for your help