Recent content by monkle

I have been contacted by a non-profit organization that is having problems with organizing their volunteers to keep their employee schedule filled. I think that their best bet would be a web-based app where employees can hit a link and view slots currently taken, and be able to sign up for...

For anybody looking for information, here is a series of articles that have gotten me a good bit further along: http://www.databasejournal.com/features/mysql/article.php/10897_3525581_2 http://www.databasejournal.com/features/mysql/article.php/10897_3547931_2...

I am running MySQL 5.0.27 I need to know how to deal with result sets in pure SQL functions/stored procedures. I will explain: I am working on building a set of triggers for a relational database. Essentially, I have two sets of independent tables, and I want to keep them in sync. I have a...

r937: Thank you for your response. After I made the post, I got inspired to try passing the variable in, however I never got the user defined variable to set correctly. After fooling with it for some time I began to question the need for that set of data to be returned in this particular...

I have a 106 line query to draw in data from all over a relational database and dump into a single table for export. I am having issue with one section of the code, where I want to pull multiple rows (the first 5) into a delimited column for each row in the destination table. Here is the SQL...

Windows 2000 IIS 5 PHP 4.4.2 I am currently working on setting up a webserver which needs to be able to send out emails to users. I am looking for a class that will login to an SMTP server before it tries to send the mail, but the only stuff I can find is for Linux systems. If anyone can...

We are having issues with our site, and I have to put some logging into place to track variables. I have been beating my brains out on the issue all morning and every time I think I'm getting somewhere I hit a dead end with the solution, and it fails to take all considerations into account...

I am working on a project that utilizes a relational database. So far I have been opting for one larger query with multiple join clauses as opposed to multiple select queries. I had a co-worker raise question over my approach, so I am looking for some outside input. So far I have been unable...

Thank you, that works beautifully.

Thank you for such a verbose description of the answer "No, I don't know if this is common". I know very well that the most common use of the forums involves inspection of raw code rather than abstract conceptualization. Since a more detailed inspection is desired, I will post the query itself...

I have been working on writing a query all morning, and am into the debug phase. When I try to run the query, the sql server returns: "Operand should contain 1 column(s)". I have looked around, trying to find the flaw in the query and also trying to narrow down where the error might be. I...

The structure varies. I finally found something that helped, which led to the following user-defined function: protected function inArrayR($strVal, $arrHeap){ foreach ($arrHeap as $value) { if ($strVal == $value){ return true; } elseif (is_array($value)) { if...

PHP Version 5.1.2-1.dotdeb.2 I am doing something right now that requires that I check for the existence of a value in a multidimensional array. It doesn't matter at what level in the multidimensional array the value is found, I just need to know if it's anywhere in the array or not. I have...

As a solution, is there a way to detach or start a process so that it will continue running regardless of what happens in the browser? If it is possible to do this in such a way that multiple instances of the detached process can run without interfering with each other then it could be a valid...

I have a system that is currently live that is having issues with handling user interaction. To be more specific, towards the end of a series of pages displayed to the user I run a series of backend functions, including cURL sessions and database work. It is imperitive that the user not...