Pls make this code

[Gauravraj]

Pls this code is for point transfer from publisher to advertise but this code unable to transfer correct this pls.

<?php
$getu = mysql_query("SELECT * FROM users WHERE user='$user'");
$getu1 = mysql_fetch_array($getu); 
$id = $getu1['id'];
$bal = $getu1['bal'];
$pnt = $getu1['point'];


$getu = mysql_query("SELECT * FROM comp WHERE id='$id'");
$getu1 = mysql_fetch_array($getu); 
$id = $getu1['id'];
$point = $getu1['point'];

$ua = mysql_query("UPDATE comp SET point=(point+$pnt) WHERE id='$id'");
            $up = mysql_query("UPDATE users SET points=(pnt-$point) WHERE id='$id'");
?> 
<div class='cons1'>
<form action='transfer.php' method='post'>
<b>Amount:</b><br/><input type='text' name='point' id='point' value='10'/><br/>
<div align='right'><input type='submit' name='Pub2Adv' id='Pub2Adv' value='Transfer'/></div>
</form></div>

[RTS]

u missing $ sign [ $point+$pnt , $pnt-$point]... is this typo ??

[mFreak]

u missing $ sign [ $point+$pnt , $pnt-$point]... is this typo ??

its not typo. Those are mysql table field names.

[timo]

u missing $ sign [ $point+$pnt , $pnt-$point]... is this typo ??

point=point+$pnt //

[mFreak]

Pls this code is for point transfer from publisher to advertise but this code unable to transfer correct this pls.

<?php
$getu = mysql_query("SELECT * FROM users WHERE user='$user'");
$getu1 = mysql_fetch_array($getu); 
$id = $getu1['id'];
$bal = $getu1['bal'];
$pnt = $getu1['point'];


$getu = mysql_query("SELECT * FROM comp WHERE id='$id'");
$getu1 = mysql_fetch_array($getu); 
$id = $getu1['id'];
$point = $getu1['point'];

$ua = mysql_query("UPDATE comp SET point=(point+$pnt) WHERE id='$id'");
            $up = mysql_query("UPDATE users SET points=(pnt-$point) WHERE id='$id'");
?> 
<div class='cons1'>
<form action='transfer.php' method='post'>
<b>Amount:</b><br/><input type='text' name='point' id='point' value='10'/><br/>
<div align='right'><input type='submit' name='Pub2Adv' id='Pub2Adv' value='Transfer'/></div>
</form></div>

could you post table structure for comp and users table,that second sql. Are you sure that that script dont show an error? It dont make sense. Where do you fetch post data?

[Gauravraj]

This is ad4earn sql file but in this sql there is no structure for points in comp maybe i have manually created in comp pls help.

-- Table structure for table `comp`
--

CREATE TABLE IF NOT EXISTS `comp` (
  `id` int(100) NOT NULL auto_increment,
  `title` varchar(50) NOT NULL,
  `uid` int(50) NOT NULL,
  `url` varchar(50) NOT NULL,
  `type` int(1) NOT NULL,
  `adult` int(1) NOT NULL default '0',
  `img` varchar(200) NOT NULL,
  `cat` text NOT NULL,
  `lang` tinytext NOT NULL,
  `intr1` tinytext NOT NULL,
  `intr2` tinytext NOT NULL,
  `intr3` tinytext NOT NULL,
  `intr4` tinytext NOT NULL,
  `intr5` tinytext NOT NULL,
  `st` int(1) NOT NULL default '0',
  `ckey` varchar(250) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

[Guest]

im confused do you just want points on the comp table?

-- Table structure for table `comp`
--

CREATE TABLE IF NOT EXISTS `comp` (
`id` int(100) NOT NULL auto_increment,
`title` varchar(50) NOT NULL,
`uid` int(50) NOT NULL,
`url` varchar(50) NOT NULL,
`type` int(1) NOT NULL,
`point` varchar(50) NOT NULL default '0',
`adult` int(1) NOT NULL default '0',
`img` varchar(200) NOT NULL,
`cat` text NOT NULL,
`lang` tinytext NOT NULL,
`intr1` tinytext NOT NULL,
`intr2` tinytext NOT NULL,
`intr3` tinytext NOT NULL,
`intr4` tinytext NOT NULL,
`intr5` tinytext NOT NULL,
`st` int(1) NOT NULL default '0',
`ckey` varchar(250) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

that should work

[Gauravraj]

im confused do you just want points on the comp table?

-- Table structure for table `comp`
--

CREATE TABLE IF NOT EXISTS `comp` (
`id` int(100) NOT NULL auto_increment,
`title` varchar(50) NOT NULL,
`uid` int(50) NOT NULL,
`url` varchar(50) NOT NULL,
`type` int(1) NOT NULL,
`point` varchar(50) NOT NULL default '0',
`adult` int(1) NOT NULL default '0',
`img` varchar(200) NOT NULL,
`cat` text NOT NULL,
`lang` tinytext NOT NULL,
`intr1` tinytext NOT NULL,
`intr2` tinytext NOT NULL,
`intr3` tinytext NOT NULL,
`intr4` tinytext NOT NULL,
`intr5` tinytext NOT NULL,
`st` int(1) NOT NULL default '0',
`ckey` varchar(250) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

that should work

Ya i make it points table but i want points transfer working.

[mFreak]

Pls this code is for point transfer from publisher to advertise but this code unable to transfer correct this pls.

<?php
$getu = mysql_query("SELECT * FROM users WHERE user='$user'");
$getu1 = mysql_fetch_array($getu); 
$id = $getu1['id'];
$bal = $getu1['bal'];
$pnt = $getu1['point'];


$getu = mysql_query("SELECT * FROM comp WHERE id='$id'");
$getu1 = mysql_fetch_array($getu); 
$id = $getu1['id'];
$point = $getu1['point'];

$ua = mysql_query("UPDATE comp SET point=(point+$pnt) WHERE id='$id'");
            $up = mysql_query("UPDATE users SET points=(pnt-$point) WHERE id='$id'");
?> 
<div class='cons1'>
<form action='transfer.php' method='post'>
<b>Amount:</b><br/><input type='text' name='point' id='point' value='10'/><br/>
<div align='right'><input type='submit' name='Pub2Adv' id='Pub2Adv' value='Transfer'/></div>
</form></div>

I was just reading ad4earns sql, and I dont see that 'pnt' column in users table. Maybe you were thinking about 'point'. Try changing that it should solve your problem.