Skip to main content
Known Participant
February 17, 2010
Question

What Does This Message In Live View Mean?

  • February 17, 2010
  • 1 reply
  • 574 views

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.

This topic has been closed for replies.

1 reply

David_Powers
Inspiring
February 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.

Guild1812Author
Known Participant
February 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.

Guild1812Author
Known Participant
February 19, 2010

Started from scratch, got it to work.

Thank you.