Viewing Thread:
"PHP & MySQL : The Revenge"

Righty ho folks, got another task for ye.

I want to call up, from a MySQL database, a list of games which have information in a certain field, and a URL for each from a database. For example

$gameName

However, a) I'm not sure of the MySQL query to use to get every game name and preview link when there's a preview URL there (the names and URL's should be extracted from the database only when theres a URL in the gamePreviewURL field) and also how to add the extra condition of a format from an 'ENUM' list (ie WHERE gameFormat = "Gamecube") and have it all working in harmony.

Secondly, b) when I have it all from the base, what would be the best way to extract and display the information.

Any help is greatly appreciated.

ph

I've tried both, and you can see the results at :

http://www.synae.com/query.php and
http://www.synae.com/query2.php.

Darn it :D

Any ideas on how to fix?

$result = mysql_query( "SELECT * FROM table ORDER BY name ASC;" )

or die("SELECT Error: ".mysql_error());

# Loop through each row of data.

print "\n";

print "\n";

print "\n";

while ($a_row = mysql_fetch_array($result)){

print "\n";

print "\n";



print "\n";
}

print "

\n"; print "NAME\n"; print "

\n"; if ($a_row[target] == '') { print "-"; } else print " $a_row[name]\n"; { print "

\n";

mysql_close($db);

?>

Not sure if it will work. It's probably wrong, but it will do...

$query = mysql_query("select * from games where gamePreviewURL and gameFormat = 'GameCube'");
while ($info = mysql_get_object($query)) {

echo "gamePreviewURL\"> $info->gameName ";

}

(Extra spaces because SR can't deal with magic_quotes_gpc)

I think I know what you're on about. You could probably do it with an if statement.

I'll have a quick go and post something tomorrow.

Righty ho folks, got another task for ye.

I want to call up, from a MySQL database, a list of games which have information in a certain field, and a URL for each from a database. For example

$gameName

However, a) I'm not sure of the MySQL query to use to get every game name and preview link when there's a preview URL there (the names and URL's should be extracted from the database only when theres a URL in the gamePreviewURL field) and also how to add the extra condition of a format from an 'ENUM' list (ie WHERE gameFormat = "Gamecube") and have it all working in harmony.

Secondly, b) when I have it all from the base, what would be the best way to extract and display the information.

Any help is greatly appreciated.

ph