PHP with mysql problem

Anon

Hi,

I am trying to master php/mysql. I am trying to setup mysql and php on my notebook computer with the intention of uploading a finished site to my web host where mysql will be running on an Apache server. I think I have mysql running... I can add records and then retrieve them using the command line in mysql. I have a short php file that to try it out with but I can't get it to work. Here is what I have...

Windows 2000 SP2

mysql Ver 10.4 Distrib 3.22.34, for Win95/Win98 (i586)

Connection id: 1
Current database: realestate
Current user: root@localhost
Server version 3.22.34-shareware-debug
Protocol version 10
Connection localhost via TCP/IP
TCP port 3306
Uptime: 44 min 15 sec

PHP V4?? I downloaded V4 I believe but how do I check that??

I get the following message when I try to run my page.
Parse error: parse error in c:\inetpub\wwwroot\gethomes.php on line 33

Is there a way to know if I'm getting connected to mysql through php?

Is there something wrong with my code.
database=realestate, table=homes.
Here is the code I'm using...

<body bgcolor="red">


Write this!

<?php

//Connect to server...
$dbcnx = mysql_connect(localhost, root, pwd);
if (!$dbcnx) {
echo( "Unable to connect to the database server at this time." );
exit();
}

//Select the database
mysql_select_db(REALESTATE);
if (!@mysql_select_db("realestate") ) {
echo("Unable to locate the database at this time.");
exit();
}
?>

Here are the homes:

<?php

//Select the records by field.

$result = mysql_query("SELECT location FROM HOMES");
if (!$result) {
echo("Error performing query: " mysql_error());
exit();
}

while ( $row = mysql_fetch_array($result) ) {
echo("" . $row["school"] . "");
}

</body>

Anon

Why don´t you just try a simple :

<?php
mysql_connect ($host, $user, $password);
$result = mysql_db_query ("database","select * from table");
while ($row = mysql_fetch_array ($result)) {
echo "$row[value1] \n";
}
mysql_free_result ($result);
?>
if it works, it´s not your connection, it´s your script.

and about line 33, try something like this:

$result = mysql_query("SELECT location FROM HOMES");
if (!$result) {
$error_type = mysql_error();
echo "Error performing query: $error_type";
exit();

I hanven´t tried any of it but I guess it should work...
If not, let me know.

Anon

Thank you very much for your response. Please forgive me but I'm new at this.

Where you say ($host, $user, $password) I substituted ("localhost", "root", "pwd").. is that correct? And where you have [value1] am I supposed to substitute the name of a column in my table?

Here is what I did...

I get this message:
Warning: Undefined index: location in c:\inetpub\wwwroot\testthis.php on line 7

Please advise?

Anon

Try $row["location"]. If this doesn't work, check whether you have a field called location in the mysql table (check for spelling of location)

Nilesh

qingping

all the most,give us your full code...
that we can find out the line ...

cb942

It works with LOCATION (case sensitive?).
Thank you all for the help! Now I can get started with a gazillion hours of learning, right???
Chuck