[SOLVED] PHP doesnt seem to work on this script!

[lewis987]

well, i want PHP to query a table to get the theme that the use has set, then query another database to get the path of the theme

 

so like this

Q1=get theme from user settings table

Q2=Get theme Path from theme table

 

Here is my code:

//SELECT CORRECT THEME
if($user){
$themesql2=mysql_query("SELECT * 
FROM `$settings` 
WHERE `user` = '$user'");
$themerows2=mysql_fetch_array($themesql2);
$theme=$themerow['theme'];

$themesql1="SELECT * 
FROM `drw_themes` 
WHERE `name` = '$theme'";
$themeresult1=mysql_query($themesql1);
$themerows1=mysql_fetch_array($themeresult1);
$path2=$themerows1['path'];
echo $themesql1;
?>
<link href="<?PHP echo $path2; ?>style.css" rel="stylesheet" type="text/css" />
<?PHP
}
else
{
$defaultsql=mysql_query("SELECT * FROM $themes WHERE `name`='default'");
$defaultrows=mysql_fetch_array($defaultsql);
$path1=$defaultrows['path'];
?>

<link href="<?PHP echo $path1; ?>style.css" rel="stylesheet" type="text/css" />
<?PHP

}

[AndyB]

You don't actually state a problem.

Perhaps

$themerows2=mysql_fetch_array($themesql2);
$theme=$themerow['theme'];

Should be

$themerows2=mysql_fetch_array($themesql2);
$theme=$themerows2['theme'];// edited version

[lewis987]

ok, that didnt work either

 

but i found the error.