hi
the
/home/lark/public_html/connection.php on line 23
just refers to the file within the context of the whole file system and is
fine
the rest says that mysql cannot/does not execute the query so there is no
result to use.
the @ suppresses error messages so it may be best to remove it
try
mysql_connect ("localhost" , "USERNAME" , "PASSWORD");
or die(mysql_error());
mysql_select_db ("DATABASE");
or die(mysql_error());
which may tell you more - I suspect a permissions problem if it works on a
local server
If you are switching from a Windows machine to Linux remember to watch for
case sensitivity problems.
HTH
Peter
> -----Original Message-----
> From: David Blomstrom [mailto:[EMAIL PROTECTED]
> Sent: 27 June 2004 20:49
> To: [EMAIL PROTECTED]
> Subject: Database Connection Questions
>
>
> I'm previewing local pages with a database connection
> that looks something like this:
>
> @mysql_connect ("localhost" , "USERNAME" ,
> "PASSWORD");
> @mysql_select_db ("DATABASE");
>
> I modified it for an online site and published it
> online. But when I preview a page, I get error
> messages like the following:
>
> Warning: mysql_fetch_array(): supplied argument is not
> a valid MySQL result resource in
> /home/lark/public_html/connection.php on line 23
>
> Warning: mysql_fetch_assoc(): supplied argument is not
> a valid MySQL result resource in
> /home/lark/public_html/connection.php on line 41
>
> Warning: mysql_fetch_assoc(): supplied argument is not
> a valid MySQL result resource in
> /home/lark/public_html/connection.php on line 45
>
> Do those URL's look odd - like they're OUTSIDE of my
> website (/public_html/)?
>
> And I get this error at the bottom of the page:
>
> "Invalid query: No database selected"
>
> So I published my database to a different website and
> tried to make a remote connection. I was told that all
> I have to do is replace "localhost" with a URL, so my
> new query looks like this:
>
> @mysql_connect ("www.othersite.org" , "USERNAME" ,
> "PASSWORD");
> @mysql_select_db ("DATABASE");
>
> But I get the same results. I'm not even sure where to
> begin troubleshooting, because I'm not certain what
> the root of the problem is.
>
> Any suggestions?
>
> Thanks.
>
>
>
> __________________________________
> Do you Yahoo!?
> Yahoo! Mail - 50x more storage than other providers!
> http://promotions.yahoo.com/new_mail
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
