Select From

[theWax]

hi everybody,

i have this table:

CREATE TABLE pollTabelle (
pollID INTEGER AUTO_INCREMENT PRIMARY KEY,
userID INTEGER DEFAULT 0,
Frage TEXT,
Antwort TEXT,
zeitpunkt TIMESTAMP(10)
);

now, i have problems with "userID".
i want to read it out of my table. add 1 to it and write it back. what is wrong with my attempt?

<?php
require('connect.php');
$getUserID = "SELECT userID FROM polltabelle LIMIT 1";
$result = mysql_query($getUserID);
$result++;
$exUmfrage = explode("&", $umfrage);
for($i=0;$i<count($exUmfrage)-1;$i++){
$temp = explode("=", $exUmfrage[$i]);
$temp[1]=utf8_decode($temp[1]);
$query="INSERT INTO polltabelle (userID,Frage,Antwort) VALUES ('$result', '$temp[0]', '$temp[1]')";
mysql_query($query);
}
?>

thank you for your help,

waxinger

[volleytotal_ch]

you can't use this code:

$result++;

because $result is a resource link to your database query. This means that it points to sort of virtual table where the results of your last query are saved.

but why do you want to increase userID? isn't this a foreign key to an user table?

[theWax]

no. it's not.

i am trying this one now. but it doesn't work either.
thanx for your help, anyway.

wax

<?php
require('connect.php');
//$getUserID = "SELECT max('userID') FROM polltabelle LIMIT 1";
//$result = mysql_query($getUserID);
//$temp=mysql_fetch_array($result);
//$userID_neu=($temp['userID']+1);
$exUmfrage = explode("&", $umfrage);
for($i=0;$i<count($exUmfrage)-1;$i++){
$temp = explode("=", $exUmfrage[$i]);
$temp[1]=utf8_decode($temp[1]);
$query="INSERT INTO polltabelle (Frage,Antwort) VALUES ('$temp[0]', '$temp[1]')";
mysql_query($query);
}
?>

[kevinsequeira]

<?php
  require('connect.php');
  $getUserID = "SELECT * FROM polltabelle";
  $result = mysql_query($getUserID);
		while($row=mysql_fetch_array($result)){ 
			$new_userID = $row['userID']+1;
    $query = "UPDATE polltabelle SET userID = '".$new_userID."' where pollID=".$row['pollID'];
    mysql_query($query);
		}
?> 

reg
kevin

[theWax]

thank you very much kevin.
i think i understand it now.
cheers from berlin.

wax

[kevinsequeira]

no problem, could u mark this thread resolved , there is a link below

reg
kevin