Kaboom

Use reCAPTCHA, it works really good for stopping them

I have no code as far as calling it yet because im not even sure how to begin and I don't want to skrew up and make it load none or all of them like i probably will. Here's my database setup though for jobs: CREATE TABLE IF NOT EXISTS `jobs` ( `id` int(10) unsigned NOT NULL auto_increment, `position` varbinary(45) NOT NULL, `company` varbinary(45) NOT NULL, `posted` varbinary(45) NOT NULL, `ends` varbinary(45) NOT NULL, `wage` varbinary(45) NOT NULL, `category` varbinary(45) NOT NULL, `desc` varbinary(200) NOT NULL, `reqs` varbinary(200) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2;

Say they want it to be posted for 30 days, how do I make it know what date that will be from now to put into the database and then when it IS that date, how do I make them now show anymore? :s I know exactly what I WANT to do, not sure how though.

The script i am making allows people to post jobs for people to see but I want to be able to set it so you can have it show for a certain period of time (like 1-30 days) or have no time limit on the post. What's a good way to do that? I will store the date to show it until in the database if possible and then when it calls them don't get the ones that are past that date etc, but not sure as to how and the php.net manual didn't help

I had another thread about a problem I was having where it's not loading from the DB right aways. My solution is to make an update function and then have the id's calling it on the page. So the thing I am wondering is how to make a working update function. I have this so far: <?php include blah.... $uid = $_SESSION["user"][0]; $avatarid = $_SESSION["user"][12]; function update($str) { global $db_id; $query="select ".$str." from users where id=".$uid; $result=mysql_query($query, $db_id); $row=mysql_fetch_row($result); return $row[0]; } ?> and then it's being called on the profile page with <?php echo update($avatarid); ?>. I want the update() function to select avatar from users where id = userid and then return the value fresh so it's getting it new from the database every time they refresh the page. Then there won't be a problem with updating old avatar stuff. Currently gives me the error: Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/root/public_html/func.php on line 69 So what am I doing wrong here? thanks for anyone who can help

Double: Okay so I made an update function, will this work? function update($updateid) { global $db_id; $query="SELECT count(*) FROM users WHERE ID=$updateid"; $result=mysql_query($query, $db_id); $row=mysql_fetch_row($result); return $row; } Then for the profile I have it calling like echo update($avatar); Will this work to fetch the row and return the right answers right away?

In the saving of the avatar it does currently update the SQL database with the info Now the problem there is that the data while being updates is only loading the data from the beginning of the session. Somehow I need the profile or accounts to always be updating/fetching the new data from the database.

I have a session to check when the users login and fetch the details from their account but when they edit their avatar I want it to update the value right away. For it to change the value for the user they need to log out and back in, destroying the original session and recreating a new one on that account. Is there a way to have it always getting the data I need from the database while they're logged in? Because I don't want it to only get the orignial data in case they change a setting so they don't have to log out and then back in to change the setting. I hope you understand