ditch
Last Activity: Jul 3 '07, 06:15 AM
Joined: Oct 26 '06
Location:
-
-
HOOAH, done it thank you for all your help, I understand now, I chnaged the query to
[PHP]$query = sprintf("SELECT phpbb_users.use rname, phpbb_users.use r_from, phpbb_users.use r_email, phpbb_ranks.ran k_image
FROM phpbb_users
LEFT JOIN (phpbb_ranks) ON (phpbb_users.us er_rank = phpbb_ranks.ran k_id)
WHERE phpbb_users.use rname = '%s'",$Logged_i n_user);[/PHP] -
Understand now, however the query I used looks like the :
[PHP]$query = "SELECT phpbb_users.use rname, phpbb_users.use r_from, phpbb_users.use r_email, phpbb_ranks.ran k_image
FROM phpbb_users
LEFT JOIN (phpbb_ranks)
ON (phpbb_users.us er_rank = phpbb_ranks.ran k_id)
WHERE phpbb_users.use rname = $Logged_in_user ";[/PHP]
When I run it, this error...Leave a comment:
-
Thank you for the reply, I understand, what you are saying, however, how can extract the data from multiple tables with that one variableLeave a comment:
-
Here is what is coded for the main page
[code=php]
<?php
session_start() ;
include 'includes/header.php';
include 'includes/navbarout.tpl';
// is the one accessing this page logged in or not?
if (!isset($_SESSI ON['db_is_logged_i n'])
|| $_SESSION['db_is_logged_i n'] !== true) {
// not logged in, move to login page
header('Locatio n: login.php');
exit;
}
...Leave a comment:
-
User Login Script with Session
Hi
I am using the following code to get users to enter their username and password, it is then checked and a new page is displayed with their username. My question is, how can I display the rest of their details from that session, I have googled and read many articles, but I am still not any futher forward, any help would be much appreciated.
[code=php]
<?php
session_start() ;
$errorMessage = '';
if (isset($_POST['txtUsername'])... -
The code is based on a button on the form and I have doubled checked the record source, it definatley comes from a query and not the table.Leave a comment:
-
Select record
Hi
I am using the following code, and basically what I want it to do is this:
User selects a Business Unit from drop down list, they then click on a button and it creates a report based on the the business unit selected from the drop down list.
It converts the reoprt to RTF and then fires up a new email, but it picks the first change champion form the table and not the query from the drop down list, any... -
The reason they all have runtime access is they hotdesk and the majority of users have links to various databases, so it just made sense to install the runtime on all machine, saves a lot of resouce.
The organistaion has some 5000 database's in one form or another, it's starting to become a nightmare moving these either to a unix or ms sql backend.Leave a comment:
-
Thank you for helping me, however, I have been a bit of a dumbass I forgot to include in the path the location of the msaccess.exe file, what a silly man I amLeave a comment:
-
There is 10500 machines and they all have runtime access on, are you suggesting that I would have to run this on every machine.Leave a comment:
-
MDW and runtime access
I am hoping somebody can help me with this small problem, I have created a workgroup file and it works fine with people who have the full version of access 2002 i.e it prompts them to enter username and password, however, some people have Runtime Access 2002, when they open the database it does not prompt them for any user details, is there a way geeting those who use runtime to prompt them for user details.
Any help on this will be...
No activity results to display
Leave a comment: