php - Error displaying Records in my table: It shows one record less -
I'm displaying records in the table from my database.
But if I have 6 records, my .php file shows me 5 ... this shows me a record: I'm looking like pages, but I still have an error ...
Any thoughts?
This is my code:
& lt ;? Php included 'conexion.php'; $ Contabla = Conexion (); $ Sqltabla = "Select from Sequisition P *, Products Pro where p.idproducto = pro.id"; $ Resutadotabla = mysql_query ($ sqltabla, $ contabla); $ Dato = mysql_fetch_array ($ resutadotabla); $ Contador = 0; While ($ dato = mysql_fetch_array ($ resutadotabla)) {$ contador ++; Echo "& lt; td & gt;" $ Contador "& Lt; / td>"; Echo "& lt; td & gt;" $ Dato ['id'] "& Lt; / td>"; Echo "& lt; td & gt;" $ Dato ['parte']. "& Lt; / td>"; Echo "& lt; td & gt;" $ Dato ['descripcion']. "& Lt; / td>"; Encoding "& lt; td & gt; Input size = '3' name = 'pcanitdad' id = 'idcantidad' value = '1' onchange = 'editarproducto (this.value)' & gt; & lt; / td & Gt; "; Echo "& lt; td & gt;" $ Dato ['pfinal']. "& Lt; / td>"; Echo "& lt; td> subtotal & lt; / td & gt;"; Echo "& lt; td> Discounted Applications & lt; / td & gt;"; Echo "& lt; td & gt; Total"; Echo "& lt; td & gt; select name = 'desc' id = 'desc' onchange = 'descuento (this.value)'> application & lt; / option & gt; & Lt; option & gt; 1 & lt; / option & gt; & lt; Option & gt; 2 & lt; / option & gt; Option & gt; Option & gt; 3 & lt; / options & gt; Lt; option & gt; 4 & lt; / option & gt; option & gt; 5 & lt; / option & gt; & lt; / select & gt; & lt; / td & gt; "; Echo & lt; Td> & Lt; A href = "abcs / eliminarprecotizacion.php? Id = '. $ Dato [' id ']." "Eliminer Products"> '; Echo' "& lt; / Tr & gt; ";}? & Gt;
Before leaving, Please delete this row:
$ dato = mysql_fetch_array ($ resutadotabla);
That row will be the first archive and then it will go to the loop, and the other
Comments
Post a Comment