Jump to content

Archived

This topic is now archived and is closed to further replies.

RJT

Organisation Help

Recommended Posts

In my add data form, there is a category option. Im trying to make a series of pages that will list the appropriate data for each category ($category). For Example if the category was "TNA" then it would only list the data that was given that category in the add data form. For some reason i get an error message when i use this code. Could anyone point out where the problem is?

[code]
<?php include('http://www.reef-break.com/cawcenter/header.php') ?>

<?
include("dbinfo.inc.php");
mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT * FROM caws ORDER BY name WHERE category='TNA'";
$result=mysql_query($query);

$num=mysql_fetch_array( $result );

mysql_close();

echo "<b><center>Viewing All CAWs ($num)</center></b><br>";

?>

<?
$i=0;
$first_letter_old="";
while ($i < $num) {
    $name=mysql_result($result,$i,"name");
    $category=mysql_result($result,$i,"category");
    $first_letter=substr($name,0,1);
    if (($first_letter!=$first_letter_old)&&($first_letter_old!="")){
        echo "<br />";
    }
    $first_letter_old=$first_letter;
    ++$i;
    echo "<a href='http://www.reef-break.com/cawcenter/svr2006/caw.php?name=$name'>$name</a><br>";
}

?>

<?php include('http://www.reef-break.com/cawcenter/footer.php') ?>
[/code]

Thanks.

Share this post


Link to post
Share on other sites
And why can't you simply add a WHERE clause? Or did I miss something?

Share this post


Link to post
Share on other sites
You said you got an error... what's the error? PHP, MySQL?

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.