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_select_db('DATABASENAME', $connection) or
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
trigger_error(@mysql_error($connection) . " $query", E_USER_ERROR);
while (list($name, $description) = @mysql_fetch_row($people)){
echo "<P>$name<BR>\n$description</P>\n";
}
--
Like Music?
http://l-i-e.com/artists.htm
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
