WendyLady

Did you figure this out?  Are you saving your dates in a MySQL table?  Could you create another column or table that tallies the number of appointments for each day, that updates itself as appointments are created?  Then have your little calendar pull its info from the secondary table for color & click-ability? Wendy

Has this PHPfreaks tutorial been any help to you?  Actually, I would like to know since I'll be doing this before long: http://www.phpfreaks.com/tutorials/43/0.php

I integrated PHPList (http://www.phplist.com) for someone -- and it allows this function.  It is free code, so you might take a look at how they handled it in their package.  (Sorry to not be of more help directly.) Wendy

The only part of your code that is unfamiliar to me in syntax is: [quote]$queryexe = mysql_query($sql); while(mysql_fetch_row($queryexe))     {   $tema = mysql_result($queryexe, "tema");    $ritmo = mysql_result($queryexe, "ritmo");[/quote] I usually would write this for mysql_fetch_row: [quote]$queryexe = mysql_query($sql); while(list($tema, $ritmo) = mysql_fetch_row($result)) { echo '   <tr>   <td class="listas" bgcolor="#f7efde"> ' . $tema . '</td>   <td class="listas" bgcolor="#f7efde"> ' . $ritmo . '</td>   </tr>'; } [/quote] Maybe this will help?  I know it is irrational, but I always avoid escaping out of php in the middle of a query because it always seems to cause problems for me.  Mostly, though, try the while(list() syntax. Wendy

Your question doesn't quite make sense, but [i]maybe[/i] I have an idea of what you are trying to say. Do you mean a code that will let them know they are still banned & for how many days, & will stay updated?  I designed an automatic member-management thing once, and I just put a simple code at the beginning of the home page, the admin index page, and the login page that ran through the members and changed a boolean flag for members whose expiration dates had passed -- so that you might actually block your own expired access just by trying to login.  Anyone who visited the site caused the updates to occur just by opening the page(s).  There is a name for this, "robot code" or "dummy code" or something, but I can't remember what it is -- but it works really well.  Would something like this work for updating number of banned days with your members? If that isn't what you mean, can you elaborate? Wendy

Do you have a timeout for inactivity?

Thanks so much!  I had to tweak it for my particular code, but the concept works beautifully! Thanks again -- Wendy

Hi all -- I hope you are having a great weekend. If I have dates stored in a unix timestamp, is it possible to do a MySQL query that pulls all dates from a certain month?  Do I have to pull all the dates first & then specify the ones I want (seems resource-intensive)? Thanks so much! Wendy

Sorry for long delay before adding update: I didn't get any of these to work, and finally decided to add a secondary step.  The user first sees a list of dates, then chooses one & a second query pulls everything for that date.  It is slightly more convoluted for the user, but it works well. Thanks everyone!

I hope this is a simple question that I've just been sitting here too long writing code & my brain is fried. What I am basically trying to do is pull lists from MySql.  I have three tables.  One table is a list of possible dates, and the other two tables have various events, each one with a date that corresponds to one in the first table. What I want to be able to do is pull each date, then list below each one all the rows from the 2nd & 3rd tables that have that date.  There may be multiple dates, each one with multiple listings below it.  For some reason, I can't get my brain around how to echo this out logically. The logic flows as: --find all dates in table 1 that have boolean flag of "1" --go to table 2 and table 3 and find all events that have one of these dates --list each date with its corresponding events below I'm not looking for explicit code, but rather just some help with how to do this in code.  It seems like it should be simple, so it is making me feel really dumb, LOL.  Am I thinking about it too hard? Thanks! Wendy

Hmmmm -- I'm surprised no one has said this before: A class definition can be used many times on a single page -- for example, a paragraph or a span can have the class [b].bold[/b] and this can be used throughout the page, many times.  It is typically a more general style. An ID definition is more restrictive, and each ID should only appear once on a page.  An example of this is #submenu --> or using the id="current" for navigation, to show which page a person is on.  There is only going to be one submenu on the page with this style, or only one tab can be "current".  If you use IDs multiple times, you can get interesting results in different browsers. Introduction to IDs vs. Classes: http://www.tizag.com/cssT/cssid.php Uses the id="current" for navigation (classic tutorial): http://alistapart.com/articles/slidingdoors/ Lots & Lots of General Help on CSS: http://www.w3.org/Style/CSS/learning

Hi everyone -- I love this new layout! I'm on a new project with a sort of difficult person.  The page I'm building may be visited by someone with a Navajo language pack, and she wants to make sure it is accessible, so she is asking me to change all the fonts to Times New Roman "so that it will be compatible with Navajo". Okay, maybe [b]I'm[/b] the one who is ignorant, but this seems really ridiculous.  I do virtually all style from an external CSS file, so what difference does this make to a language pack?  Doesn't it read the fonts the same?  I'm doing some research, but can anyone enlighten me on this? Thanks, Wendy

Hello -- Hopefully I can post this question here, as I don't know of a more appropriate place for it. I have just finished a project -- my first "paying gig" for a fairly complicated PHP/MySQL-driven site. It is a searchable database, where users can search & find contacts, customers can pay for a place in the database, register a new account, & login to modify their own information. There is a full admin side where the admin can manage the database & users. It includes automated processes for approving new accounts, suspending expired accounts, manually entering & editing & suspending accounts, etc. It is a setup for a business. The problem is, I'm not sure at all what is typical for rates & billable hours. I had in mind to bill for around 40 hours at $30/hour. It took me longer than 40 hours for sure, but it was a project that really pushed my skills & I had to do a lot of research & learning to get it done. It required 62 total PHP files, and I was figuring that even if I had been very experienced when I started, it would have taken me around an hour per file just to enter everything & debug. Is this typical? Am I way over- or under-charging? Thanks, Wendy

Mags -- I hope you get a better answer than mine, because I can't think of how you can do this with straight PHP. I know it would be possible with Javascript, though. I have seen these before where it changes the second menu as soon as you select the first one, not with a submit button. With straight PHP & hitting a submit button, the only thing I could think of is to have Switch statements to move through or something, where once you hit submit, the previous selection grays out or becomes just text, and you would have links to go back & reenter a previous selection. But I'm not sure if that would work for what you're doing (does what I'm saying make sense?). Wendy

Hello -- I'm working on an admin page that pulls values from MySQL into a pre-filled form, so that the administrator can make changes. Then when submitted, it updates the row in MySQL to be what is on the form. One of the fields is a category checkbox list that is populated by a request from another table (the admin sets the categories & can change them, and users can select the categories they fit in). To send this information to the database in a comma-separated string (so that it is in a text-searchable string for another part of the site), I have been using: $description = implode(',', $_POST['category']); when I call my variables. HOWEVER, I can't figure out how to repopulate the checkbox list as checked where the user had checked it, so I am just printing the string of current categories & would like for these to ONLY be changed if new checkboxes are checked. Otherwise, I want it to NOT change that entry. I've been trying this (and similar other things): if (isset($_POST['category']) && (strlen($_POST['category']) >= 1)) { $description = implode(',', $_POST['category']); } Also tried: if ($_POST['category'] != ""){ $description = implode(',', $_POST['category']); } but it keeps updating the field to empty if nothing is checked. I would appreciate your comments! Thanks, Wendy