need help asap

amo

Hi,

i am trying to display the current records in my database table.

i have uploaded all of the frm files of my db to my host, and the code im using to run this query doesnt seem to work.

<?
$dbuser = "synergy1";
$dbserver = "database";
$dbpass = "synergy1";
$dbname = "synergy1";
//***** BEGIN LISTING THE CONTENTS OF account.frm******
//CONNECTION STRING
mysql_connect($dbserver, $dbuser, $dbpass)
or die ("UNABLE TO CONNECT TO DATABASE");
mysql_select_db($dbname)
or die ("UNABLE TO SELECT DATABASE");

$sql = "SELECT * FROM account.frm";
$result = mysql_query($sql);
if ($myrow = mysql_fetch_array($result)) {
do
{
$Account_Number=$myrow["Account_Number"];
$Employee_ID=$myrow["Employee_ID"];
$Account_Holder_Name=$myrow["Account_Holder_Name"];
$Sort_Code=$myrow["Sort_Code"];
$Bank_Building_Society_Name=$myrow["Bank_Building_Society_Name"];
$Branch_Address_Line_1=$myrow["Branch_Address_Line_1"];
echo " ACCOUNT_NUMBER: $Account_Number";
echo " EMPLOYEE_ID: $Employee_ID";
echo " ACCOUNT_HOLDER_NAME: $Account_Holder_Name";
echo " SORT_CODE: $Sort_Code";
echo " BANK_BUILDING_SOCIETY_NAME: $Bank_Building_Society_Name";
echo " BRANCH_ADDRESS_LINE_1: $Branch_Address_Line_1";

}
while ($myrow = mysql_fetch_array($result));
}
?>

however and error comes up that the

($myrow = mysql_fetch_array($result)) {
do

is incorrect?

is there anyone who has some advice or another script i can use to display the records?

Thanks

thorpe

asking questions with an asap, wont get you too far.... lucky im in a good mood :-P.

frm files / mysql doesnt work like that. you will need to export the db design and data into sql scripts and then run them against a mysql database.

are you using phpmyadmin? if so, there is an export feature in it somewhere.

amo

i have just uploaded the sql file produced by phpmyadmin when i selected to export.

I tried running the query again, but im still gettin the same error message

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/s/synergy.siteburg.com/WWW/display.php on line 15

any guidance?

Thanks

thorpe

have you also got phpmyadmin installed on your host? if so, you need to create the db, then run the sql script your local phpmyadmin made against this db.