What's Wrong With This Query?

Anon

Hi,

Part of my database has a table in it that contains newsgroups. The table has three columns - ID (autogenerated), URL (news:rec.climbing), Category (Climbing) - for example, and I want to pull the URL's from each Category and create links to them. The link would be in the format
<A HREF="news:rec.climbing">rec.climbing</A> - rec.climbing.

This is the code I'm trying to use, but that doesn't seem to work :

<?php

$HTTP_GET_VARS[´Category´];
$db = mysql_connect("localhost", "xxxxxx");
mysql_select_db("Outdoors",$db);
$result = mysql_query("SELECT URL FROM newsgroups WHERE Category = ´$Category´ ORDER BY URL",$db);
echo "<table border=1 width=600>";
echo "<tr><td>";
echo "
";
if ($myrow = mysql_fetch_array($result)) {
do {
printf("<A HREF=\" %s \">%s</A> - \"%s\"\n", $myrow["URL"], $myrow["URL"], $myrow["URL"]);
} while ($myrow = mysql_fetch_array($result));
echo "
";
echo "</td></tr>";
echo "</table>";
} else {
echo "Sorry, no records were found!";
}
?>

I'm obviously missing an important concept here, but I'm not sure what it is. Any help would be appreciated.

Thanks!

brandonschnell

what does it do? its going to mess the table up and place everything in the table inside one table cell. you might want to move the <tr> & <td> before the printf and the </td> & </tr> after the printf.

Anon

The code is supposed to go through the table, pull out all the URLS that are in the $Category category, and place them in a list as follows :

<UL>
<LI><A HREF="news:rec.climbing">rec.climbing</A>
.
.
.
</UL>

The list will be inside a table, but that's the easy part. I'm having problems figuring out how to pull out the info into an array and then get that info into the list.

brandonschnell

i can see what you're trying to do, but the question is what happens now when the script runs?

there should be no need for another array.

Anon

Brandon,

The error I get is :

Parse error: parse error, expecting `'('' in /usr/local/etc/httpd/htdocs/Newsgroups/newsgroups.php3 on line 36

Here's the code as it stands now:

<?php
$HTTP_GET_VARS[´Category´];
$db = mysql_connect("localhost", "xxxx");
mysql_select_db("Outdoors",$db);
$result = mysql_query("SELECT URL FROM newsgroups WHERE Category = ´$Category´ ORDER BY URL",$db);
?>

<HEAD>
<?php
echo "<TITLE>Outdoor Resources Online : Newsgroups : $Category</TITLE>";
?>
<SCRIPT LANGUAGE="JavaScript" SRC="http://a1028.g.akamai.net/6/1028/968/444516c765e1c0/lunafetch.about.com/cgi/luna/lunaD.js?vpn=000369"></SCRIPT>
</HEAD>
<BODY>

<SCRIPT>tabletop();</SCRIPT>
<CENTER>
<BR>
<A HREF="../index.html"><IMG SRC="../images/oro-logo.gif" WIDTH="599" HEIGHT="55" ALT="Outdoor Resources Online" BORDER="0"></A><BR>
<A HREF="../addlink.html"><IMG SRC="../images/submit-link.gif" WIDTH="160" HEIGHT="11" ALT="Submit Link" BORDER="0"></A></A><A HREF="../register.html"><IMG SRC="../images/register.gif" WIDTH="143" HEIGHT="11" ALT="Register" BORDER="0"></A><A HREF="../dead-link.html"><IMG SRC="../images/dead-links.gif" WIDTH="164" HEIGHT="11" ALT="Dead Links" BORDER="0"></A><A HREF="../link.html"><IMG SRC="../images/lets-link.gif" WIDTH="134" HEIGHT="11" ALT="Let´s Link" BORDER="0"></A>
<BR>
<BR>
<TABLE BORDER=0 CELLPADDING=1 CELLSPACING=0 WIDTH=610>
<TR>
<TD ColSpan=1 RowSpan=1 BGCOLOR=\"#669966\" ALIGN=CENTER VALIGN=MIDDLE>

<?php
echo "<FONT FACE=arial COLOR=\"000000\"><B><A HREF=\"../index.html\">Outdoor Resources Online</A>: <A HREF=\"index.html\">Newsgroups:</A> $Category</B></FONT>";
?>

</TD>
</TR>
<tr><td>
<ul>

<?php
while $result do {
printf("<LI><A HREF=\" %s \">%s</A>", $myrow["URL"], $myrow["URL"]);
}
echo "</ul>";
echo "</td></tr>";
echo "</table>";
echo "</CENTER>";
echo "<SCRIPT>tablebottom();</SCRIPT>";
echo "</BODY>";
echo "";
} else {
echo "Sorry, no records were found!";
}
?>

brandonschnell

try something like:

<HEAD>
<?php
echo "<TITLE>Outdoor Resources Online : Newsgroups : $Category</TITLE>";
?>
<SCRIPT LANGUAGE="JavaScript" SRC="http://a1028.g.akamai.net/6/1028/968/444516c765e1c0/lunafetch.about.com/cgi/luna/lunaD.js?vpn=000369"></SCRIPT>
</HEAD>
<BODY>
<SCRIPT>tabletop();</SCRIPT>
<CENTER>
<BR>
<A HREF="../index.html"><IMG SRC="../images/oro-logo.gif" WIDTH="599" HEIGHT="55" ALT="Outdoor Resources Online" BORDER="0"></A><BR>
<A HREF="../addlink.html"><IMG SRC="../images/submit-link.gif" WIDTH="160" HEIGHT="11" ALT="Submit Link" BORDER="0"></A></A><A HREF="../register.html"><IMG SRC="../images/register.gif" WIDTH="143" HEIGHT="11" ALT="Register" BORDER="0"></A><A HREF="../dead-link.html"><IMG SRC="../images/dead-links.gif" WIDTH="164" HEIGHT="11" ALT="Dead Links" BORDER="0"></A><A HREF="../link.html"><IMG SRC="../images/lets-link.gif" WIDTH="134" HEIGHT="11" ALT="Let´s Link" BORDER="0"></A>
<BR>
<BR>
<TABLE BORDER=0 CELLPADDING=1 CELLSPACING=0 WIDTH=610>
<TR>
<TD ColSpan=1 RowSpan=1 BGCOLOR=\"#669966\" ALIGN=CENTER VALIGN=MIDDLE>

<?php
echo "<A HREF=\"../index.html\">Outdoor Resources Online</A>: <A HREF=\"index.html\">Newsgroups:</A> $Category";
?>

</TD>
</TR>

<?php

if($myrow = mysql_fetch_array($result))
{

 do { 
      echo "<tr><td>";
      printf("<A HREF=\"%s\">%s</A>", $myrow["URL"], $myrow["URL"]); 
      echo "</td></tr>"; 
 } while ($myrow = mysql_fetch_array($result));


 }

else
{
echo "<tr><td>Sorry, no records were found!</td></tr>";
}
?>

</table>
</CENTER>
<SCRIPT>tablebottom();</SCRIPT>
</BODY>

Anon

Brandon,

Got it working myself right before you posted this code. We both came up with the same solution!

Thanks again,

Mark