[REQUEST] Can you...

[ak-sorcerer]

Hi ya!! I have no experience in PHP what so ever... except for the PHPBB forum I have. Now, I would like to create a links page in my site where a person can submit their own link, and then it would appear in the link page. But that I would have some sort of control or rather admin page for it. If you cannot provide that control I'd appreaciate the small form. Thanks for your time. and worry not I will learn on the information that hopefully will be provided!! 😃 Thank you!

[TTT]

/// client action
$q = select max(id) as id from links
$new_id = odbc_result($q,1) +1;

insert into links (id,link) values ($new_id, '$userLink')

/// client action ends

<form action="action.php" method="post">
<?
$query = select id,link from links where moderated = 0;
while(odbc_fetch_row($query))
{
print "odbc_result($query,2)
//addThis[] allows to check more than one link at the same time
<input type='checkbox' name='addThis[]'
value='odbc_result($query,1)'>'';
}

?>
<input type="submit">
</form>

//action page
for($i=0;$i<count($addThis);$i++)
{
update links set moderated = 1 where id = $addThis[$i];
}

[ak-sorcerer]

Mmmmmmmmmm did I mention I'm new at PHP. haha..... TTT, or anyone else, please clarify what I should do to this code. Don't I need to create a table aswell, u know to store the links?? Well I'm using MySQL 3 on my server. So please an explanation would be much appreciated!! 😃 Thanks!

Thanks TTT, for helping me out in my lame request! 🙂

[ak-sorcerer]

Originally posted by TTT
/// client action
$q = select max(id) as id from links
$new_id = odbc_result($q,1) +1;

insert into links (id,link) values ($new_id, '$userLink')

/// client action ends

<form action="action.php" method="post">
<?
$query = select id,link from links where moderated = 0;
while(odbc_fetch_row($query))
{
print "odbc_result($query,2)
//addThis[] allows to check more than one link at the same time
<input type='checkbox' name='addThis[]'
value='odbc_result($query,1)'>'';
}

?>
<input type="submit">
</form>

//action page
for($i=0;$i<count($addThis);$i++)
{
update links set moderated = 1 where id = $addThis[$i];
} [/B]

I think the <? should go at the top. Also I see u use an 'action.php'. DO I need to create that, what code should I use!