Connect question

2002-02-20 Thread Craig Westerman

Below is two scripts. The first one connects fine. The second gives the
following error.

Parse error: parse error in /usr/www/users/abc/connect.php on line 1

What is the problem with the second script? Thanks in advance - Craig

#1 - Works
---
HTML
HEAD
TITLE Our List of Jokes /TITLE
HEAD

BODY
?php
// Connect to the database server
$dbcnx = @mysql_connect(localhost, root, DWZ9bBXe);
if (!$dbcnx) {
echo( PUnable to connect to the . database server at this time./P );
exit();
}
// Select the jokes database
if (! @mysql_select_db(jokes) ) {
echo( PUnable to locate the joke . database at this time./P );
exit();
}
?
P Here are all the jokes in our database: /P
BLOCKQUOTE
?php

// Request the text of all the jokes
$result = mysql_query(SELECT JokeText FROM jokes);
if (!$result) {
echo(PError performing query:  . mysql_error() . /P);
exit();
}
// Display the text of each joke in a paragraph
while ( $row = mysql_fetch_array($result) ) {
echo(P . $row[JokeText] . /P);
}
?
/BLOCKQUOTE
/BODY
/HTML
---
---

#2 Errors
---
html
head
titleConnect to a MySQL Server/title
/head

body
?php

$dbcnx = @mysql_connect(localhost, root, DwZ9bBXe);

if ($dbcnx != FALSE)
{
 print The connection to the server was made successfully.;
}
else
{
 print The connection to the server failed.;
}

mysql_close($dbcnx);

?

/body
/html


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Connect question

2002-02-20 Thread Kevin Smith

The two passwords in the connections are different perhaps???
- Original Message -
From: Craig Westerman [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, February 20, 2002 3:24 PM
Subject: Connect question


 Below is two scripts. The first one connects fine. The second gives the
 following error.

 Parse error: parse error in /usr/www/users/abc/connect.php on line 1

 What is the problem with the second script? Thanks in advance - Craig

 #1 - Works
 ---
 HTML
 HEAD
 TITLE Our List of Jokes /TITLE
 HEAD

 BODY
 ?php
 // Connect to the database server
 $dbcnx = @mysql_connect(localhost, root, DWZ9bBXe);
 if (!$dbcnx) {
 echo( PUnable to connect to the . database server at this
time./P );
 exit();
 }
 // Select the jokes database
 if (! @mysql_select_db(jokes) ) {
 echo( PUnable to locate the joke . database at this time./P );
 exit();
 }
 ?
 P Here are all the jokes in our database: /P
 BLOCKQUOTE
 ?php

 // Request the text of all the jokes
 $result = mysql_query(SELECT JokeText FROM jokes);
 if (!$result) {
 echo(PError performing query:  . mysql_error() . /P);
 exit();
 }
 // Display the text of each joke in a paragraph
 while ( $row = mysql_fetch_array($result) ) {
 echo(P . $row[JokeText] . /P);
 }
 ?
 /BLOCKQUOTE
 /BODY
 /HTML
 ---
 ---

 #2 Errors
 ---
 html
 head
 titleConnect to a MySQL Server/title
 /head

 body
 ?php

 $dbcnx = @mysql_connect(localhost, root, DwZ9bBXe);

 if ($dbcnx != FALSE)
 {
  print The connection to the server was made successfully.;
 }
 else
 {
  print The connection to the server failed.;
 }

 mysql_close($dbcnx);

 ?

 /body
 /html


 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)

 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail
[EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php






-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Connect question

2002-02-20 Thread Kevin Smith

Why bother with the line :
if ($dbcnx != FALSE)

When you could use :
if (!$dbcnz) . ?

- Original Message -
From: Craig Westerman [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, February 20, 2002 3:24 PM
Subject: Connect question


 Below is two scripts. The first one connects fine. The second gives the
 following error.

 Parse error: parse error in /usr/www/users/abc/connect.php on line 1

 What is the problem with the second script? Thanks in advance - Craig

 #1 - Works
 ---
 HTML
 HEAD
 TITLE Our List of Jokes /TITLE
 HEAD

 BODY
 ?php
 // Connect to the database server
 $dbcnx = @mysql_connect(localhost, root, DWZ9bBXe);
 if (!$dbcnx) {
 echo( PUnable to connect to the . database server at this
time./P );
 exit();
 }
 // Select the jokes database
 if (! @mysql_select_db(jokes) ) {
 echo( PUnable to locate the joke . database at this time./P );
 exit();
 }
 ?
 P Here are all the jokes in our database: /P
 BLOCKQUOTE
 ?php

 // Request the text of all the jokes
 $result = mysql_query(SELECT JokeText FROM jokes);
 if (!$result) {
 echo(PError performing query:  . mysql_error() . /P);
 exit();
 }
 // Display the text of each joke in a paragraph
 while ( $row = mysql_fetch_array($result) ) {
 echo(P . $row[JokeText] . /P);
 }
 ?
 /BLOCKQUOTE
 /BODY
 /HTML
 ---
 ---

 #2 Errors
 ---
 html
 head
 titleConnect to a MySQL Server/title
 /head

 body
 ?php

 $dbcnx = @mysql_connect(localhost, root, DwZ9bBXe);

 if ($dbcnx != FALSE)
 {
  print The connection to the server was made successfully.;
 }
 else
 {
  print The connection to the server failed.;
 }

 mysql_close($dbcnx);

 ?

 /body
 /html


 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)

 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail
[EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php






-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php