add mysql_error() to your die string so you can report what the error
is.
Jason
"AMC" <[EMAIL PROTECTED]> wrote:
>
> Thanks,
>
> the script runs now, but I cannot open a connection. I know the user name,
> and password are correct. What could be the cause?
>
> <?php
>
>
>
> $user = "aclark";
>
> $host = "localhost";
>
> $password = "ajaxx";
>
> $database = "corrigent";
>
> $connection = mysql_connect($host, $user, $password) or die("can't open damn
> connection");
>
> $db = mysql_select_db($database, $connection) or die("can't open damn
> database");
>
> $query = "select * from customer";
>
> $result = mysql_query($query) or die ("couldn't execute query");
>
> while ($row = mysql_fetch_array($result))
>
> {
>
> extract($row);
>
> echo $company;
>
> }
>
> ?>
>
> "Matthew Sims" <[EMAIL PROTECTED]> wrote in message
> news:[EMAIL PROTECTED]
> > >
> > > I have a php page with the code below. The page doesn't show the record
> > > from
> > > the database when it runs and I'm not sure why. I'm not getting any
> error
> > > message, just a blank page. There is one record in the tabele I'm trying
> > > to
> > > query.
> > > I'm brand new to php so I'd really appreciate the help.
> > >
> > > <? php
> > >
> > >
> > >
> > > $user = "aclark";
> > >
> > > $host = "localhost";
> > >
> > > $password = "ajaxx";
> > >
> > > $database = "corrigent";
> > >
> > > $connection = mysql_connect($host, $user, $password)or die("can't open
> > > damn
> > > connection");
> > >
> > > $db = mysql_select_db($database, $connection) or die("can't open damn
> > > database");
> > >
> > > $query = "select * from customer";
> > >
> > > $result = mysql_query($query) or die ("couldn't execute query");
> > >
> > > while ($row = mysql_fetch_array($result));
> > >
> > > {
> > >
> > > extract($row);
> > >
> > > echo $company;
> > >
> > > }
> > >
> > > ?>
> > >
> >
> >
> > Your while statment has a ; at the end of it.
> >
> > while ($row = mysql_fetch_array($result)) {
> > echo $row["company"];
> > }
> >
> > --
> > --Matthew Sims
> > --<http://killermookie.org>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
