[Warning: mysql_query() expects parameter 2 to be resource, object given in F:\xampp\htdocs\taranaki2.php on line 69]

there is comma(,) before WHERE, remove it

 

echo $UpdateQuery = "UPDATE taranaki2 SET ID='$_POST[id]', Destinations='$_POST[destinations]', Difficulty='$_POST[difficulty]' WHERE ID='$_POST[hidden]' ";

[Warning: mysql_query() expects parameter 2 to be resource, object given in F:\xampp\htdocs\taranaki2.php on line 69]

how many records are you getting for your SELECT query in phpmyadmin

 

SELECT * FROM taranaki2

[Warning: mysql_query() expects parameter 2 to be resource, object given in F:\xampp\htdocs\taranaki2.php on line 69]

check the query in phpmyadmin for the result

 

also check

http://us1.php.net/mysql_fetch_array

[Warning: mysql_query() expects parameter 2 to be resource, object given in F:\xampp\htdocs\taranaki2.php on line 69]

in this line

 

$con = mysql_connect("localhost","root","","taranaki");

 

what is "taranaki", is this database password?, if yes, then it should be 3rd parameter of mysql_connect

 

also echo your SELECT query and check it in phpmyadmin

[Warning: mysql_query() expects parameter 2 to be resource, object given in F:\xampp\htdocs\taranaki2.php on line 69]

show your final code

[2 Divs side by side]

check this sample CSS and HTML

#maindiv
{
    width:500px;
    background-color:#000;
    height:100px;
    padding:3px;
}
#leftdiv
{
    width:250px;
    background-color:red;
    float:left;
    height:100px;
}
#rightdiv
{
    width:250px;
    background-color:#fff;
    float:right;
    height:100px;
}

<div id="maindiv">
    <div id="leftdiv"></div>
    <div id="rightdiv"></div>
</div>

[Warning: mysql_query() expects parameter 2 to be resource, object given in F:\xampp\htdocs\taranaki2.php on line 69]

you are mixing mysqli and mysql functions

 

if you  use "mysql_connect" then you need to use "mysql_select_db" to connect the database

[Warning: mysql_query() expects parameter 2 to be resource, object given in F:\xampp\htdocs\taranaki2.php on line 69]

check your SQL queries, also use only mysql or mysqli

[Search filters with combobox]

search this line

while($linhaRetorno == mysql_fetch_array($qrRetorno))

you have used "==" instead of "="

[Auto decrease the Div height]

try using this

div.scroll
{
	width:405px;
	max-height:550px;
	overflow-y:auto;
	overflow-x:hidden;
} 

it will work as, its maximum height is 550 and after that vertical scroll bar will come

[session variable as array element for another session variable?]

try this

<?php
 print $_SESSION[$question_ids[$_SESSION['question_pointer']];
?>

[PHP to drop/clear/wipe mysql database so that all rows are deleted and the database is empty]

use TUNCATE tablename

 

or you can just export database structure and restore back overwriting the old database

 

do take backup of your old database

[Trying to compare two dates…one from mysql DB stored as DATE and one using DateTime object]

you cannot compare dates in "Y-m-d" format, you need to convert it into timestamp format, use mktime() function

[COUNT Query Help]

try using GROUP BY clause  like this

 

SELECT course.courseTitle, COUNT(DISTINCT student.sex)
FROM course, student
WHERE student.sex = 'f' GROUP BY course.courseTitle

[How to add a bit of padding to this page?]

just add <br> tag in between

[importing csv to mysql using php]

check this

 

http://www.php-guru.in/2013/import-csv-data-to-mysql-using-php/

[Field shorten in PhpMyAdmin]

use MySQL replace function in query like this

UPDATE Pic SET Place_id = REPLACE(Place_id, '#', '')

also do take table backup before doing mass update

[Notice: Undefined variable: txtstudentid in C:\xampp\htdocs\search.php on line 9]

you have used underscore (_) in variable ($_txtstudentid) of SQL query and at top you have not used underscore

[sorting an associative array by first key]

try using this function

function sort_array($array, $key, $order)
	{
		if ($order=="DESC")
			$or="arsort";
		else
			$or="asort";
		for ($i = 0; $i < sizeof($array); $i++) 
		{
			$sort_values[$i] = $array[$i][$key];
		} 
		$or($sort_values);
		reset ($sort_values);
		while (list ($arr_key, $arr_val) = each ($sort_values)) 
		{
			$sorted_arr[] = $array[$arr_key];
		}
		return $sorted_arr;
	}

[Rotate an iframe Source Every 24 Hours]

if you are not going to reload the page then you can use meta refresh tag in iframe source page

[i put different action but when i hit submit it still bring me to the same page]

each form should have its own submit button and every form should have close tag

[Problem with while loop and html output]

Try replacing while loop using below code

$i = 1;
echo '<tr>';
while($row = $ret->fetchArray(SQLITE3_ASSOC) )
{
      echo '<td>' .$row['Domain'].'</td><td><input type="checkbox" name="a[]" value="n"></td>';
      if ($i % 5 == 0)
             echo '</tr><tr>';
      $i++;
}
echo '</tr>';

[php frameworks and mvc]

Check codeigniter

 

http://ellislab.com/codeigniter

 

User guide

http://ellislab.com/codeigniter/user-guide/

["Sorry, no new content found" for View New Content]

Thanks for your reply

["Sorry, no new content found" for View New Content]

Hi,

 

from few weeks I am getting "Sorry, no new content found." whenever I go to "View New Content" link