Re: Loops

Richard Lynch wrote:

Steve Marquez wrote:

Greetings. I am trying to display looped information from a MySQL database in a PHP file. Loop $name (witht a br />) then $description End of loop I would like to loop the multiple variables rather than put all the variables into a single variable with an array. I can not figure out how to do this. I have very little knowledge of PHP but am learning. Let me know if more information is needed.

//Untested code. $connection = @mysql_connect('localhost', 'USERNAME', 'PASSWORD') or trigger_error(@mysql_error() . " connecting to mysql", E_USER_ERROR); mysql_error() *never* returns warnings... so why are you prepending an @ ?

@mysql_select_db('DATABASENAME', $connection) or neither does mysql_select_db()

trigger_error(@mysql_error($connection) . " selecting database", E_USER_ERROR); $query = "select name, description from whatever order by name"; $people = @mysql_query($query, $connection) or nor does mysql_query()

trigger_error(@mysql_error($connection) . " $query", E_USER_ERROR); while (list($name, $description) = @mysql_fetch_row($people)){ nor does mysql_fetch_row, unless $people is not a mysql-resource, (thus being false,) which you already checked for.

echo "<P>$name<BR>\n$description</P>\n"; }

Not to be rude, but adding so many @s is usually considered bad practice, and makes debugging scripts a hell of a lot harder.