[SOLVED] troubling script

[sandrob57]

Edit2:  Where's the call to mysql_query()?  What I meant above is that you should check for errors from mysql_query()

It connects to the database fine. I'm logged in a CMS throughout this entire thing.

[btherl]

Not mysql_connect(), mysql_query().  It should be:

 

     $result_war = mysql_query("SELECT *
      FROM fusion_wars
      WHERE `a_id`='$user_id'
      AND `d_id`='$target_id'") or die("Query failed: " . mysql_error());

 

Or in your code you appear to use dbquery() instead of mysql_query().

 

Edit: Fixed ' => `

[sandrob57]

Not mysql_connect(), mysql_query().  It should be:

 

     $result_war = mysql_query("SELECT *
      FROM fusion_wars
      WHERE 'a_id'='$user_id'
      AND 'd_id'='$target_id'") or die("Query failed: " . mysql_error());

 

Or in your code you appear to use dbquery() instead of mysql_query().

Yeah I just noticed this. Fixed it. Refreshed this page. Saw your tip.

 

*sigh*....I'm full of pathetic mistakes today

 

edit: who is that in your avatar?

[btherl]

That's Matt Bellamy from Muse   The original avatar was animated.. it has him doing some weird thing with his hair.

 

I heard he was voted "sexiest man" by NME..

[sandrob57]

That's Matt Bellamy from Muse   The original avatar was animated.. it has him doing some weird thing with his hair.

 

I heard he was voted "sexiest man" by NME..

Looked like Jerry Cantrell