Another INSERT problem

[R1der]

Ok i am trying to insert something into referals database but its not inserting the users ipaddress can anyone see a problem?

 

mysql_query("SELECT * FROM userdb WHERE `ipaddress` = '$refip' AND `id` = '$_GET[refer]'");
mysql_query("INSERT INTO referals (id, refer, referip, referedip, refered) VALUES ('', '$refer', '$refip', '$ip', '$username')") or die(mysql_error());

 

All insert right except 'referip'

 

Thanks

[simcoweb]

Please show us where/how you have those variables defined.

[R1der]

How do u mean?

[simcoweb]

These variables:

 

$refer '$refip $ip $username

 

have to have their values set somehow/somewhere. Show me how you set the values.

[R1der]

But like i said all the others insert fine so all you need to know is the refip one as that is the only one that dont insert.

 

correct?

 

mysql_query("SELECT * FROM userdb WHERE `ipaddress` = '$refip' AND `id` = '$_GET[refer]'");

[AndyB]

  Quote

... can anyone see a problem?

 

mysql_query("SELECT * FROM userdb WHERE `ipaddress` = '$refip' AND `id` = '$_GET[refer]'");
mysql_query("INSERT INTO referals (id, refer, referip, referedip, refered) VALUES ('', '$refer', '$refip', '$ip', '$username')") or die(mysql_error());

 

Yes. You never retrieve any values from anywhere.  You do execute a database query but you don't get the values returned by that query.

[R1der]

So how would i do that?

[simcoweb]

This segment:

 

WHERE `ipaddress` = '$refip'

 

Where/how is $refip set?

[R1der]

I thought it was set in that select query?

 

Sorry i am confused :S

[AndyB]

Time to take a look at any of the simple MySQL tutorials around (and on this site).  All a query does is return a resource.

[simcoweb]

Well, you're telling the query to select the one the 'ipaddress' that matches $refip so $refip needs to already have a value set for it. Usually that is done by something like a:

 

$refip = $_POST['refip'];

 

from a form, for example. Or, possibly something passed in the url like this:

 

$refip = $_GET['refip'];

 

Now, in your query, it will match the value of that $refip with the value in the 'ipaddress' field.

[R1der]

Basicly i want it to get the users ip address from the userdb where there 'id' is 'refer' then it will insert there ip address in the referals database being 'refid'

[simcoweb]

Ok, let's walk through that a step at a time:

 

get the user's ip address from the userdb

 

  Quote

mysql_query("SELECT ipaddress FROM userdb

 

where the 'id' is 'refer' then it will insert..blah blah

 

  Quote

WHERE `id` =  '$_GET[refer]'");

 

Now, all you need is to make sure you pass the 'refer' through the URL so the $_GET snags it.