Copy link to clipboard
Copied
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.
Copy link to clipboard
Copied
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.
Copy link to clipboard
Copied
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.
Copy link to clipboard
Copied
Started from scratch, got it to work.
Thank you.
Find more inspiration, events, and resources on the new Adobe Community
Explore Now