https://proxy2.de/forum/posts/list/3.php JForum - http://www.jforum.net
so far i have

open header.php
[code]
$TPL[GB_LOCATION]
[/code]

put it in header where i wanted to display it

then opened gb.class.php

AFTER
[code]
$this->db->fetch_array($this->db->query("select count(*) as total from ".$this->db->table['data']));
$this->total = $this->db->record["total"];
[/code]

I ADDED THIS
[code]
$this->db->fetch_array($this->db->query("SELECT location from book_data WHERE location = Arizona"));
$this->location = $this->db->record["location"];

$TPL['GB_LOCATION'] = $this->gender;
[/code]


Unfortunately, WHERE location = Arizona ..

is giving me an mysql error.

do you know how i can change it to make it work?

I'm guessing i have to say that arizona is the value somehow and thats what i'm missing.

Any help would be much appreciated

well i might be missing other stuff..

How would i use that to display the number of people with arizona as their location?]]> https://proxy2.de/forum/posts/preList/3672/10748.php https://proxy2.de/forum/posts/preList/3672/10748.php GMT

]]> https://proxy2.de/forum/posts/preList/3672/10749.php https://proxy2.de/forum/posts/preList/3672/10749.php GMT