ober

Thanks for the code John... I'll give that a whirl. Much appreciated.

What do you guys use? My servers are linux boxes and I'm curious how you guys handle Excel file creation. Pear? That stupid class on phpclasses.org? Other?

http://www.phpfreaks.com/forums/index.php/topic,201206.0.html Xansa noted a smaller editor that might fit your needs.

Opera wins again!

Search the board for basic form submission... if you don't know ANYTHING about web development (and it seems you don't), then I'd start with some basic HTML stuff.

It's not the cost you should worry about... it's the experts.

Yeah, I think there is something screwed up in the AJAX that passes the info back and forth... I'll talk to the SMF guys about it.

Hmm... I didn't know you could do that.

Why are you dumping it out in a JavaScript tag? There are no actions in the JavaScript to call it. You can simply put those values right in the form elements if that is what you're trying to do. Other things you're doing wrong: 1) You're pulling the data out before you check to see if you have any results. That's backwards. 2) Replace: $fname=$row['fname']; $lname=$row['lname']; $age = $row['age']; with: extract($r);

What is in the field important? 1/0? We need a little more information.

Show us the code you're using ... you can set the domain in your cookies.

What is the data format on the field in the database?

try: echo '<td><center>'.date("h:i", strtotime($row['Time'])).'</center></td>';

Did you even read the link I suggested? It's one giant help file on how to use it. I'd forget using the PHP Charting options if you can use Google Charts.

Check out http://code.google.com/apis/chart/

Gahh... didn't notice that. The browser would not request the page twice... not on it's own.

PHP is not browser related. There is no way that the browser is affecting the submission of the entry. Either you're not showing us all the code or something else is screwing up. Why are you starting sessions if you're not using them (one reason why I think there is more code than this).

Be sure to post again if you get stuck.

My mistake... I thought he was ... *reads again* ...ahh nevermind.

On cnn, you can still navigate the site from the top.

Oh... well I wasn't clear on the intent. You can still get totals within one query. You should be able to use a combination of DISTINCT, COUNT and GROUP BY to get what you need. I'd suggest posting in the database boards to get that information.

From your query you posted it looks like all you need to query the DB for a user is their phone extension, right? If so, I'd create a text file with the following (just a list of extension numbers): 1234 1343 2345 Then: $exts = file('/home/user/phones.txt'); foreach ($exts as $num => $ext) { $query = "SELECT * FROM table WHERE ext = $ext"; // do whatever else needs to be done here } Or if you want to just do one query where you grab all of the records at once: $exts = file('/home/user/phones.txt'); $str .= "SELECT * FROM table WHERE ext IN (".implode(",",$exts.)")"; // do whatever else needs to be done here } Does that help?

Ick. The graphics are poorly done, the layout is weak at best, and there are some glaring annoyances all over it. 1) "X should not be null" is a bad way to phrase an error message on a social networking site (signup page). 2) The logo is uninspiring and doesn't match the background color of the header area. 3) You're using a mailto link for suggestions. Who still uses mailto links?? 4) I'm in the help section... but how do I get to anything else? The navigation is at the bottom... BAD IDEA. I'll stop there. Overall it's a 3/10.

For the users list, you could simply create a text file that you edit. Search the board on handling files or look at the manual under http://us.php.net/manual/en/function.file.php. That should get you started. Then you just feed the extension into the query as a variable in a loop. file() will split the contents of the file into an array already so you can just use foreach() or a while() loop to run through the array. As far as sorting by column, simply pass a variable to the query and use an "ORDER BY" clause (this works in any DB).

I'm not clear on what you're trying to do or the error that is happening. Can you clarify?