Search results for query: *

I have a query that is getting me ALL the records from two tables. For one application I have I only need the last 30 records. I tried Limit 30 but that only got me the first 30. The table is ever growing so I will never know the number of records in the tables until I run the query. Here's...

I have some log entries that have the date / time in epoch time. It is in a MySql db and I have a query to show everything I want. The problem is how do I change the epoch time to human time / date when the query is run? The query I am using is: $sql = "Select...

I am trying to update a table with info from another table and also set two fields with the same info for each field. The first field productid will need to be inserted into the producttaxrel table with the contents of the same field in the products table. Here's my query: Update...

I have a select and an update query that work perfectly if I manually enter the record numbers for cf_565, and id. The fields get updated as they should. as soon as I try to use the variables $cf_565 and $id it fails. I get no error messages. I would also like to use an IF statement to...

I want to change a field using two other fields. I have no problem getting the fields I want in a Select query but for some reason I have a mental block on how to do an update, since the information is in several tables. Here is the select Query that works: SELECT vtiger_quotes.quoteid...

I have several hundred files that are named in a way that will not work for the way I want to use them. We saved these files with filenames and now we want to change the names. For example the files were named with a 4 digit number. It was an account number for the customer that the file was...

I have several hundred files that are named in a way that will not work for the way I want to use them. We saved these files with filenames and now we want to change the names. For example the files were named with a 4 digit number. It was an account number for the customer that the file was...

I want to take a result of a Mysql query and insert that into a different table. I can get the result to echo on the screen but I can't seem to get it to work in the next query. Here's what I have: $sql1="SELECT Sum(vtiger_inventoryproductrel.extlistprice) FROM vtiger_inventoryproductrel Inner...

I have an existing customer that has decided to install Cisco SIP systems using Call manager at each location. Forgive my ignorance here I am a Mitel dealer. the Cisco systems are or will be installed in small used car offices. I think that 8 - 10 phones in each with a couple of pots lines at...

Can someone give me an example? I have an update query that uses two manual inputs from a PHP page. I put in the recordid and the multiplier and it changes pricing for all the products by the second amount. Ths issue is that I have 13 records (and it could grow) and it is getting tiresome to...

I have an update query that I want to use. Here's what I have so far: update vtiger_accountscf Set vtiger_accountscf.cf_700 = CONCAT('localhost/customstuff/statements/ex.php?accountid=',(accountid)) The accountid field is in the same table. The problem i am having is that the value of the...

I have a php script sending a single variable within the URL to the next page. it looks something like this ..///statementpdf.php?accountid=4103 If I create a PHP script statementpdf.php with echo $_get ['accountid'}; and run the first script I get the correct result on the page. When I...

How can I change my date format from 2008-11-10 to 11-10-2008 from within a MySql query? I also, need to format a number to two decimal places and add a comma for thousands in the same query. Don't need much do I? Here's the Query: $pdf->Table('SELECT vtiger_invoice.invoice_no...

Would someone please comment as to why this Update query freezes my Mysql server. As the subject says I don't do this enough to be very good at it. Update Vtiger_Backup.vtiger_products x, Vtiger_Backup.commsource z Set x.mfr_part_no = z.VendorPartNumber, x.manufacturer = z.Vendor...

I have two tables that have a relationship ie: common id number. I have a third table that has some information that I need to get into the other two tables. here's the setup Table 1 id number part number description Table 2 link id number prefix cost Table 3 part number prefix cost The...

I have a table with about 15000 entries. there are many of them that I want to delete. I need to be able to delete certain part numbers. All the part numbers would be in this format xxx.xxxx.1 Most of the other part numbers are in this format xxx.xxxx So I want to delete ALL the entries...

I have a perl script that I want to use in linux. I have no idea how to do this. Is there someone that can give a hand? Thanks

I have a simple form with one input. I have a $_get Method set up. When the user hits enter the browser refreshes and goes to my second page with the variable name added to the url. So far so good, to test it I made a small page to show That the make sure I could GET the variable, and that...

I have a customer who has a class a private network setup. I have been given static IP addresses of 10.1.1.50 - 75 / 255.255.255.0 for my phone systems to use. I was given a VPN connection using PPTP to program them offsite using port 4000. Over the summer they changed some things around...

I have two queries that I want to exclude certain records from the result. They are: $query2 = 'update vtiger_products set unit_price = unit_price * 1.30 where productname NOT LIKE "Trip Charge %" '; and $query="INSERT INTO vtiger_pricebookproductrel ( pricebookid ...