[Php Mysql Select Var From Select Form]

Now we all know this sort of query to get some simple from the Database:

 

includeconnect.php;

query = "SELECT FROM table WHERE name = Apache";

result = mysql_queryquery;

 

whilerow = mysql_fetch_assocresult

echo rowname;

 

NOw this is a great way, but imagin you had 20 pieces of data, and dont want to write row every time. Well here the solution

 

includeconnect.php;

query = "SELECT FROM table WHERE name = Apache";

result = mysql_queryquery;

 

whilerow = mysql_fetch_assocresult

extractrow;

echo name;

 

This simple line of code pulls the row out of the variablkes, so now you can call on them using the name of the mysql row, without that nasty row