Recent content by StuartBombay

Ran this against the database, no results so there are not any user guids in the insert table that are not in the user table. SELECT NewUserGroups.UserGUID FROM NewUserGroups LEFT JOIN user ON NewUserGroups.UserGUID = user.guid WHERE user.tps_guid) Is Null The data for the insert table...

I'm not sure what this is doing, but I'm guessing that it is checking the user table to make sure the ID (guid) exists in the user table before adding it to the user_group table? This constraint exists on the user table: ALTER TABLE [user_group] WITH CHECK ADD CONSTRAINT...

COM is a good thought, and I may go that way. Oddly, in at attempt to see if I could get a more descriptive error with the php function on the linux server, I commented out "or die" on the file open command. I now get the Open dialog and can open an instance of Excel, however nothing is written...

I was expecting it to open excel locally, not attempt to open it on the server.

Sadly, when I move from localhost to the linux box it cannot open excel.

Doh!, of course! I never thought of 'exit()'. I also had to move the header into !POST part of the if statement. I have about 5 blank rows at the beginning of the spreadsheet, I don't have empty records in my results... so I'll have to hunt that one down. Thanks again-

I used code authored by jpadie that I found on this forum, but I can't find the thread again. I took his code and made a function, and created a page to send a request to the function. It works, accept the spreadsheet that opens also has the HTML header and footer in it. All I want are the...

Doh! 'Go' to add columns! (head slap)

Yes, that does make sense. Thank you. I thought I had read that, but I couldn't see how to make MySqlAdmin combine columns in an index using it's interface. So, I could remove those fulltext indexes and use the SQL window to do something like - update people set... FULLTEXT KEY PLPSEARCH...

I used to have the same questions. Then one day I was called upon to create a small app in access. It was a text-book type app that kept track of donations (orders), with forms for entering and reports to notify it's time to ask for more donations. My point is, after 4 re-writes I had a...

I thought fulltext sounded like the way to go at first, but now I think it's not the best option when searching for proper names. I want to be able to search against first, last, email username or employee number. Ideally it could find based on part of a name or employee number.I tried putting...

Ah! Thanks vacunita and southbeach! mysqli_num_rows($get_name_rs) returns exactly what's needed.

I can't figure out why the array count shows 1. If I copy the resulting SQL into the MySQL database I get 2 rows of results, but php is returning a count of 1. More puzzling is the while loop returns 2 names. I'm obviously not understanding something here! $get_name_sql = "SELECT fullname...

Thank you - I had a feeling it had something to do with placement.

Thanks vacunita, $display_block is initialized on line 8. <?php $page_title = 'PPS Site Summary - Employee Information'; include('header.html'); include('functions/form_functions.inc'); require('../../includes/configdb.inc'); require('../../includes/opendb.inc'); global $conn; if (!$_POST) {...