Can't seem to connect to mysql database and output results

[frustrated777]

I'm new to mysql but seem to understand it enough to do what simple stuff I need but I can't get even this basic script to echo what is in the one colum, one row table.
I am able to connect now it seems since I don't get any errors anymore in logs or browser.
Im trying to get this working first then I need to access it from another domain and write to it.
I only need a reference # that I can read and then add 1 to it. I tried to do it with a text file with fread and fwrite the way I used to but now I need to be able to write to it from other domains and can't figure it out to save my life.
I was told mysql database would work. Any help would be GREATLY appreciated. I should be able to figure most of it out myself when I get some basic functionality going.
Thanks.
-----------------------------------------------------------
PHP Version 4.3.9
phpMyAdmin 2.6.4-pl3
MySQL 4.1.20 running on localhost:3306 as counterlead2@localhost
-------------------------------------------------------------
SCRIPT:
<?

$mysql_server = 'localhost';
$mysql_user = "counterlead";
$mysql_pass = "fhujeduu";
$mysql_db = "leadsnumfile";

$ntable = 'ntable';
$column = 'number';

mysql_connect($mysql_server,$mysql_user,$mysql_pas s) or die("Unable toconnect1 to database");

mysql_select_db($mysql_db) or die("Unable toconnect2 to database");

$sql = 'SELECT * FROM `ntable` LIMIT 0, 30 ' or die(mysql_error);

echo "$sql";


?>

[amrhi]

I'm new to mysql but seem to understand it enough to do what simple stuff I need but I can't get even this basic script to echo what is in the one colum, one row table.
I am able to connect now it seems since I don't get any errors anymore in logs or browser.
Im trying to get this working first then I need to access it from another domain and write to it.
I only need a reference # that I can read and then add 1 to it. I tried to do it with a text file with fread and fwrite the way I used to but now I need to be able to write to it from other domains and can't figure it out to save my life.
I was told mysql database would work. Any help would be GREATLY appreciated. I should be able to figure most of it out myself when I get some basic functionality going.
Thanks.
-----------------------------------------------------------
PHP Version 4.3.9
phpMyAdmin 2.6.4-pl3
MySQL 4.1.20 running on localhost:3306 as counterlead2@localhost
-------------------------------------------------------------
SCRIPT:
<?

$mysql_server = 'localhost';
$mysql_user = "counterlead";
$mysql_pass = "fhujeduu";
$mysql_db = "leadsnumfile";

$ntable = 'ntable';
$column = 'number';

mysql_connect($mysql_server,$mysql_user,$mysql_pas s) or die("Unable toconnect1 to database");

mysql_select_db($mysql_db) or die("Unable toconnect2 to database");

$sql = 'SELECT * FROM `ntable` LIMIT 0, 30 ' or die(mysql_error);

echo "$sql";


?>

you should use
$sql1=mysql_query($sql);
to show your data you should use
while ($row=mysql_fetch_array($sql1)){
echo "$row";
}
You still must learn alo of about mysql script try to open
http://www.tizag.com

[frustrated777]

Thank you that helps but now my browser output is:
Array

My database seems to be connecting fine. I'm at a loss.

[frustrated777]

I changed the WHILE statement to:
echo $sql1;

and I get browser output:
Resource id #3

Still at a loss but plugging away.

[ronverdonk]

The fact that you freely exchange part of the shown sample (while statement) with an echo and don't have a clue as what a resource id is, makes me advise you to follow some basic tutorials on MySQL (and maybe PHP).

You cannot just learn databases and languages by trial and error or fiddling around. So here are some tutorials on the basics of MySQL:

http://www.w3schools.com/php/php_mys...L introduction
http://www.devshed.com/c/a/MySQL/Beg...ySQL-Tutorial/
http://www.freewebmasterhelp.com/tut...MySQL Tutorial
http://www.tizag.com/mysqlTutorial/
http://www.sitepoint.com/subcat/php-tutorials
http://www.php-mysql-tutorial.com/
http://bmw.ws.utk.edu/nsu/php/
http://www.developer.com/lang/php/article.php/3288671
Using MySQL from PHP part 1
Using MysQL from PHP part 2

Ronald :cool:

[frustrated777]

thank you for your reply. The resources you listed are very helpful.
I have to disagree about trial and error as a way to learn. I need to learn this fast and get something up running now. I'm not trying to create some complex database. I am just trying to create a one column, one row table i a single database that I can read AND write to from different domain. At this point I just need to get it to echo the single value to see that mysql is running correctly so I can move on to the next step. I added two more rows for a total of three just for experimental purposes and now get browser output:
ArrayArrayArray

The data in the table is:
22
33
55

Type=text MIME: text/plain

[frustrated777]

This the presesnt script:

<?

$mysql_server = 'localhost';
$mysql_user = "counterlead"; // Your Database Username eg: "you_you"
$mysql_pass = "fhujeduu"; // Your Database Password eg: "mypass"
$mysql_db = "leadsnumfile"; // Your Database Name eg: "you_you"

$ntable = 'ntable';
$column = 'number';

mysql_connect($mysql_server,$mysql_user,$mysql_pas s) or die("Unable toconnect1 to database");

mysql_select_db($mysql_db) or die("Unable toconnect2 to database");

$sql = ("SELECT * FROM ntable");
$sql1=mysql_query($sql);
while ($row=mysql_fetch_array($sql1)){
echo "$row";
}
?>

[frustrated777]

Finally got it all worked out. Thanks for your help.