Converting script to read from mysql

[Anon]

The script below pulls info out of a file, but now I switched a mysql database, so I need the script below to be converted to pull the information out of a mysql database, can you please convert it to do that.

$file = fopen('http://www.stardefenders.f2s.com/test.dat','r');
$i = 0;

do {
$i++;
$userinfo[$i]["username"] = trim(fgets($file,4096));
$userinfo[$i]["password"] = trim(fgets($file,4096));
$userinfo[$i]["realname"] = trim(fgets($file,4096));
$userinfo[$i]["rankingnumber"] = trim(fgets($file,4096));
$userinfo[$i]["rank"] = trim(fgets($file,4096));
$userinfo[$i]["bnetrecordwins"] = trim(fgets($file,4096));
$userinfo[$i]["bnetrecordlosses"] = trim(fgets($file,4096));
$userinfo[$i]["bnetrecorddisconnects"] = trim(fgets($file,4096));
$userinfo[$i]["icq"] = trim(fgets($file,4096));
$userinfo[$i]["aolim"] = trim(fgets($file,4096));
$userinfo[$i]["emailaddr"] = trim(fgets($file,4096));
$userinfo[$i]["joinTimeStamp"] = trim(fgets($file,4096));
$userinfo[$i]["loginTimeStamp"] = trim(fgets($file,4096));
$userinfo[$i]["space"] = trim(fgets($file,4096));
} while (!feof($file));

fclose($file);

Thankyou!
-Jason

[atomdesign]

I'd love to help, but I don't know the structure of your MySQL table.

[Anon]

Hi, it looks like this:
+----------------------------------------+
|Username|Password|Realname|bwins|blosses|
+----------------------------------------+
|Jrottman|sdafasdd|Jason R.|43534|6587587|
|Mrottman|gfsgdfgf|Mark Ro.|56435|2354354|
|Brottman|dfhadfdf|Brian R.|54334|2345454|
|Drottman|fdfdgsdf|David R.|56546|2346435|
+----------------------------------------+

[Anon]

Oops, I forgot to add the other fields, but you can get the idea of what it looks like.

[edsko]

Unfortunately I never worked with MySQL (always PostgreSQL). However, the general solution should look something like this:
(actual names of the functions are probably different, see PHP manual, MySQL section):

$query = mysql_execute( "SELECT * FROM table_name")
or die("Could not execute SQL query");
for( $i = 0; $i < mysql_getrows( $query ); $i++ )
{
$username[$i]["username"] = mysql_result( $query, "username", $i );
$username[$i]["password"] = mysql_result( $query, "password", $i );
// and same thing for all the other fields
}

Something like that...

Edsko

[Anon]

Thankyou so much, you have no idea how long I have been looking for a script that works exactly like that. Thanx! 🙂

-Jason