moanz

bump

nope :/

bump

well i have some basic php knowledge but im having troubles with this. I'd appreciate your help

Hi guys, Im having real trouble here, so hoping one of you could help. Heres what i need to do. I need to write / get a script, that i can enter details of stores and their locations. IE Store name, where, phone numbers, what sort of stuff they sell, what state E.T.C so that it gets entered to a database or something of the likes. And Users go to a page for example find-store.php and they choose like 'what stuff they sell' or 'what state', filtering it sortof, to search the db for matching stores and display them.. Any help would be greatly appreciated. Thanks.

its actually a custom forum, i didnt write it, but who ever did used phpBB tables or their names atleast.

well each entry into the table for guests has 2 colums. "last_on" which is a stamp of their time, and "ip" which is their ip address. so the ip would be already there in theory and the last_on would just update. however, only one entry will stay in there from what i see which just gets over written each new person that comes in !!!!! aggrvating. how can i make it so more than one will enter at one time?

i tried copying the table with auto increment but that doesnt work. any ideas?!?!?!?!

well i just had a sticky beak in the database, and the table in which guests go into, theres only one row. And each time i refresh it, its a new value. This could be the problem? How could i fix it.

Hi Guys! Just wondering if anyone can help me. I amd the coder of a fairly large website, so for security sakes I wont mention which site, and I'm having trouble with the usersonline page. Each page has the values and constants in a .php file and the template for each of these pages is a .tpl with the same name. The file in particular is the usersonline page (usersonline.php and usersonline.tpl). Everything works fine except the guests online. The page shows all members online, their names, what they are viewing, how long since they changed page/logged in and such, and at the top of the page, it has "There are X Members online right now. (Z Members and C Guests), where Z Members is always the correct number, yet for some reason, C is always 2. It ALWAYS Says there are 2 guests online, so the total is always members + 2. This is the code I have in place in the .php file $guests = $this->count_guests(); $num_guests = count($guests); $members = $this->get_members(); $num_members = count($members); $num_total = $num_guests+$num_members; $num_invisible = 0; function count_guests() { $tbl_guests = $this->project->tblname("guests"); $tenminsago = time()-(60*10); return $this->db->row( "SELECT count(*) as count FROM $tbl_guests ". "WHERE last_on>$tenminsago" ); } function get_members() { $tbl_users = $this->project->tblname("users"); $tenminsago = time()-(60*10); $query = "SELECT u.id, u.name as username, u.last_on, u.last_request, u.temple, u.pref_invisible ". "FROM $tbl_users as u WHERE u.last_on>$tenminsago ORDER BY u.name"; return $this->db->rows($query); } in the .tpl file {total} Users Online ({num_members} Members{invisible}) ({num_guests} Guests) The Invisible function shows how many members are online that have chosen invisible, but does not show any names. Can anyone give me any ideas as to fixing this problem and getting the right number of guests?