inserting one table date into another?

Codewalkers Forums Sponsor:

March 29th, 2004, 01:05 PM

treelo

Contributing User

Join Date: Apr 2007

Posts: 121

Time spent in forums: 28 m 39 sec
Reputation Power: 2

inserting one table date into another?

php Code:

Original - php Code
<?php $conn = mysql_connect('localhost', '', '') or die('Invalid query:' . mysql_error()); $results = mysql_query("SELECT * FROM predictions") or die(mysql_error()); $row = mysql_fetch_array($results); $winner = "INSERT into users SET points = '".$row['points']."' WHERE user_id = '".$row['user_id']."' "; $rs = mysql_query($winner, $conn) or die('Invalid query:' . mysql_error()); ?>

<?php
        $conn = mysql_connect('localhost', '', '')
        or die('Invalid query:' . mysql_error());
        
        $results = mysql_query("SELECT * FROM predictions") or die(mysql_error());
      
     $row = mysql_fetch_array($results);
      
         $winner = "INSERT into users SET points = '".$row['points']."' WHERE user_id = '".$row['user_id']."' ";
 
    $rs = mysql_query($winner, $conn)
        or die('Invalid query:' . mysql_error());
 ?>

im getting the following error with this code:

Invalid query:You have an error in your SQL syntax near 'WHERE user_id = 'treelo' ' at line 1

i have a user_id row in my users table and the name is registered, can anyone advise me why this is happening?

March 29th, 2004, 02:07 PM

nazly

Codewalkers Beginner (1000 - 1499 posts)

Join Date: Apr 2007

Location: Colombo,SriLanka

Posts: 1,325

Time spent in forums: 20 m 18 sec
Reputation Power: 3

RE: inserting one table date into another?

I think you are trying to update the records.. You can't use a WHERE clause to an INSERT statement.
To update a row use UPDATE statement..

php Code:

Original - php Code
$conn = mysql_connect('localhost', '', '') or die('Invalid query:' . mysql_error()); $results = mysql_query("SELECT * FROM predictions") or die(mysql_error()); $row = mysql_fetch_array($results); $winner = "UPDATE users SET points = '".$row['points']."' WHERE user_id = '".$row['user_id']."' "; $rs = mysql_query($winner, $conn) or die('Invalid query:' . mysql_error());

 
 $conn = mysql_connect('localhost', '', '')
        or die('Invalid query:' . mysql_error());
        
        $results = mysql_query("SELECT * FROM predictions") or die(mysql_error());
      
     $row = mysql_fetch_array($results);
      
         $winner = "UPDATE users SET points = '".$row['points']."' WHERE user_id = '".$row['user_id']."' ";
 
    $rs = mysql_query($winner, $conn)
        or die('Invalid query:' . mysql_error());

March 29th, 2004, 02:55 PM

treelo

Contributing User

Join Date: Apr 2007

Posts: 121

Time spent in forums: 28 m 39 sec
Reputation Power: 2

RE: inserting one table date into another?

the row doesnt have any data in it, so i need to INSERT the data mate

March 29th, 2004, 02:59 PM

nazly

Join Date: Apr 2007

Location: Colombo,SriLanka

Posts: 1,325

Time spent in forums: 20 m 18 sec
Reputation Power: 3

RE: inserting one table date into another?

If thats the case your syntax is wrong for INSERT..

php Code:

Original - php Code
$winner = "INSERT INTO users (points) VALUES ('".$row['points']."')";

 
$winner = "INSERT INTO users (points) VALUES ('".$row['points']."')";

March 29th, 2004, 03:12 PM

treelo

Contributing User

Join Date: Apr 2007

Posts: 121

Time spent in forums: 28 m 39 sec
Reputation Power: 2

RE: inserting one table date into another?

ive got it now

i did need to update it, and i also had the row names wrong

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread: