[Resolved] First php codes.. looking for some explanation

[sapoxgn]

Hi there, at first i would like to say that i m totally n00b at php ok? so take it easy with me...

I used to program clipper some ages ago so php isnt being so dificult but i like to understand everything.. i m not happy just seeing the program working 😃

So, i started making some codes using dreamweaver and some "stolen" codes 😃

first of all... the database

<?php require_once('Connections/php.php'); ?>
<?php
mysql_select_db($database_php, $php);
$query_jogos = "SELECT * FROM games ORDER BY nome ASC";
$jogos = mysql_query($query_jogos, $php) or die(mysql_error());
$row_jogos = mysql_fetch_assoc($jogos);
?>

this is ok, but i made i menu and got a little lost with that

    <?php
do {  

?>
    <option name="codigo" value="<?php echo $row_jogos['codigo']?>"><?php echo $row_jogos['nome']?></option>
    <?php
} while ($row_jogos = mysql_fetch_assoc($jogos));
  $rows = mysql_num_rows($jogos);
  if($rows > 0) {
      mysql_data_seek($jogos, 0);
	  $row_jogos = mysql_fetch_assoc($jogos);
  }
?>

but i got a little lost on this code

anybody could explain this code in a simple way?

😕

Thanx 😃

[devinemke]

<?php
// grab the mysql connection data from separate file
// this file presumably connects to the database
require_once('Connections/php.php');

// selected the database
// $database_php (the database name) and $php (the connection name) are presumably set in Connections/php.php
mysql_select_db($database_php, $php);

// create a string variable of the query which grabs everything from the "games" table sorting by "nome"
$query_jogos = 'SELECT * FROM games ORDER BY nome';

// run the query, spit out an error if it fails
$jogos = mysql_query($query_jogos, $php) or die(mysql_error());

// loop thru the results creating an array for each row
while ($row_jogos = mysql_fetch_assoc($jogos))
{
	// during each loop iteration, echo out an option for a select list
	echo '<option name="codigo" value="' . $row_jogos['codigo'] . '">' . $row_jogos['nome'] . '</option>';
}
?>

[sapoxgn]

thanx 😃

i wasnt understanding this stuff:

$row_jogos = mysql_fetch_assoc($jogos)

🙂