Barand

Don't use code that was deprecated 10 years ago. http://php.net/manual/en/features.file-upload.php

Or maybe it's to do with your writing all values to the same array key instead of appending to the array as my code would

how are you storing the data?

try this link http://www.phpfreaks.com/tutorial/data-joins-unions

Use SQL JOINS http://forums.phpfreaks.com/page/tutorials/_/data-joins-unions

Normalize you data (for the third time). Don't just store spreadsheets in MySQL tables.

The methods you're calling would be a start

xxhK, Tips for future posts: 1. Give posts a descriptive title, not just "Please help me". These forums are used by people searching for similar problems. 2. Use lower case - don't shout. 3. Use the <> button or code tags around your code.

Store in an array while ....... { $mailarray[] = $row['email']; }

Does this help SELECT t.train_no, t.train_name FROM trains t INNER JOIN train_schedule AS s1 ON t.train_no = s1.train_no AND s1.stn_code = 'JU' INNER JOIN train_schedule AS s2 ON t.train_no = s2.train_no AND s2.stn_code = 'JP' WHERE s1.distance < s2.distance ORDER BY train_no LIMIT 0 , 30 If not, can you post a test dump of the two tables

Whey the second table? You could have put the userid as a column in the first table> try SELECT ROUND(SUM(incorrect/answered)/COUNT(*), 3) as result FROM ( SELECT qa.questionid, SUM(IF(qa.rightanswer <> qa.responsesummary, 1, 0)) as incorrect , COUNT(*) as answered FROM mdl_question_attempts qa INNER JOIN mdl_question_attempt_steps qas ON qa.id = qas.questionattemptid WHERE qas.userid = $user GROUP BY qa.questionid HAVING incorrect > 1 ) as totals OUTPUT: +----------+ | result | +----------+ | 0.583 | +----------+

It's a question of variable scope. Your $db_connect variable is no available inside the function, you need to pass it to the function as a an argument when you call the function. http://php.net/manual/en/language.variables.scope.php

How about WHERE (indentity_number = $x) OR (student_code = '$y')

Good thinking, I hadn't considered "00000000001230".

couple of ways $a = '00000000000123'; $n = intval($a); echo $n; // 123 $n = trim($a, '0'); echo $n; // 123

http://lmgtfy.com/?q=php+mysql+pagination+tutorial

do you have error reporting turned on?

You have a pair of {} missing in the final else statement

It would look like this $whereclause = ''; $where = array(); if(strlen($_POST['city'])>0){ $city = mysql_real_escape_string($_POST['city']); $where[] = "city = '$city'"; } if(strlen($_POST['country'])>0){ $country = mysql_real_escape_string($_POST['country']); $where[] = "country = '$country'"; } if(strlen($_POST['occurence'])>0){ $occurence = mysql_real_escape_string($_POST['occurence']); $where[] = "occurence = '$occurence'"; } if (count($where) > 0) { $whereclause = "WHERE " . join(' AND ', $where); } $sql = "SELECT * FROM social $whereclause";

For the benefit of the non-clairvoyant ones out here, what's your current code for creating the session variables?

I'm using windows and it certainly wouldn't have worked on mine. Were you using mysqli on the WAMP server?

The foreach didn't work because $result (as shown by the print_r() ) was not an array of row data, it was a mysqli result object

Give us more and we can give you more

I don't see any rows of data in there, do you? try while ($row = $result->fetch_assoc()) { echo "<option value=" . $row['SectionID'] . ">" . $row['SectionName'] . "</option>"; } I must confess to being puzzled about it working previously.

The while statement will loop until $x has a value of 6. Because of the post-increment it will then be incremented to 7 after the value test. The result will therefore be 7 is output