Mysql Database display

NetworkTown.Net · 08-30-2006, 03:18 PM

Hi

I have a database the database name is arcade and the table name is games

in this table i have:

Field

Name
Info
image
Swf
Width
Height
Plays

and so on... what i want to do is display the Name on my site how would i do this? what code do i use to display the info in the DB. i want it to select random ones from the DB

then i have the same Fields bit with a extra one called CatId now i want to be able to select which CatId to get the infos from.

Thank you.

Dan · 08-30-2006, 04:03 PM

http://us3.php.net/mysql

Tree · 08-30-2006, 06:51 PM

Modified example from Dan's link.

PHP Code:

  <?php

// Connecting, selecting database

$link = mysql_connect('mysql_host', 'mysql_user', 'mysql_password')

   or die('Could not connect: ' . mysql_error());

echo 'Connected successfully';

mysql_select_db('my_database') or die('Could not select database');

 
// Performing SQL query

$query = 'SELECT `Name` FROM `arcade`';

$result = mysql_query($query) or die('Query failed: ' . mysql_error());

 
// Printing results in HTML

echo "<table>\n";

while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {

   echo "\t<tr>\n";

   foreach ($line as $col_value) {

       echo "\t\t<td>$col_value</td>\n";

   }

   echo "\t</tr>\n";

}

echo "</table>\n";

 
// Free resultset

mysql_free_result($result);

 
// Closing connection

mysql_close($link);

?>

NetworkTown.Net · 08-31-2006, 01:50 AM

Thank you i got the hang of it now.

08-30-2006, 03:18 PM	#1 (permalink)
NetworkTown.Net Account Closed Join Date: Oct 2005 Location: United Kingdom Posts: 1,554 55.39 NP$ (Donate)	Mysql Database display Hi I have a database the database name is arcade and the table name is games in this table i have: Field Name Info image Swf Width Height Plays and so on... what i want to do is display the Name on my site how would i do this? what code do i use to display the info in the DB. i want it to select random ones from the DB then i have the same Fields bit with a extra one called CatId now i want to be able to select which CatId to get the infos from. Thank you.

08-30-2006, 06:51 PM	#3 (permalink)
Tree NamePros Regular Join Date: Feb 2006 Location: Atlanta, GA, USA Posts: 335 13.25 NP$ (Donate)	Modified example from Dan's link. PHP Code: <?php // Connecting, selecting database $link = mysql_connect('mysql_host', 'mysql_user', 'mysql_password') or die('Could not connect: ' . mysql_error()); echo 'Connected successfully'; mysql_select_db('my_database') or die('Could not select database'); // Performing SQL query $query = 'SELECT `Name` FROM `arcade`'; $result = mysql_query($query) or die('Query failed: ' . mysql_error()); // Printing results in HTML echo "<table>\n"; while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) { echo "\t<tr>\n"; foreach ($line as $col_value) { echo "\t\t<td>$col_value</td>\n"; } echo "\t</tr>\n"; } echo "</table>\n"; // Free resultset mysql_free_result($result); // Closing connection mysql_close($link); ?>

08-30-2006, 04:03 PM	#2 (permalink)
Dan Buy my domains. Join Date: Feb 2006 Posts: 2,801 56.00 NP$ (Donate)	http://us3.php.net/mysql

08-31-2006, 01:50 AM	#4 (permalink)
NetworkTown.Net Account Closed Join Date: Oct 2005 Location: United Kingdom Posts: 1,554 55.39 NP$ (Donate)	Thank you i got the hang of it now.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)