[RESOLVED] DB Syntax Error?

[jkarr]

Hello All,

I am pulling my hair out on this one, and I'm sure it's a simple oversight, but I can't find my error.

My DB Structure:
Name: 15524Accounts
COLS: AccountID; Name; Number; OpeningBalance; Balance

My PHP:

$balanceget = mysql_query("select Balance from $idaccounts where Number='$account'") or die(mysql_error());
$balancerow = mysql_fetch_assoc($balanceget);
$balance1 = $balancerow['Balance'];

My Error:
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /mounted-storage/home78a/sub006/sc44255-QVBE/datamt.org/masterfiles/inc/invoice/sendinvoice.inc on line 364

Typically when I get this error, I have an issue with my Query, so that is where I have been focusing my attention.

Using Echo I have verified that $idaccounts = 15524Accounts and that $account = 7984. My error is the same if I change my select statement to:

$balanceget = mysql_query("select Balance from 15527Accounts where Number='7984'") or die(mysql_error());

Also if I do select * instead and change mysql_fetch_array to mysql_fetch_assoc.

Does anything jump out any anyone when looking at this?

I appreciate any help.

Thanks,
Johnie Karr

[NogDog]

I don't see how you could be getting that error from the supplied code, since it should be die()-ing if the query failed. Maybe you need to double-check your variable name spellings or something equally trivial (but deadly)?

[nemonoman]

I'm with you: i.e. Stumped. Just to let you know you're not alone. The Query should die with an error if there's a problem -- otherwise you should be able to fetch either a row or a null result...SOMETHING.

[jkarr]

Ok. NogDog and Nemonoman,

Thank you very much for you reply.

After looking at the two replies, I quickly went back to the drawing board, and triple checked all my variables....twice.

Then, I decided to use a mysql_query insert clause and see if it would insert my data.

It was, but all 0's. So, I went back to checking all variables, which were correct, and then I realized something....the code in question was nested inside an if/else statement.

if($account=="none"){
//Do Nothing
}
else {
the code in the original pose
}

I noticed that in my insert statement, my name column had the value of 'none'.

That's when it hit me...the problem is with my If Statement. I thought, I have been writing too much ASP and VBA latley, I'm not checking the If statement for None, I'm resetting my variable to none.

Well, in the end, what I finally found was that I was missing the brackets for my else statement....I have been writing too much ASP latley.

Haha! I'm sorry for the long post to a simple matter, but I'm sure you can find the humor in all this!!

Thanks again NogDog and Nemonoman for your reply!

Johnie Karr