still pulling out hair

Anon

below is what i have so far - now says unable to select database

all i want to do here is view my database from the website

have been at this all day - lots of good info and help from everyone - but just becoming more confused

<?php
mysql_connect(localhost,$username,$password);
@mysql_select_db($name of the database) or die( "Unable to select database");
mysql_query ("SELECT computersniagaraID, computersniagaraDate, computersniagaraCost, omputersniagaraText FROM computersniagara")
or die ("Invalid query");

mysql_close();
?>

Anon

@mysql_select_db($name of the database)

This "$name of the database" portion should be changed to either the name of your database in quotes (eg 'mydatabase'), or leave as $name, assuming you assigned the database name to $name already (eg $name='mydatabase').

The select looks syntactically fine assuming the database you are running it against has a table named 'computersniagara'.

Best.

Matthew Pirvul
eAccounts.NETwork

Anon

Oh, and I believe that you do not need the @ on the mysql_select_db() command....

Anon

Matthew

"name of database" was what i replaced the actual database name with before publically posting here - the actual name is simplysold_com - computersniagara is the name of the table -but when i bring it up on the website, i still get the message - cannot connect to database

jim_keller

putting @ before a function call supresses error messages generated by the function. You will want to leave it off for now to help you debug.

Have you considered that the PHP code is correct but that there is a problem with mysql itself? for example, are you sure mysqld is running?

-Jim Keller
http://www.centerfuse.net

Anon

I sure hope it is Jim, MySQL is supplied by my host - all is connected

Anon

Please do it as below..

$db=mysql_connect("localhost","$username","$password") or die("Could not connect to the DB");
mysql_select_db("your_databasename",$db) or die("Could not select to the DB");

$sql="SELECT computersniagaraID, computersniagaraDate, computersniagaraCost, omputersniagaraText FROM computersniagara";
$result=mysql_query($sql);

If again there is an error.. then please check your Databse's username or password..

Cheers
Tabish

[deleted]

Might aswell learn how to do it right:
http://www.hvt-automation.nl/yapf/faq.php?cmd=viewitem&itemid=12

Anon

Thank you all very much
Vincent - thankyou - that worked !!!

Mike