Posts by Saulo • 11 points
5 posts
-
1
votes1
answer46
viewsQ: How to query a column in the database and view filtered in 3 html columns?
good morning. I have a question that I have never come across before with php and mysql. I have the following example table in mysql: ITEM : DEP : QTD ============================= 1 : T01 : 1000 2…
-
0
votes2
answers48
viewsA: Error picking a select result
In this code, the return is based only on the first item in the list. What I need is that if on some line, the Remaining volume is greater than zero and less than Total volume, status be 'P'. And if…
-
0
votes2
answers48
viewsQ: Error picking a select result
Can someone help me with this code. Makes that mistake: Warning: mysql_fetch_array() expects Parameter 1 to be Resource, Boolean Given in /var/www/xxx/teste.php on line 14 Notice: Undefined…
-
0
votes2
answers57
viewsA: if with array listing
I’m doing it like this. I just don’t know how to salvage it. include "mysql.php"; $ped_venda_id = 13; $sql = mysql_query ("SELECT pvi.ped_venda_id, IF(pvi.volume_restante ==0, 'T',…
-
0
votes2
answers57
viewsQ: if with array listing
I’m getting beaten using arrays, I need to check values and make decisions depending on what I find in the list. id | volume_total | volume_entregue | volume_restante 1 15 10 5 2 10 10 0 My problem…