Hi,
I have a page with a link
<a href="Contribut or.php?action=& SubCat=<?php echo $row["writer"];
?>"><?php echo $row["writer"];?></a>
that does to a page with a SELECT
$query = "SELECT * FROM news WHERE writer='$SubCat ' ";
But it is not pulling any data from the database. If I do this
$query = "SELECT * FROM news WHERE writer='Bob Smith' ";
works great??
also
the ULR reads -
Contributor.php ?action=&SubCat =Bob%20Smith
so I know the link is correct ....
but for the life of me I can't figure out whats wrong with the SELECT
statement?
If anyone can help me with this I would be forever in your Debt.
Thanks
here is the complete Contributor.php script.
<!DOCTYPE html
PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"><!--
#BeginTemplate "/Templates/journ.dwt" -->
<head>
<meta http-equiv="content-type" content="text/html;
charset=ISO-8859-1" />
<!-- #BeginEditable "doctitle" -->
<title>paper</title>
<!-- #EndEditable -->
<link rel="stylesheet " href="Styles/template.css" type="text/css" />
</head>
<body>
<div id="container" >
<div id="logo"><img src="Images/logo.jpg" border="0"
alt="logo"></div>
<div id=bar><form action="a.php" method="POST">
<label for="searchtxt" >Search our archives:</label>
<input id="searchtxt" type="text" name="searchtxt " value="" />
<input class="button" type="submit" value="Search" /></form>
</div>
<div id="header">
<!-- #BeginEditable "Adds" --><div
id="athlete"><i mg
src="../Images/Athlete.gif" border="0" alt="AthleteMon th">
<img src="../Images/AthleteMonth.jp g"
border="0"
alt="AthleteMon th"><br>
Susan smith</div>
<br>
<? include("Ads.ph p") ?><!--
#EndEditable -->
</div>
<div id="sidebar">
<div id=writer>Your News</div>
<div id="navcontaine r">
<ul id="navlist">
<table>
<?
$query = "SELECT DISTINCT cat FROM news";
$result = mysql_query($qu ery)
or die ("no can do.");
while($row = mysql_fetch_arr ay($result))
{
?>
<tr>
<td>
<li><a href="../<?php echo $row["cat"];?>"><?php echo
$row["cat"];?></a></li>
</td>
</tr>
<?php
}
?>
</table>
------------------------
<li><a href="Classifie d.php">Classifi ed Ads</a></li>
<li><a href="Advertise .php">Advertise With Us</a></li>
<li><a href="About.php ">About Us</a></li>
<li><a href="FindUs.ph p">Contact Us</a></li>
</ul>
</div>
<div id=writer>Visit our Sponsor</div>
<!-- #BeginEditable "Left" -->{Left}<!--
#EndEditable -->
</div>
<!-- #BeginEditable "middle" -->
<!--
-----------------------------------------NEWS-------------------------------------------------------------
-->
<div id="content">
<div id="bodymenu">N ews</div>
<table>
<?
$query = "SELECT * FROM news WHERE writer='$SubCat ' ";
$result = mysql_query($qu ery)
or die ("no can do.");
while($row = mysql_fetch_arr ay($result))
{
?>
<tr>
<td>
<div id="bodyhead">< ?php echo $row["heading"];?></div>
</td>
<td>
Issue: <a href="#"><?php echo $row["date"];?></a>
</td>
</tr>
<tr>
</tr>
<tr>
<td colspan=2>
<div id=bodywords>
<?php
$abc = ($row["article"]);
$abc=substr($ab c,0,400);
echo $abc;
?>
......<span class="class1"> <a href="#">Read the article</a></span>
</div>
</td>
</tr>
<?php
}
?>
</table>
</div>
<!-- #EndEditable --</div>
</body>
<!-- #EndTemplate --></html>
