Hi Everyone,
I want to first thank you for helping with the last question I had. It
didn't help but I finally figured it out. This one though has me stumped.
I have started using a portal script thinking I might be able to see a
little better how php works. It will do fine for me as far as my site will
go. But here is the problem. I want to tell a user how many days they have
left until a certain thing happens. The portal is phpwebthings so if anyone
is familiar with it...
The problem is I can't figure out how to get the username from the database
here is the code I am trying to make work.
<?
$db["days"]=("UPDATE wt_users set days = days - 1 where uid=$uid");
$result=mysql_query($db["days"]);
$query="select name, days from wt_users where uid=$uid";
$ret = mysql_query($query);
while(list($name, $days) = mysql_fetch_row($ret))
print("$name you have $days days to complete your questionnaire");
?>
I can't get it to work unless I specify a specific user. Like $query="select
name, days from wt_users where uid=1";
How do I pull the user from the session? Also when I do specify a user and
refresh the page it updates the count down how do I get it to only update
once
a day.
Any help would be appreciated!
Thanks
Jennifer Downey
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
