|
|
| |
1. mysql5 php script query not working .. works in mysql3 |
|
Reply |
|
|
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 |
There is 1 reply in this thread, which is not being displayed.
Browsing this forum thread replies is available only to premium subscribers.
Go to the premium subscriptions page to learn how to become a premium subscriber and have full access to this forum. |
Stumble It!
Bookmark in del.icio.us
