[SOLVED] making this bit vbulletin friendly php mysql

[nhawk]

Originally Posted by Dr.CustUmz

cant seem to get the else to function properly

Call to undefined function mysql_query()

First problem, mysql isn't set up properly in PHP. Most likely you have mysqli active, not mysql.

OR, you haven't opened a mysql connection to the database.

Originally Posted by Dr.CustUmz

  $hitquery =  $db->query_first( "select hits from redirect where url = '$drc_url'");
  $result = mysql_query($hitquery);
  $hits = mysql_result($result, 0,  "hits");
  $query2 =  $db->query_write( "update redirect set hits = hits+1 where url = '$drc_url'");

Second problem, you already have the result in $hitquery and you're trying to query that result in

$result = mysql_query($hitquery);

$hitquery is not a valid mysql query. It is the value of hits from the database.