Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Script help

Status
Not open for further replies.

tekrh

Technical User
Joined
Nov 15, 2002
Messages
3
Location
US
I cannot seem to get some of the data to the links links table. The links vote data is updates but not the links links. Here is the script..

<?php
// File: $Id: wl-rating.php,v 1.18 2002/03/10 14:44:54 niceguyeddie Exp $ $Name: $
// ----------------------------------------------------------------------
// // ----------------------------------------------------------------------
// // ----------------------------------------------------------------------
// LICENSE
//
// This program is free software; you can redistribute it and/or
// modify it under the terms of the GNU General Public License (GPL)
// as published by the Free Software Foundation; either version 2
// of the License, or (at your option) any later version.
//
// This program is distributed in the hope that it will be useful,
// but WITHOUT ANY WARRANTY; without even the implied warranty of
// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
// GNU General Public License for more details.
//
// To read the license please visit // ----------------------------------------------------------------------
// Original Author of file: Francisco Burzi
// Purpose of file:
// ----------------------------------------------------------------------
// 11-30-2001:ahumphr - created file as part of modularistation

/**
* @usedby index
*/
function rateinfo($lid)
{
list($dbconn) = pnDBGetConn();
$pntable = pnDBGetTables();

$column = &$pntable['links_links_column'];
$dbconn->Execute(&quot;UPDATE $pntable[links_links]
SET $column[hits]=$column[hits]+1
WHERE $column[lid]=&quot;.pnVarPrepForStore($lid).&quot;&quot;);
$result = $dbconn->Execute(&quot;SELECT $column FROM $pntable...); } ?> I hope someone can help me thanks...
 
Is there anyone who can help me?
 
Here is the error I get if anyone here knows how to fix it!
Error adding data: You have an error in your SQL syntax near '= , nuke_links_links.pn_total'
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top