Barand

Oops! You're right. I was trying to avoid running queries in loops. if the table is this: CREATE TABLE `players` ( `player_id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(45) DEFAULT NULL, `team` int(11) DEFAULT NULL, PRIMARY KEY (`player_id`) ) then when running your first query mysql> SELECT * FROM players; +-----------+------+------+ | player_id | name | team | +-----------+------+------+ | 1 | A | NULL | | 2 | B | NULL | | 3 | C | NULL | | 4 | D | NULL | | 5 | E | NULL | | 6 | F | NULL | | 7 | G | NULL | | 8 | H | NULL | | 9 | I | NULL | | 10 | J | NULL | | 11 | K | NULL | +-----------+------+------+ 11 rows in set (0.00 sec) mysql> UPDATE players SET team = RAND(); Query OK, 11 rows affected (0.00 sec) Rows matched: 11 Changed: 11 Warnings: 0 mysql> SELECT * FROM players; +-----------+------+------+ | player_id | name | team | +-----------+------+------+ | 1 | A | 0 | | 2 | B | 0 | | 3 | C | 1 | | 4 | D | 1 | | 5 | E | 0 | | 6 | F | 1 | | 7 | G | 1 | | 8 | H | 1 | | 9 | I | 1 | | 10 | J | 1 | | 11 | K | 0 | +-----------+------+------+ 11 rows in set (0.00 sec) So running the rest of your code updates the zeros to ones, putting everyone in team 1. See you back at the drawing board

What version of MySQL? https://blogs.oracle.com/MySqlOnWindows/entry/milliseconds_value_support_on_datetime

I do not see session_start() on either page. It needs to be called at the top of every page that uses session variables.

try $db = new mysqli(HOST,USERNAME,PASSWORD,'test'); $res = $db->query("SELECT COUNT(DISTINCT name) FROM toastie"); list($count) = $res->fetch_row(); $N = ceil($count/5); $db->query("UPDATE toastie SET groupnumber = FLOOR(1 + RAND() * $N)"); Gives

The only thing that gets executed in your while loop is the bit between while(..) and the ";" at the end of that line. In other words - nothing. try while( $row = sqlsrv_fetch_array( $result, SQLSRV_FETCH_NUMERIC) ) { $encodedarray = array_map(utf8_encode, $row); echo json_encode($encodedarray); }

A couple of other things Dont use SELECT * You only select 1 record, so don't need while loop Your update should use the primary key to select the record You should be using mysqli or PDO, not mysql_ functions $SQLproverb = "SELECT id, proverb FROM $Proverb ORDER BY RAND() LIMIT 1"; $QueryResult = mysql_query($SQLproverb, $DBConnect); $Row = mysql_fetch_assoc($QueryResult); echo "<p style = 'text-align:center'>{$Row[proverb]}</p>\n"; $SQLString = "UPDATE randomproverb SET display_count = display_count + 1 WHERE id = {$Row[id]}"; $QueryResult = mysql_query($SQLstring, $DBConnect);

You could use SQL's LEAST() function also ... SET ap = ap + LEAST(100-ap, 10) ... so if ap is 93 then only 7 is added but if ap is <91 then 10 is added.

Granularity determines the smallest interval you are interested in. If an event occurred 3 days 5 hours 12 minutes 25 seconds ago would you want to show that, or would it be 3 days ago 3 days 5 hours ago 3 days 5 hours 12 minutes ago You might just want 3 days, but what if the event was only 5 hours 12 minutes 25 seconds ago, what then? 5 hours ago? today? Have a look at DateTime (particulary DateTime::diff() ) and DateInterval classes.

You could do "SELECT COUNT(DISTINCT DATE_FORMAT(date, '%Y-%m')) ..." Or, perhaps, "SELECT DISTINCT DATE_FORMAT(date, '%Y-%m') as month ..." and instead of giving page numbers to click on, give the months 14-12 14-11 14-10 14-09 ... 14-01 Then instead of using page numbers and LIMIT clauses just query for the Y-m that is clicked

Just do this <?php $id = $_GET['id']; $data = $_GET['data']; $key = "Password"; mysql_query("update contest_data set `$key` = '$data' where Contest_Data_ID='$id'") ?>

As you were told in the first reply to this post

Click the [ Best Answer ] button on the post that answered your question

try $sql = "SELECT DISTINCT id,phonemodel FROM iphone";

When I created a maze program I used an image to define the maze. Samples attached. Not very complex, I was using it to experiment with the mathematics of creating 3D maze with perspective views.

To get a page to show something you have to output something. All you are doing is defining a string variable. You also need to get into the habit of checking for errors.

The reason you get the error message Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /home/cello10/public_html/display.php on line 10 is because the query failed for some reason. What that reason is will be given by the contents of mysql_error(). If you don't want to tell us what that it is, then fine, you sort it because we cannot see it for ourselves. Bye.

That does absolutely nothing. You're supposed to be assigning a value to it.

Are you sure it is exactly the same error message? Try echo mysql_error(); after the query and tell us what that gives

Let's be less subtle and try the spoonfeeding approach should be

You don't assign a value to $_SESSION['loggedIn'] "==" is not an assignment operator.

Testing too [ m ]printf[ / m ] : printf [ nobbc ][ m ]printf[ / m ][ /nobbc ] : printf EDIT: Well, the "m" tags worked OK this time but "nobbc" has no effect

IMHO the easiest method is a form with checkboxes. The value of each checkbox would be the set (eg value='6,6,5,4,3,2'); // SAVE 'KEPT' SETS TO DATABASE if (isset($_GET['set'])) { $uId = $db->real_escape_string($_GET['uid']); foreach ($_GET['set'] as $set) { $set = $db->real_escape_string($set); DB_Insert($uId, $set, $TimeStamp); } } echo '<form> <table border="1" cellpadding="4"> <tr><th>Set</th><th>Set Values</th><th>Keep</th></tr>'; echo "<input type='hidden' name='uid' value='$uId'>"; for($i=1; $i<=$Sets; $i++){ $Stat_Results = GenStats($uId, $StartSet, $SetOption); $set = join(',', $Stat_Results); echo "<tr><td>$i</td><td>$set</td><td> <input type='checkbox' name='set[]' value='$set'> </td></tr>"; } echo '</table><input type="submit" name="btnSub" value="Submit"></form>';

$query = "SELECT * FROM asterisk_cdr WHERE calldate BETWEEN '$calldate' AND '$calldate2' AND clid LIKE '%$clid%'"; if (!empty($_GET['channel'])) { $channel = $mysqli->real_escape_string($_GET['channel']); $query .= " AND channel LIKE '%$channel%' "; }

store the data in arrays as you process the query results expense[year][month] = exp_total income[year][month] = inc_total Then it's a matter of looping through the arrays to output. Because you want Apr as month 0 and March as month 11 then the month index in the arrays will be (month + 8 ) % 12 and you will have to check the month to see if it goes in this year or the next