get variable from mySQL

[robertaccettura]

What would be the proper (fastest way) to get a variable out of a mySQL database.

I want to get 'groupclass', a field in this database.

mysql_connect($this->server, $this->db_user, $this->db_pass);
			mysql_select_db($this->database);
			$query = mysql_query("select id from login where username = '$username' and password = '$password'");
			$result = mysql_num_rows($query);
			mysql_close();

Previously I was just confirming data..

[robertaccettura]

<BUMP>

🙂

[Krakken]

I don't see the problem with your method. To get 'groupclass' do "SELECT id, groupclass"