Quick Question

@welshJan 13.2006

hey, ive got a database of games and i want the list of the names to be displayed and im pretty sure i can do that from the database. But would someone be able to point me at some tutorial to like add <a href=”game?id=$name”>$name</a> to do something like that for each name. maybe something to do with loops like display all data from the database with such and such. makes sense?

to post a comment

PHP

@NogDogJan 13.2006 — #If using MySQL, this page shows a basic example of the process to query the database and display the values returned from each row returned by the query.

http://www.php.net/manual/en/function.mysql-fetch-assoc.php

@welshauthorJan 13.2006 — #so its saying use this

[code=php]
 <?php
 
 $conn = mysql_connect("localhost", "mysql_user", "mysql_password");
 
 if (!$conn) {
 echo "Unable to connect to DB: " . mysql_error();
 exit;
 }
 
 if (!mysql_select_db("mydbname")) {
 echo "Unable to select mydbname: " . mysql_error();
 exit;
 }
 
 $sql = "SELECT id as userid, fullname, userstatus 
 FROM  sometable
 WHERE  userstatus = 1";
 
 $result = mysql_query($sql);
 
 if (!$result) {
 echo "Could not successfully run query ($sql) from DB: " . mysql_error();
 exit;
 }
 
 if (mysql_num_rows($result) == 0) {
 echo "No rows found, nothing to print so am exiting";
 exit;
 }
 
 // While a row of data exists, put that row in $row as an associative array
 // Note: If you're expecting just one row, no need to use a loop
 // Note: If you put extract($row); inside the following loop, you'll
 //      then create $userid, $fullname, and $userstatus
 while ($row = mysql_fetch_assoc($result)) {
 echo $row["userid"];
 echo $row["fullname"];
 echo $row["userstatus"];
 }
 
 mysql_free_result($result);
 
 ?> 
 [/code]

the main part i get is:

[code=php]while ($row = mysql_fetch_assoc($result)) {
 echo $row["userid"];
 echo $row["fullname"];
 echo $row["userstatus"];
 }
 
 mysql_free_result($result);[/code]

so how would i add the loop for just variable. i get i can add my href stuff after the echo.

@NogDogJan 13.2006 — #

[code=php]
 $query = "SELECT game_name FROM games ORDER BY game_name";
 $result = mysql_query($query) or die(mysql_error());
 if(mysql_num_rows($result) > 0)
 {
 echo "<ul>n";
 while($row = mysql_fetch_assoc($result))
 {
 $url = urlencode($row['game_name']);
 $name = $row['game_name'];
 echo "<li><a href='game?id=$url'>$name</a></li>n";
 }
 echo "</ul>n";
 }
 [/code]

@welshauthorJan 13.2006 — #thanks man, that works amazingly!

Quick Question

4 Comments(s) _↴

Also in #PHP _↴

Success!

Social

Version

Quick Question

4 Comments(s) ↴

Also in #PHP ↴

Success!

The web is an endless sea of information. Don't miss the boat... Subscribe!

Social

Version

4 Comments(s) _↴

Also in #PHP _↴