Search results for query: *

I have a database with duplicate customer records. However the only fields that duplicate are the first and last name fields and the id of the user connected to them. Not their ids. I have created a table with the duplicates. The problem is I have no idea how to write the statement to delete...

My program uses the following for loops to search customer records. $search_customers are the records being searched for and $g_u is the result set from mySQL query. for ($i=0; $i<sizeof($g_u); $i++){ for ($x=0; $x<sizeof($search_customers); $x++){ if ($g_u[$i]['user_id'] ==...

I have a customer id in a customer table that I need to insert into the proper rows (update) of an activity table. The tables connect through a third table the person table. The following select statement seems to work... SELECT `customer`.`cust_id` FROM `f_agent`.`customer` LEFT JOIN...

I have a table with over 500k customers in it. When my program loads the select statement takes so long the user never gets fully logged in. Is this the right forum to post a select statement for possible advice? It is a mySQL database.

I have a php web application that begins with a simple username and password login page. The program has recently been placed on a new server and data migrated from an older mySQL database to the new application's database. Prior to migrating the data I was able to successfully log in on the new...

I am trying to use the following stored procedure. I get an error on or around my INSERT statement. CREATE PROCEDURE `f_agent`.`cust_prop` () BEGIN INSERT INTO `f_agent`.`customer__property` (`cust_prop_cust_id`, `cust_prop_prop_id`) SELECT `customer`.`cust_id` `cust_prop_cust_id`...

I am not sure this is the right forum. I am trying to use a stored procedure for mySql. CREATE PROCEDURE `f_agent`.`cust_prop` () BEGIN INSERT INTO `f_agent`.`customer__property` (`cust_prop_cust_id`, `cust_prop_prop_id`) SELECT `customer`.`cust_id` `cust_prop_cust_id`...

I have a page in my program with several links. One link creates a csv file based on the information on the page. I get a nice excel spreadsheet for opening or saving. However, once the user has chosen to export the csv and does so, the other links on the page ALL open up the csv. You're...

I have a php page that creates a popup pdf of mailing labels. Functionally it works. However in Firefox the window is so small it only shows the tools for adobe reader. If I save the pdf from here and open it my mailing labels appear perfectly. I cannot resize the tiny window though. In IE, the...

I have a function I call that works perfect on one page and returns the fatal error "Call to member function get_type() on a non object" on another page. I am calling this function within another and my class file is included just fine as other functions from that class work on this page. The...

I am new to php so forgive my greenness. I've also looked in the online php manual for basics on session variables. I am simply trying to set a variable called "newcust" to either tru or false. The page only recognizes this variable as true no matter where or when I change it. I am changing it...