|
Posted by bokke on 10/26/06 17:58
hi Jay,
$query = "SELECT * FROM news WHERE writer=" . $_GET["SubCat"] . "";
$result = mysql_query($query)
or die ("no can do.");
gets me a good old "no can do". besides I have these Select scripts
working on other sites without the GET??
thanks though
Jay wrote:
> " . $_GET["SubCat"] . "
>
> bokke wrote:
> > Hi,
> >
> > I have a page with a link
> >
> > <a href="Contributor.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"><img
> > src="../Images/Athlete.gif" border="0" alt="AthleteMonth">
> > <img src="../Images/AthleteMonth.jpg"
> > border="0"
> > alt="AthleteMonth"><br>
> > Susan smith</div>
> > <br>
> > <? include("Ads.php") ?><!--
> > #EndEditable -->
> > </div>
> > <div id="sidebar">
> >
> > <div id=writer>Your News</div>
> > <div id="navcontainer">
> >
> > <ul id="navlist">
> > <table>
> > <?
> > $query = "SELECT DISTINCT cat FROM news";
> > $result = mysql_query($query)
> > or die ("no can do.");
> > while($row = mysql_fetch_array($result))
> > {
> > ?>
> > <tr>
> > <td>
> > <li><a href="../<?php echo $row["cat"];?>"><?php echo
> > $row["cat"];?></a></li>
> > </td>
> > </tr>
> > <?php
> > }
> > ?>
> > </table>
> > ------------------------
> > <li><a href="Classified.php">Classified 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.php">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">News</div>
> > <table>
> > <?
> > $query = "SELECT * FROM news WHERE writer='$SubCat' ";
> > $result = mysql_query($query)
> > or die ("no can do.");
> > while($row = mysql_fetch_array($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($abc,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>
[Back to original message]
|