Maq

It's because "Weight" only exists in the ID_table, you better check everything else as well.

You can use the SUM() aggregate function.

If they are bots implement or create a CAPTCHA. But it seems like it is a human? Just store their username or IP in the database and make sure they only send either a certain amount or you could use sessions...

$result = myql_query Should be (missing the 's' in sql): $result = mysql_query -You need session_start(); at the top of your page, also add in error reporting and tell me if there is any output. session_start(); ini_set ("display_errors", "1"); error_reporting(E_ALL);

-Get rid of the ads, trust me, until your site drives in a lot of traffic, you're not going to make any money, so there's no point to bog down your site and make it uglier. -Try to keep everything in the main container (forums, store) with the same style. -Try to create a container to put your text in, right now it's running wild. -Use CSS to spice up your text -What else do you want me to say, there's really not that much there...

Cron jobs just call the script at a certain time, it would be the script itself timing out. Sure, assuming you're on a linux server, type in: ps -ef

Yeah just do a query to return some amount of rows with that user and if it returns rows don't let me insert... session_start(); $user = $_SESSION['user']; $result = myql_query("SELECT * FROM table WHERE user = '$user'") or die(mysql_error()); if(mysql_num_rows($result) > 0) { echo "sorry, you're already in the DB"; } else { echo "not in the DB, do whatever you want in this block"; } ?>

What os are you on? If you're on linux you can do something like: shell_exec("killall php");

Usually when people do that it makes the problem worse and confuses everybody, it irritates me when people do that.

Then you should read about the very basics before you go any further.

Of course it sends a blank email, you're using variables that don't have any values! You should use the POST method when dealing with forms... </pre> <form method="get"> should be: [code] And when you get the submission you have to retrieve these values with the method you stated in your form, POST. Where do these values come from? [code]$to,$subject,$message,$headers<

I think you're referring to variables from the URL? You have to use the get method: i.e.: // url = www.yoursite.com/best.php?id=M $id = $_GET['id']; echo $id; // this will echo "M" ?> Sorry didn't read through your code, but I hope this answers your question.

You have: where usedblocks.userid 1 And in your sample data you have: usedblocks table -- (id=1, userid=1, contentid=2) which won't return anything cause you don't have a userid from this table where it's not 1...

Yeah sorry, I saw this and thought it was available, didn't get to the download page :-\

You don't have a recipid in the users table... Not from what your table structure tells me. If you just want username use this: $result = mysql_query("SELECT u.userid FROM users u LEFT JOIN pmessages p ON u.userid = p.recipid WHERE p.recipid = '$userid'") or die(mysql_error()); if (mysql_num_rows($result) > 0) { echo $row['username'] } else { echo "No Messages!"; }

Yes, like TheFilmGod said, it takes time for the search engines to crawl and index your site again. I mean, there are probably billions of websites updated everyday.

I'm not sure what you should join on, maybe userid and recipid? But anyway, like I said, you have to use a join if you're using two different tables. Try: SELECT * FROM users u LEFT JOIN pmessages p ON u.userid = p.recipid WHERE p.recipid = '$userid';

Try to sudo it.

I don't even think 4,294,967,295 people have internet capabilites... This is a ridiculous statement, it's going to waste space, if you don't have to use it, then don't. There are better solutions than this but if you want to ignore out suggestions, then why are you asking for help?

You may have errors in your query, let's check that first. Add this to the end of your query and tell me if any errors are displayed: or die(mysql_error());

Exactly.

It's not !=

Try this and tell me if there is any errors: mysql_query("SELECT * FROM tab_table WHERE id IN (".$str.") ORDER BY id") or die(mysql_error());

Sure. Regex is your best bet hear cause if you tried to explode on ". " (dot space) there could be a team with that in their name. Please mark as [sOLVED] too, thx.

Are you trying to make fun of my mother?