Solucionario De William Lambe Es tambien posible obtener la solución a la pregunta actual de este sitio: Q: use SELECT to display only 2 columns (ID - Name) only from table in database I have a table in database with below structure ID | NAME to display the result in table, I used "; echo ""; while ($line = mysql_fetch_array($query, MYSQL_ASSOC)) { echo " ".$line['name'].""; echo " ".$line['id'].""; } echo ""; echo ""; ?> I am getting error message: Notice: Undefined offset: 1 in..... However, the expected result is show only the first two field to be displayed in table like this ID | Name ID7 | J.H. How do I fix this? Thanks for your answers A: while ($line = mysql_fetch_array($query, MYSQL_ASSOC)) { should be while ($line = mysql_fetch_array($query, MYSQL_ASSOC)) { other than that, you should wrap your table-related code in the while loop. Without it, mysql_fetch_array gives you undefined offset warnings about columns no longer in the array, even though your code is inside the while loop. Try: while ($line = mysql_fetch_array($query, MYSQL_ASSOC)) { echo ""; Online book Library. Buy books and ebooks for any device. Free book reader. Sllu,cionario De William Lambe PDFs · you earn if you refer. zip for slow or busy servers. f30f4ceada
Related links: