The "Freeola Customer Forum" forum, which includes Retro Game Reviews, has been archived and is now read-only. You cannot post here or create a new thread or review on this forum.
There you go Mod.
Just as you asked!
Anyway.
Does anyone know about MySQL and displaying the data in a table?
I've got a basic script to display it like this (http://www.phi11ip.com/mysql/display.php) but I want to be able to display it out of the rows and something like it shows at the bottom of the page...
Does anybody know how to do anything like this? If you can give me the general idea of what to do with a small example or a link to one I should be able to modify it and get it working...
Thanks.
Just as you asked!
Anyway.
Does anyone know about MySQL and displaying the data in a table?
I've got a basic script to display it like this (http://www.phi11ip.com/mysql/display.php) but I want to be able to display it out of the rows and something like it shows at the bottom of the page...
Does anybody know how to do anything like this? If you can give me the general idea of what to do with a small example or a link to one I should be able to modify it and get it working...
Thanks.
Page:
Sorry.
You can use the mysql_fetch_array to get the results in an array with the field names attached.
Example:
# DATABASE CONNECTION CODE HERE, which you should already have.
$results = mysql_query(SELECT * FROM TableName);
# Loop through each row of data.
while ($a_row = mysql_fetch_array($results)) {
print "$a_row[One_Field_name]\n";
print "$a_row[Another_Field_name]\n";
print "$a_row[One_More_Field_name]\n";
}
?>
You can use the mysql_fetch_array to get the results in an array with the field names attached.
Example:
# DATABASE CONNECTION CODE HERE, which you should already have.
$results = mysql_query(SELECT * FROM TableName);
# Loop through each row of data.
while ($a_row = mysql_fetch_array($results)) {
print "$a_row[One_Field_name]\n";
print "$a_row[Another_Field_name]\n";
print "$a_row[One_More_Field_name]\n";
}
?>
You can use the mysql_fetch_array to get the results in an array with the field names attached.
Example:
# DATABASE CONNECTION CODE HERE, which you should already have.
$results = mysql_query(SELECT * FROM TableName);
# Loop through each row of data.
while ($a_row = mysql_fetch_array($results)) {
}
?>
Example:
# DATABASE CONNECTION CODE HERE, which you should already have.
$results = mysql_query(SELECT * FROM TableName);
# Loop through each row of data.
while ($a_row = mysql_fetch_array($results)) {
}
?>
Can you put that code here, as I know what you want, but it isn't as fresh in my head as I'd like it to be.
I can change the database order no problem.
I just don't know how to tell certain fields where to be put...
I've only got a script that prints the whole line...
I just don't know how to tell certain fields where to be put...
I've only got a script that prints the whole line...
So, you mean in a different order than it is in the Database?
There you go Mod.
Just as you asked!
Anyway.
Does anyone know about MySQL and displaying the data in a table?
I've got a basic script to display it like this (http://www.phi11ip.com/mysql/display.php) but I want to be able to display it out of the rows and something like it shows at the bottom of the page...
Does anybody know how to do anything like this? If you can give me the general idea of what to do with a small example or a link to one I should be able to modify it and get it working...
Thanks.
Just as you asked!
Anyway.
Does anyone know about MySQL and displaying the data in a table?
I've got a basic script to display it like this (http://www.phi11ip.com/mysql/display.php) but I want to be able to display it out of the rows and something like it shows at the bottom of the page...
Does anybody know how to do anything like this? If you can give me the general idea of what to do with a small example or a link to one I should be able to modify it and get it working...
Thanks.
Page: