Exit
  • Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
  • 한국 커뮤니티
0

What Does This Message In Live View Mean?

New Here ,
Feb 17, 2010 Feb 17, 2010

Everything looks fine in Design View, but when I go to Live View, I get this:

Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource

in /Library/WebServer/Documents/Clan/php/talk.php on line 70

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource

in /Library/WebServer/Documents/Clan/php/talk.php on line 73

This is the code from the lines in question, and some of the surrounding ones:


70 mysql_select_db($database_feedback_db, $feedback_db);

71 $query_GetFeedback = sprintf("SELECT * FROM feedback WHERE status = %s ORDER BY created_at DESC", GetSQLValueString($colname_GetFeedback, "text"));

72 $query_limit_GetFeedback = sprintf("%s LIMIT %d, %d", $query_GetFeedback, $startRow_GetFeedback, $maxRows_GetFeedback);

73 $GetFeedback = mysql_query($query_limit_GetFeedback, $feedback_db) or die(mysql_error());

74 $row_GetFeedback = mysql_fetch_assoc($GetFeedback);

Any idea what's going on?

Thank you.

TOPICS
Server side applications
576
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
LEGEND ,
Feb 17, 2010 Feb 17, 2010

Thread moved to Dreamweaver Application Development forum, which deals with PHP/MySQL issues.

Any idea what's going on? Yes. As the error message says, your link isn't a valid MySQL resource. In other words, it can't link to the database. Most likely reason: you have not defined your testing server correctly, or MySQL isn't running. See http://www.adobe.com/devnet/dreamweaver/articles/setting_up_php_05.html for details on how to define your PHP site in Dreamweaver.

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Feb 19, 2010 Feb 19, 2010

That's the tutorial I followed. Everything looks good as far as site definition goes, and MySQL was/is running.

Is there a way I can test the connection, as if I was setting it up for the first time? Would I be better of removing the Site Connections, and making a new connection to MySQL?

Thank you.

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Feb 19, 2010 Feb 19, 2010
LATEST

Started from scratch, got it to work.

Thank you.

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines