[Regular Expression in vBulletin Version 4.0.1?]

preg_match([0-9]{7,10}$field2) can't work, because it is syntactically incorrect.

 

You can try preg_match('/^[0-9]{7,10}$/', $field2)

[Password Protection(Object orientation problem)]

die() simply prints strings... false is the empty string, there you have automatic type conversion.

 

If you are still asking what is the problem with the code, it is still the same, unless you changed that...

 

You do not keep information about the fact the person logged in across requests. So the person logs in on a post, on the next get the $session is created anew, without it being logged in. In other words, your "Session" is not doing the thing that is the essence of being a Session.

 

Consider that, and try to figure out how you are going to deal with it. Usually people use $_SESSION to hold an identifier and check whether the person requesting the page is logged in already. That's really pretty much your only option.

 

</incoherentMorningTalk>

[Password Protection(Object orientation problem)]

Is there still a problem you are looking for advice with? I ask because you did not ask a question in your last post.

[mySQL poor performance?]

Show the code that produces the error?

[Need a little help with a query]

Try:

 

SELECT songlist.artist, SUM(songlist.count_played) AS count_played
FROM
  radio.songlist
GROUP BY songlist.artist
ORDER BY
  SUM(songlist.count_played) DESC
LIMIT 10

[mysql query duplicate records]

The problem is not very likely in the SQL you've shown, but rather in the environment it lives in.

[Need a little help with a query]

You're welcome.

[Need a little help with a query]

Try:

SELECT songlist.artist, SUM(songlist.count_played)
FROM
  radio.songlist
GROUP BY songlist.artist
ORDER BY
  SUM(songlist.count_played) DESC
LIMIT 10

[Need a little help with a query]

SELECT player, SUM(goals) FROM match_stats WHERE player = 'dabaR';

 

Maybe you can modify that to your situation.

[Need Help to add this]

Are we adding the features to phpwares.com?

[File upload - a working example?]

Hi again,

 

echo "". $row['image_location'] . ""; seems unnecessarily chatty. Seems like echo $row['image_location']; would do the same.

 

I would rewrite

echo "<img src=".$row['image_location']." height=100 width=100 border=0>";

as

printf('<img src="%s" height="100" width="100" style="border: 0" />', $row['image_location']);

 

Because I think that is more solid HTML.

[File upload - a working example?]

Yes, it is as straightforward as that.

[File upload - a working example?]

I take it you are working on linux?

 

What is the name of the web server user? You can do ps aux to find out.

[File upload - a working example?]

There should not be a space between <? and php

[File upload - a working example?]

http://www.tizag.com/phpT/fileupload.php

[Password Protection(Object orientation problem)]

Hi,

 

The problem is that $session is created anew every time a page is loaded, and the fact that you actually logged in on last load is ignored.

[Password Protection(Object orientation problem)]

Hi there.

 

I don't see that process.php is actually part of the program. Can you point to the place where it is included?

[Help with mySql query]

Perfect, good job.

[Parse error: syntax error, unexpected T_ECHO]

 

<?php
while($post = mysql_fetch_array($result)) (
echo "<h1>" . $row['Post_Title'] . "</h1><br>";
echo "<h3>" . $row['Post_Author'] . "</h3><br>";
echo "<p>" . $row['Post_Content'] . "</p>";
)
?>

 

Should be while() { ... } not while () ( ... )

[Help with mySql query]

So how about something like SELECT TOP 1 * FROM table WHERE (for - against) > $voting_score OR ((for-against) = $voting_score and id > $current_id) ORDER BY (for - against) ASC, id ASC

 

Sorry about it being so pseudocody instead of specific. You'll have to translate to your exact code. That code is meant to have all interpolations of variables into the SQL string escaped using something like mysql_real_escape_string() as well.

[Connecting to MYSQL database]

Oh, and....

 

Get into the habit of starting all your scripts with

error_reporting(E_ALL);

[Connecting to MYSQL database]

$query = INSERT INTO Users(user, date_registered, password, email) VALUES ("eric", "12/12/12, test, eric@eric.com");

 

There are no quotes around the query string. You need:

$query = 'INSERT INTO Users(user, date_registered, password, email) VALUES ("eric", "12/12/12, test, eric@eric.com")';

[chines charater showing square in db]

What about the program that you are using that you see the squares? PHPMyAdmin? PHP? Command-line mysql? Something else?

[Help with mySql query]

Well, what, if a post has 5 up and 3 down, then the next post is on that has 5 up and 2 down, and previous is one that has 4 up and 3 down?

 

What if the posts have the same number of up and down votes?

[Help with mySql query]

What constitutes the next/previous content? Is it by date? Amount of votes?