Search results for query: *

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...

...FOREIGN KEY([user_id]) REFERENCES [user] ([guid]) I'm confused because I get this error when I try to insert into the user_group table. I'm *sure* the users exists in the user table: The INSERT statement conflicted with the FOREIGN KEY constraint "fkey$user_group$uguser". The conflict...

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-

...it! The function: function excel_output($table) { global $conn; echo $table; $file = "test.csv"; $temp_str = ""; $querystring = "SELECT * from " . $table ."\n"; $result_csv=mysqli_query($conn, $querystring); $fh=fopen($file,"w+") or die ("unable to open file"); //note that...

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...

...tried putting fulltext indexes on all those fields but had 2 problems. First was if I wrote the query to search more than 1 colum: select * from people where match(username, emplid) against ('drknow') I get the error '#1191 - Can't find FULLTEXT index matching the column list'. Also, I...

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) {...

...has been made, display info if ($_POST["sel_id"] == "") { header("Who is who_is.php"); exit; } //end if //get person info $query = "SELECT * from v_people_detail where username = '".$_POST["sel_id"]."'"; $get_person_rs = mysqli_query($conn, $query) or die(mysqli_error($conn))...

I think I know what's wrong here. The trigger doesn't know what I mean by the small_schools table. I needs someplace to hold the data from that table (cursor??) to check against, rather than checking against the small_schools table. What I'm trying to accomplish is change the prognum for...

Yup, that happens. I appreciate the response anyway. I didn't realized my error until I looked at the source in the browser. Once it worked I got brave enough to put it all on one line too. Looking at the source is an easy debugger, but I often forget to use it.

Doh, didn't close the mailto. All of the lines after the Principal were disguised as the mailto. $display_block .="<li>Principal: $name"; $display_block .="<a href='mailto:"; $display_block .=$user; $display_block .="@somewhere.com'>Email $name</a>";

...though! caveat: this is an intranet form that will never travel outside the department. Everyone has the same email client, so using a mailto *shouldn't* get me into any trouble. if (mysqli_num_rows($get_admin_rs) > 0) { while ($admin_info = mysqli_fetch_array($get_admin_rs)) {...