TY for your response John. I edited my original post to show more of the code. My query seems to get nothing back. The $idscores is the exact value I want and like I said the data in the DB is there under the primary value that I'm trying to extract. Is there something wrong with the query structure with the $idscores variable?
It's an access denied error. This is for a Joomla site that I have made. I'm using my own code via a "JUMI" module. My problem seems to be when I had my own simple coded site I had an admin section that allowed a form to be populated with MySql DB content. You could select a date to add scores then it would direct you to another page (from the action of the form) Here you would enter the scores then the DB would be updated. I'm sure I have over killed the code doing this but it worked perfectly. With Joomla the form action call outs seem to be my problem. Is there a way for me to make one form the calls itself "PHP_SELF" that would have multiple levels of forms? For example:
if date selected do this;
if date selected and scores entered do this
else show form.
I hope I'm making sense. I know there is some Javascript that would help but I don't know any Javascript and would prefer to do it with PHP as I can usually make my way around the coding (if not eventually). I currently have one form (select a date to enter scores for) that calls another form (enter the scores for selected game date) that then calls another php file that updates the DB. Can it be put into one php file or should I not try this?
You are getting the access denied error because you have not provided the correct database details/credentials, and/or your user does not have permission to execute the query (likely the former).