so i've resorted to just creating a quote generator with php and mysql and i've been using the following code
<?php
$user="username";
$password="password";
$database="databasename";
$connection=mysql_connect('localhost',$user,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT quotes, FROM quots ORDER by rand() LIMIT 1";
$result=mysql_query($query) or die(mysql_error());
while ($row = mysql_fetch_array($result)) {
echo "<p>" , ($row['entry_title']) , "</p> \n <p>" , nl2br($row['entry_text']) , "</p>";
}
mysql_free_result($result);
mysql_close();
?>
obviously using my own password, username and database name and in the end i come up with this
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM quote ORDER by rand() LIMIT 1' at line 1
and i don't know how to go about fixing it.
any Ideas?