After a few days of server problems and password authentication errors, that seems to have ironed itself out, however I am still having problems connecting to my very basic mysql db.
PROBLEM
The problem is now is that it doesn't find the table for some reason "Error: Table 'sharper_allegiance.people' doesn't exist" which is odd.
Here is the code, it should be correct, so why can it not find the table? The table 'people' does exist in the database 'sharper_allegiance'. Am I supposed to enable something within the table to specify its available to access?
Its a very basic table, two columns, one called Darklings, the other Protectors... I have given very basic attributes and utf8 (not clear on what I should assign as the collation but that seems to work).
Here is the code
$con = mysql_connect("localhost:3306","name","password");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("sharper_allegiance", $con);
$result = mysql_query('SELECT * FROM `people` LIMIT 0, 30 ') or die ('Error: '.mysql_error ());
Database error from here, it is able to log into the database here, but now it says there is no table when there is...
:bowdown:
PROBLEM
The problem is now is that it doesn't find the table for some reason "Error: Table 'sharper_allegiance.people' doesn't exist" which is odd.
Here is the code, it should be correct, so why can it not find the table? The table 'people' does exist in the database 'sharper_allegiance'. Am I supposed to enable something within the table to specify its available to access?
Its a very basic table, two columns, one called Darklings, the other Protectors... I have given very basic attributes and utf8 (not clear on what I should assign as the collation but that seems to work).
Here is the code
$con = mysql_connect("localhost:3306","name","password");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("sharper_allegiance", $con);
$result = mysql_query('SELECT * FROM `people` LIMIT 0, 30 ') or die ('Error: '.mysql_error ());
Database error from here, it is able to log into the database here, but now it says there is no table when there is...
:bowdown: