Looking for some help...

**brian t** · 04-19-2004, 06:24 AM

I am getting this error when I am attempting to test access to database I created is mysql...

Parse error: parse error in /home/emeraldv/public_html/theroswellproject/mysql_up.php on line 8

the host may be wrong but the domain is as listed
the database is named "roswell"
the username is "roswell"
the password is altered to protect the clueless.

the test page looks like this...

html>
<head><title>Test MySQL</title></head>
<body>

<?php
$host="emeraldvisions.net"
$user="emeraldv_roswell"
$password="the password"

mysql_connect($host,$user,$password);
$sql="show status";
$result = mysql_query($sql);
if ($result == 0)
echo "<b>Error " . mysql_errno() . ": "
. mysql_error() . "</b>";
else
{
?>

<table border="1">
<tr><td><b>Variable_name</b></td><td><b>Value</b>
</td></tr>
<?php
for ($i = 0; $i < mysql_num_rows($result); $i++) {
echo "<TR>";
$row_array = mysql_fetch_row($result);
for ($j = 0; $j <mysql_num_fields($result); $j++)
{
echo "<TD>" . $row_array[$j] . "</td>";
}
echo "</tr>";
?>
</table>
<?php } ?>
</body></html

Any ideas what could be wrong?

**randyriegel** · 04-19-2004, 08:37 AM

You don't have semicolons after the lines setting $host, $user, and $password. Should be:

$host="emeraldvisions.net";
$user="emeraldv_roswell";
$password="the password";

**brian t** · 04-19-2004, 11:34 AM

Thanks, I discovered that afterward, it still didn't work so I eneded up starting over from scratch. I appreciate the response.

**randyriegel** · 04-19-2004, 11:52 AM

what is not working? Getting more errors?

I see another thing I'm not sure about. You have:

PHP Code:


$host="emeraldvisions.net";

I always use:

PHP Code:


$host="localhost";

Randy

**brian t** · 04-19-2004, 12:27 PM

cleared that up as well, my test was sucessful. Now comes the fun part the first attempt at actually useing the PHP/MySQL to create a table to push and pull data.

**jason** · 04-19-2004, 09:34 PM

95% of the time it is easier to use phpMyAdmin (in CPanel) to create your tables. Since you'll usually just create tables once it is far easier to use the GUI that phpMyAdmin offers to create them and then just write code to select/insert/update your data.

--Jason

LinkBack

Thread Tools

Display

Looking for some help...

Bookmarks

Bookmarks

Posting Permissions