Jump to content

Archived

This topic is now archived and is closed to further replies.

ulenie

Help with a simple code

Recommended Posts

The current code is
$sql = 'INSERT INTO stats (subid,ref) VALUES (\''.$_POST['email'].'\',\''.$_REQUEST['ref'].'\')';

What i want to do is insert a "name" and "paid" column.  And I want to set name to 'Registration Bonus' and paid to '1.00'.  The table and everything is already created.  Someone help me please!

Share this post


Link to post
Share on other sites
first of all, I suggested you should revise the query for viewing friendly.  After all, you're human.
So what u wanted is along with inserting subid, ref, you'd like to insert name and paid with it.

here is the code:
[code]
$sql = "insert into stats (subid,ref,name,paid) values
    ('{$_POST['email']}',
    '{$_REQUEST['ref']}',
    'Registration Bonus',
    '1.00')";
[/code]

Share this post


Link to post
Share on other sites
[quote author=hvle link=topic=101323.msg400935#msg400935 date=1153446870]
first of all, I suggested you should revise the query for viewing friendly.  After all, you're human.
So what u wanted is along with inserting subid, ref, you'd like to insert name and paid with it.

here is the code:
[code]
$sql = "insert into stats (subid,ref,name,paid) values
    ('{$_POST['email']}',
    '{$_REQUEST['ref']}',
    'Registration Bonus',
    '1.00')";
[/code]
[/quote]

Sorry, I didn't write the code.  When I looked at it, i thought the same thing.  That's why i couldnt figure it out.  I tried to do similar to what you wrote but it gave me an error.  Let me try exatly what you wrote.  Thanks.

Share this post


Link to post
Share on other sites
If you received error, post the whole error message.

Share this post


Link to post
Share on other sites
[quote author=hvle link=topic=101323.msg400942#msg400942 date=1153448533]
If you received error, post the whole error message.
[/quote]

It worked perfectly and was very easy to understand.  Thanks much.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.