Search found 99 matches

by joecrack
Wed Jan 11, 2006 12:38 am
Forum: PHP - Code
Topic: avoid multible similar datasets
Replies: 7
Views: 333

thanks boys .. solved it.

@jshpro2 i just did a select with the postet data and if theres a similar one allready existing ERROR =)
by joecrack
Tue Jan 10, 2006 9:56 pm
Forum: PHP - Code
Topic: avoid multible similar datasets
Replies: 7
Views: 333

i know sorry .. i tried to solve my prob by reading post in this forum .. but nothing realy helped me - you have any ideas or a good url where i can read a bit more specific about it ?>??? would be nice
thx joe
by joecrack
Tue Jan 10, 2006 9:33 pm
Forum: PHP - Code
Topic: avoid multible similar datasets
Replies: 7
Views: 333

no that doesnt work, because it has to be allowed to double the customer no for example.
there can be many projects from the same customer but not i combination witjh the same date and project no/.
by joecrack
Tue Jan 10, 2006 9:18 pm
Forum: PHP - Code
Topic: avoid multible similar datasets
Replies: 7
Views: 333

avoid multible similar datasets

hi i have a big problem, i have a table where a datadset is clearly identified by three fields (project no, customer no and contract date). Now how do i tell my sql database that it is not allowed to put a exact second one with these same three fields in it. Should i make all three fields unique. Be...
by joecrack
Wed Dec 21, 2005 9:10 pm
Forum: PHP - Code
Topic: usermanagement?
Replies: 2
Views: 192

yeah nice works pretty good - but it didnt really solve my prob. okey its about a usermanagement: function namere ($session) { $result = mysql_query("SELECT Authorisation FROM AdminUser WHERE UserSession = '".$session."'") or mysql_error(); $username = mysql_fetch_array($result);...
by joecrack
Wed Dec 21, 2005 7:29 pm
Forum: PHP - Code
Topic: usermanagement?
Replies: 2
Views: 192

usermanagement?

i think this will be a very simple prob for you guys :roll:
i define a variable on one page, that includes another page.
on the included page i want to have a if function with that variable.
i tried it with $GET.... buts that didnt work...!!!///
by joecrack
Tue Dec 13, 2005 12:53 am
Forum: PHP - Code
Topic: [Solved] chech user session problem!!!
Replies: 14
Views: 776

Finally - THANKS A LOT
by joecrack
Tue Dec 13, 2005 12:23 am
Forum: PHP - Code
Topic: [Solved] chech user session problem!!!
Replies: 14
Views: 776

my LogOut Button is now just a link to a php page like this: <?php session_start(); include("connect.inc.php"); include("usermanagment.inc.php"); $return_val = UserLogout ($session); ?> And it uses the my logout function: function UserLogout ($session) { $result = mysql_query(&qu...
by joecrack
Mon Dec 12, 2005 8:19 pm
Forum: PHP - Code
Topic: [Solved] chech user session problem!!!
Replies: 14
Views: 776

PERHAPS it aswers my question - but as i wrote i dont know what do do with it trukfixer said:"simply including it does nothing, it must be called and the session id passed" OK so does that mean doing it like this: <?php session_start(); include("connect.inc.php"); CheckUserLogin(...
by joecrack
Mon Dec 12, 2005 1:26 am
Forum: PHP - Code
Topic: [Solved] chech user session problem!!!
Replies: 14
Views: 776

sorry i dont know what to do with that... just put it at the begining of the script ... put it in the unsermanagement.php or in the html?????
by joecrack
Sun Dec 11, 2005 11:30 pm
Forum: PHP - Code
Topic: [Solved] chech user session problem!!!
Replies: 14
Views: 776

man i am sorry - i searched for it - but i cant find anything.
so how do i call it and pass the ID???
by joecrack
Sun Dec 11, 2005 9:31 pm
Forum: PHP - Code
Topic: [Solved] chech user session problem!!!
Replies: 14
Views: 776

hmmm - your function is now working fine - but i found out that my login/logout script is not doin as good as i thought. it keeps me logged in all the time, only restarting my browser loggs me out. the logout page looks like this: <?php session_start(); include("connect.inc.php"); include(...
by joecrack
Sun Dec 11, 2005 8:47 pm
Forum: PHP - Code
Topic: [Solved] chech user session problem!!!
Replies: 14
Views: 776

so i set the variable like this (on an included php login script): function CheckUserLogin ($un, $pw, $session) { $result = mysql_query("SELECT UserId,Name,Vorname,UserName,UserPasswd FROM AdminUser WHERE UserName='$un' AND UserPasswd=MD5('$pw')") or mysql_error(); $zeile = mysql_fetch_arr...
by joecrack
Sun Dec 11, 2005 8:12 pm
Forum: PHP - Code
Topic: [Solved] chech user session problem!!!
Replies: 14
Views: 776

[Solved] chech user session problem!!!

i did a login script that is working pretty good. but now i want to have something that checks if a user is logged in or not - and if the user is NOT then i want him to go to the login page. so i thought about somethig like this: <?php function CheckUserSession ($session) { $result = mysql_query(&qu...
by joecrack
Wed Dec 07, 2005 7:33 pm
Forum: PHP - Code
Topic: structured table output
Replies: 0
Views: 205

structured table output

hi i would like to create a table where i select a huge number of projects, and have the project specific turnover shown by month. so in the first column there would be the projekt-nr. in the second culumn a value is only shown if - something like: ....... WHERE turnover BETWEEN '2005-01-01' AND '20...