i have a sql problem :\
Posted: Thu Apr 26, 2012 12:29 pm
[text]
mysql_query("SET NAMES 'utf8'");
$sql431=mysql_query("SELECT * FROM categories,pages WHERE categories.Id AND pages.thecategory =".$arts_id);
$resulttitle=mysql_fetch_assoc($sql431);
[/text]
i have a page with a
.php?cat=here the $arts_id
and i have :
[text]if(isset($_GET['cat']))
$arts_id = $_GET['cat'];[/text]
but i cant get the title of the category
--
all the names of tables and fields are right!
mysql_query("SET NAMES 'utf8'");
$sql431=mysql_query("SELECT * FROM categories,pages WHERE categories.Id AND pages.thecategory =".$arts_id);
$resulttitle=mysql_fetch_assoc($sql431);
[/text]
i have a page with a
.php?cat=here the $arts_id
and i have :
[text]if(isset($_GET['cat']))
$arts_id = $_GET['cat'];[/text]
but i cant get the title of the category
--
all the names of tables and fields are right!