A blank page for my little script! Please Help!

runar56

Hey, can anybody help me with this piece of code:

<?php
error_reporting(7);
ini_set("display_errors", "on");

$name="%";
include "config.php";
$module = "eng";

function gettemplate($location) {
global $module, $name;

switch ($module)
{
CASE "eng":
$query = "SELECT code FROM site_templates WHERE name =\'" . $location . "\'";
break;
CASE "arab":
$query = "SELECT code FROM arab_templates WHERE name =\'" . $location . "\'";
break;
default:
$query = "SELECT code FROM site_templates WHERE name =\'" . $location . "\'";
break;
}
if (mysql_errno()) print mysql_error();
$result = mysql_query($query);
$template = mysql_fetch_array($result);

return $template;
}

gettemplate("logolocation");

All it returns is a blank page. Now the idea is to Have a MySQL based Template system, sort of which you would find in vbulletin.

Now, does anybody find anything wrong with this? Because I can't see it!

Any Help is Very much apprechiated!

ctimmer

I don't see where you output (print/echo) anything unless there is an SQL error.

runar56

Well, what am I doing wrong then? Sorry, I am a bit new to PHP.😃 But shouldn't the gettemplate() function return the hhtl value in the template in the database?

ctimmer

Try this:

$temp_array = gettemplate("logolocation");
print $temp_array['code'] ;

You are getting the first row of the result set from 'gettemplate'.

runar56

Thing is, I wanna be able to user it all over my site! This is just a test example, so when I actually go and make the site, I wanna be able to put the gettemplate() function wherever Iw ant many times, with multiple refcords in the database.

runar56

Anyone know how to fix this? At all? If you have any questions about this please ask me.😉 🙂

See, I want my database to havre HTML code stored in it. So when the functyion gets the Html code it displays it normally.😉