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 gkittelson 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
Nov 15, 2002
3
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