Posts by Robert • 63 points
14 posts
-
1
votes2
answers267
viewsQ: SQL helps to join 2 selects
I have 2 selects below, how can I join in only 1 select? I need to take everything that sold in a certain period (BETWEEN) by item only that at the same time I have to take what had stock of the…
-
0
votes1
answer246
viewsQ: Help to block a form field
I have a form where you place purchase orders when the user chooses the product it brings the price automatically, the problem is that the unit value field is free for changes and I need to block…
-
1
votes1
answer145
viewsQ: Not getting user level from Session
I am separating the menu according to the user’s level, but I can’t get the level of the Session. Regardless of the user level it only shows the Adm menu which is level 2 Where is the error? Another…
-
0
votes1
answer67
viewsQ: Where am I going wrong on this select?
I made the Select below only that it is not adding by the correct column, where I am missing? In my structure I have the field dtConcat and the field dtConcat2 (these dates are different one is for…
-
3
votes0
answers233
viewsQ: Help with ABC curve creation in Mysql
I set up a select to know how many products were sold in a given period and the sale value of those products. Only I need to mount an ABC curve with the result of this select. Could someone please…
-
0
votes1
answer288
viewsQ: Help with accents
Tó with a problem to solve problems and accents in PHP pages and need a light. To solve the field names problem I used Cód. below in my file funcoes.php and in all pages I put include…
-
0
votes1
answer374
viewsQ: Fill a field by selecting another field
I have an order form where the name of the customer is chosen and I would like from this selection to be filled in the discount field, this value is in the same table where the customer registration…
-
0
votes0
answers66
viewsQ: Problem when logging in
To create a log for my system to know that changed the information, except that the way I rode is giving Fatal error: Call to Undefined Function anti_injection() in: can someone help or give me some…
-
0
votes0
answers64
viewsQ: Different results between localhost and server
I have the query below that works well on localhost but when send to the server does not work What can it be? SELECT CONCAT( mes, '/ ', ano ) AS data, IFNULL( SUM( total ) , 0 ) AS Total FROM…
-
-1
votes2
answers2101
viewsQ: Checking if registration already exists in the database
I am using this function in my form but I have a problem. It is validating the field and is not included in the comic, but the message instead of saying that the client already exists is saying that…
-
0
votes1
answer45
viewsQ: I have an excel report, how do I extract by date?
I have an excel report that does a BD search and brings all the information. how do I put in the form in php the user inform the date and search in the BD only between those dates and mount excel?…
-
0
votes0
answers34
viewsQ: Error with mysql BD
I have an error in my comic that I can’t fix I already used the CHECK TABLE command with the EXTENDED function and it says that there are no errors in the tables. the problem is this: I made some…
-
0
votes0
answers44
viewsQ: foreach recording several times in the BD
Staff are making a product input form (NF mirror) that has the option to clone the lines to include more products. This form records in 2 tables 1st NF header and the 2nd saves the details where the…
-
1
votes1
answer130
viewsQ: Recording only the last line in the BD
I am making a form to enter products in stock (NF mirror) for this I am using a Cód in javascript to clone the lines. So far so good, the problem and the time to have register because it only…