pleaze help show cat name

matrex722

what is the wrong with this code ?

$dbconnect=@mysql_connect($sdbhost,$sdbuname,$sdbpass);
    $dd=@mysql_select_db($sdbname,$dbconnect);
    $id=intval( $_GET['id'] );
    $id=preg_replace("/'\/<>\"/","",$id);
    $id=strip_tags($id);

$kcats = @mysql_query("SELECT * from games WHERE id='$id' AND activelink='1'");
$prow = mysql_fetch_array($ksscats);
$cats = @mysql_query("SELECT * from games_category WHERE cat_id='$prow[$cat_id]'");
$row = mysql_fetch_array($cats);


        if($htmllink==on) {
$catu="showgames-".$row[cat_id].".html";
} else {
$catu="show.php?cat=game&catid=$row[cat_id]";
}

$catname="<br><p align=\"right\"><a href=\"index.php\">$scriptname</a>  &raquo;&raquo; <a href=\"$iinxzckl\">$mainnam</a> $nlo <a href=\"$catu\">$prow[cat_name]</a> &raquo;&raquo; <a href=\"$kkkm\" title=\"$prow[proname]\">$prow[proname]</a> </p><br><br>";
@mysql_free_result($sscats);
$scatb=pcats($catid,$cat);

i want cat_name appear it wont i dont now why

by the way cat name is in games_catagory

plz help me

Bjom

What's wrong with this code? There are "@" characters in front of all your mysql calls for a start....

What happens and what did you expect to happen?

matrex722

forgive me im new in php

alot of things i still learning

can you please correct it for me

and make cat_name appear

matrex722

i mean this :

<a href=\"$catu\">$prow[cat_name]</a>

bradgrafelman

matrex722 wrote:
can you please correct it for me

No, because that wouldn't be teaching you anything other than how to make other people do things for you. 🙂

The "@" character in front of a function/variable/expression/etc. is the PHP "error suppressor," meaning it hides all PHP error messages and prevents them from being logged. Bjom suggested that you remove all of them because a) they should never be necessary, and b) you can't properly debug code if you're telling PHP to ignore any errors in it.

So, remove the "@" error suppressors, make sure display_errors is turned On and error_reporting is set to E_ALL (check [man]phpinfo/man if you aren't sure), and try running your script again. See if any error messages appear and, if so, post them here for us.