PHPBuilder.com - Database http://board.phpbuilder.com/ Conversation regarding PHP and SQL en Mon, 20 May 2013 02:51:26 GMT vBulletin 60 http://board.phpbuilder.com/images/misc/rss.png PHPBuilder.com - Database http://board.phpbuilder.com/ Query with joins, count()s and sum() producing odd results http://board.phpbuilder.com/showthread.php?10389711-Query-with-joins-count()s-and-sum()-producing-odd-results&goto=newpost Wed, 15 May 2013 01:22:31 GMT Well, probably not "odd" - much more likely bad SQL on my part.

I'm attempting to get a list of all customers, and get each customer's count of orders from the order table, count of cart items from the cart items table, and sum of store credit from the credits table.

=====================================

SELECT c.*, SUM(sc.amount) AS creditTotal, COUNT(o.orderId) AS orders, MAX(o.orderDate) AS lastOrder FROM customers c LEFT JOIN storeCredits sc ON c.customerId=sc.customerId LEFT JOIN orders o ON c.customerId=o.customerId GROUP BY c.customerId ORDER BY c.lastName ASC

This gets me an "orders" count of 4 for my second customer, which is correct. But when I join cartItems to the query I get an orders count of 8, and a cartItemCount of 8 (should be 2).

SELECT c.*, SUM(sc.amount) AS creditTotal, COUNT(o.orderId) AS orders, MAX(o.orderDate) AS lastOrder, COUNT(ci.cartItemId) AS cartItemCount FROM customers c LEFT JOIN storeCredits sc ON c.customerId=sc.customerId LEFT JOIN orders o ON c.customerId=o.customerId LEFT JOIN cartItems ci ON c.customerId=ci.customerId GROUP BY c.customerId ORDER BY c.lastName ASC

It's definitely adding the last LEFT JOIN that's messing things up, not adding to the SELECT statement. It seems to be multiplying the COUNT items within the query by each other (4 x 2) instead of keeping them isolated and separate.

Any tips? ]]> Database bunner bob http://board.phpbuilder.com/showthread.php?10389711-Query-with-joins-count()s-and-sum()-producing-odd-results <![CDATA[[RESOLVED] Row 10 no displaying]]> http://board.phpbuilder.com/showthread.php?10389703-RESOLVED-Row-10-no-displaying&goto=newpost Tue, 14 May 2013 15:05:26 GMT prepare($host_query)){ // prepare failed echo "
Prepare failed:\n";
    print_r($pdo->errorInfo());
    echo "
"; } else { if(!$book_stmt->execute(array('books'))){ // execute failed echo "
Execute failed:\n";
        print_r($book_stmt->errorInfo());
        echo "
"; } else { // query ran without any errors, you can test if it returned any rows and use them here } } // Database if ($book_stmt->rowCount() > 0) { while ($col = $book_stmt->fetch()) { $title = $col[3]; $author = $col[4]; $descr = $col[5]; $type = $col[6]; $language = $col[7]; $paperback = $col[8]; $currency = $col[9]; $price = $col[10]; } } else { $title = 'no data'; $author = 'no data'; $descr = 'no data'; $type = 'no data'; $language = 'no data'; $paperback = 'no data'; $currency = 'no data'; $price = 'no data'; } --------- What can I do to correct this?]]> I hopefully seem to be getting somewhere from my last post about creating a database script. But now I seem to be getting an error with the following:

Code:
Notice: Undefined offset: 10 in /var/www/mysite/include/config.php on line 126
So its this line 126 that the output will not produce:

Code:
$price = $col[10];
I ran the query in phpmyadmin to make sure it was working:

SQL result

Host: localhost
Database: mydb
Generation Time: May 14, 2013 at 04:56 PM
Generated by: phpMyAdmin 3.5.8.1deb1 / MySQL 5.5.31-0ubuntu0.13.04.1
SQL query: SELECT * FROM packages WHERE service = 'books' LIMIT 1;
Rows: 1

service plan title author descr type language paperback currency price
books weekly a b c d e f g h

Here is the code:

PHP Code:

$book_query = ("SELECT * FROM packages WHERE service = ? LIMIT 1");
if(!$book_stmt = $pdo->prepare($host_query)){
    // prepare failed
    echo "<pre>Prepare failed:\n";
    print_r($pdo->errorInfo());
    echo "</pre>";
} else {
    if(!$book_stmt->execute(array('books'))){
        // execute failed
        echo "<pre>Execute failed:\n";
        print_r($book_stmt->errorInfo());
        echo "</pre>";
    } else {
        // query ran without any errors, you can test if it returned any rows and use them here
        
    }
}
// Database  

if ($book_stmt->rowCount() > 0) {
    while ($col = $book_stmt->fetch())
    {
    $title = $col[3];
    $author = $col[4];
    $descr = $col[5];
    $type = $col[6];
    $language = $col[7];
    $paperback = $col[8];
    $currency = $col[9];
    $price = $col[10];
    

    }

} else {

    $title = 'no data';
    $author = 'no data';
    $descr = 'no data';
    $type = 'no data';
    $language = 'no data';
    $paperback = 'no data';
    $currency = 'no data';
    $price = 'no data';

} 


What can I do to correct this? ]]> Database chrisguk http://board.phpbuilder.com/showthread.php?10389703-RESOLVED-Row-10-no-displaying Is my select statement secure enough? http://board.phpbuilder.com/showthread.php?10389701-Is-my-select-statement-secure-enough&goto=newpost Mon, 13 May 2013 14:37:20 GMT exec("SET CHARACTER SET utf8"); // Sets encoding UTF-8 // Define and perform the SQL SELECT query $sql = "SELECT * FROM `db_linux`"; $result = $conn->query($sql); // If the SQL query is successfully performed ($result not false) if($result !== false) { $cols = $result->columnCount(); // Number of returned columns // Parse the result set if ($sql->num_rows > 0) { while ($row = $sql->fetch_object()) { $plan = $row->plan; $name = $row->name; $text = $row->text; } } else { $plan = 'no plan'; $name = 'NA'; $text = 'NA2'; } } --------- ]]> I have thrown together the following, with a few snippets pulled from various places. Is it ok to use without the worry of sql injection?

PHP Code:

try {
  // Connect and create the PDO object
  $conn = new PDO("mysql:host=$hostdb; dbname=$namedb", $userdb, $passdb);
  $conn->exec("SET CHARACTER SET utf8");      // Sets encoding UTF-8

  // Define and perform the SQL SELECT query
  $sql = "SELECT * FROM `db_linux`";
  $result = $conn->query($sql);

  // If the SQL query is successfully performed ($result not false)
  if($result !== false) {
    $cols = $result->columnCount();           // Number of returned columns

    // Parse the result set
   if ($sql->num_rows > 0) {
    while ($row = $sql->fetch_object())
    {
        $plan = $row->plan;
        $name = $row->name;
        $text = $row->text;

    }

} else {

    
    $plan = 'no plan';
    $name = 'NA';
    $text = 'NA2';

} 
    
    
  } 
]]> Database chrisguk http://board.phpbuilder.com/showthread.php?10389701-Is-my-select-statement-secure-enough MYSQL Update http://board.phpbuilder.com/showthread.php?10389699-MYSQL-Update&goto=newpost Mon, 13 May 2013 11:23:59 GMT HI

Im using the following to update databases

PHP Code:
MYSQL_QUERY( "insert into $table1 SELECT * FROM $table2 where 1 "); 

There are 24 fields in each table, my problem is if a reference number ( ie. R12121 ) exists in table1 i want it to update and not add new record, how can this be done? ]]> Database leewad http://board.phpbuilder.com/showthread.php?10389699-MYSQL-Update Possible pagination approach with PDO http://board.phpbuilder.com/showthread.php?10389667-Possible-pagination-approach-with-PDO&goto=newpost Thu, 09 May 2013 19:53:35 GMT prepare($sql, array(PDO::ATTR_CURSOR => PDO::CURSOR_SCROLL)); $stmt->execute(); // to be used by pagination functions for total items: $totalRows = $stmt->rowCount(); // populate array of data to be displayed on this page: $data = array(); for($ix = 0; $ix++; $ix < $numPerPage) { $row = $stmt->fetch(PDO::FETCH_NUM, PDO::FETCH_ORI_ABS, $offset + $ix); if($row != false) { $data[] = $row; } else { break; } } --------- Thoughts? Suggestions?]]> Just want to run this idea past any interested parties for thoughts on validity and correctness. Basic issue is I'm looking at some code that essentially runs the same query -- one that's pretty ugly and not terribly quick -- once to get the data to be displayed on the page (based on pagination offset/limit), then again to get the total count (so pagination knows how many pages there are. Here's the basic process I'm thinking of using to do it in one query:
PHP Code:
<?php

// sample pagination values from some input or other
$offset = 20;
$numPerPage = 10;

$sql = "some complex query that takes more time than I'd like";
$stmt = $pdo->prepare($sql, array(PDO::ATTR_CURSOR => PDO::CURSOR_SCROLL));
$stmt->execute();
// to be used by pagination functions for total items:
$totalRows = $stmt->rowCount();
// populate array of data to be displayed on this page:
$data = array();
for($ix = 0; $ix++; $ix < $numPerPage) {
    $row = $stmt->fetch(PDO::FETCH_NUM, PDO::FETCH_ORI_ABS, $offset + $ix);
    if($row != false) {
        $data[] = $row;
    }
    else {
        break;
    }
}
Thoughts? Suggestions? ]]> Database NogDog http://board.phpbuilder.com/showthread.php?10389667-Possible-pagination-approach-with-PDO Max date query http://board.phpbuilder.com/showthread.php?10389663-Max-date-query&goto=newpost Thu, 09 May 2013 10:30:01 GMT Hello,

I can't firgure out how to do the following:

table 1:

customerid
name

table 2:

...
customerid
date

Customers can have multiple entries in table 2.

I want to find all customers for which the latest date in the date column is longer ago then 30 days.

I belief to return the latest date you can use MAX(date) and the 30 days interval can be checked like: date < NOW() - INTERVAL 30 DAY

But how to put the two together in a single query?

Any help would be very much appreciated, thanks! ]]> Database safra http://board.phpbuilder.com/showthread.php?10389663-Max-date-query nested query ?? http://board.phpbuilder.com/showthread.php?10389637-nested-query&goto=newpost Mon, 06 May 2013 20:15:04 GMT multi_query($query)); { $WorkOrders[$Count] = $result3->num_rows; $SubWorkOrders = $SubWorkOrders + $WorkOrders[$Count]; } --------- Help!! I have my favorite shotgun, a box of ammo, and a faithful black lab at my side. Man, it's cold out here.]]> Here's what I'm trying to accomplish:

PHP Code:
SELECT * FROM TOAWorkOrders WHERE 
(WorkDate = '$WorkDate' AND TechNum = '$TechNum') 
AND 
(Type != 'Lunch' OR Type != 'Break') order by Type 
I have found this from a few sources, but I can't figure out how to put them into practice.

PHP Code:
$query = "SELECT * FROM TOAWorkOrders WHERE TechNum = '$TechNum' AND WorkDate = '$IncDate'";
$query .= "SELECT * FROM TOAWorkOrders WHERE Type != 'Lunch' OR Type != 'Break'";
                                
if ($result3 = $mysqli->multi_query($query));
{    
    $WorkOrders[$Count] = $result3->num_rows;
     $SubWorkOrders = $SubWorkOrders + $WorkOrders[$Count];
} 
Help!!

I have my favorite shotgun, a box of ammo, and a faithful black lab at my side. Man, it's cold out here. ]]> Database timstring http://board.phpbuilder.com/showthread.php?10389637-nested-query <![CDATA[[RESOLVED] Using alias column names]]> http://board.phpbuilder.com/showthread.php?10389627-RESOLVED-Using-alias-column-names&goto=newpost Mon, 06 May 2013 12:54:20 GMT Hi all,

Having looked around for some time I can't find any previous posts which can help me solve my issue.

I have an MySQl table in which I use an "if" statement to change the data displayed in one of the columns.

The process kind of works but the column header contains the "if" statement. This is the query:

PHP Code:

f.fn AS 'FND',
date_format(d.st, '%'H:%i) AS stm,
d.al aS 'ALN',
if(d.ad = 'x', 'I','O')
FROM Table1 f, Table2 d
WHERE f.fn = d.nfn
ORDER BY d.st 
When the daya is displayed the column which holds the content of d.ad shows the column header "if(d.ad = 'x', 'I','O')" and not the colum name.

Can anyone give me some advise.

Thanks

Blackbox ]]> Database blackbox http://board.phpbuilder.com/showthread.php?10389627-RESOLVED-Using-alias-column-names After Log in, Pull Course Information Help! Please http://board.phpbuilder.com/showthread.php?10389621-After-Log-in-Pull-Course-Information-Help!-Please&goto=newpost Sun, 05 May 2013 00:02:20 GMT 0) { $row = mysql_fetch_array($checklogin); $email = $row['EmailAddress']; $courseNo = $row['courseNo']; $deptId = $row['deptId']; $callNo = $row['callNo']; $sectDays = $row['sectDays']; $sectStartTime = $row['sectStartTime']; $sectEndTime = $row['sectEndTime']; $roomNo = $row['roomNo']; $bldgId = $row['bldgId']; $_SESSION['LoggedIn'] = 1; echo "

Success

"; echo "

We are now redirecting you to the member area.

"; echo ""; } else { echo "

Error

"; echo "

Sorry, your account could not be found. Please click here to try again.

"; } } else { ?> :confused::confused::confused:]]> how do I fix this error?

mysql_num_rows() expects parameter 1 to be resource, null given in /home/content/19/10458419/html/capstone/loginScript/indexTest.php on line 61

My Code

<?php
}
elseif(!empty($_POST['username']) && !empty($_POST['password']))
{
$username = mysql_real_escape_string($_POST['username']);
$password = md5(mysql_real_escape_string($_POST['password']));

$checklogin = mysql_query("SELECT * FROM schedule WHERE Username = '".$username."' AND Password = '".$password."'");

if (mysql_num_rows($checkusername) > 0)
{
$row = mysql_fetch_array($checklogin);

$email = $row['EmailAddress'];
$courseNo = $row['courseNo'];
$deptId = $row['deptId'];
$callNo = $row['callNo'];
$sectDays = $row['sectDays'];
$sectStartTime = $row['sectStartTime'];
$sectEndTime = $row['sectEndTime'];
$roomNo = $row['roomNo'];
$bldgId = $row['bldgId'];


$_SESSION['LoggedIn'] = 1;

echo "<h1>Success</h1>";
echo "<p>We are now redirecting you to the member area.</p>";
echo "<meta http-equiv='refresh' content='=2;indexTest.php' />";
}
else
{
echo "<h1>Error</h1>";
echo "<p>Sorry, your account could not be found. Please <a href=\"indexTest.php\">click here to try again</a>.</p>";
}
}
else
{
?>

:confused::confused::confused: ]]> Database Abicus http://board.phpbuilder.com/showthread.php?10389621-After-Log-in-Pull-Course-Information-Help!-Please explain a query - please help http://board.phpbuilder.com/showthread.php?10389613-explain-a-query-please-help&goto=newpost Sat, 04 May 2013 03:19:46 GMT ALL NULL NULL NULL NULL 777 Using where; Using temporary; Using filesort 1 PRIMARY l ref LeaseStartDate,Units_ID Units_ID 4 m.ID 20 2 DERIVED cl ALL PRIMARY NULL NULL NULL 423 Using temporary; Using filesort 2 DERIVED p ref Clients_ID Clients_ID 4 cpm151_sanmarcos.cl.ID 1 Using where 2 DERIVED u ref Clients_ID Clients_ID 4 cpm151_sanmarcos.p.ID 2 2 DERIVED a ref LeaseStartDate,Units_ID Units_ID 4 cpm151_sanmarcos.u.ID 20 2 DERIVED flprimary ref Type,Leases_ID Leases_ID 4 cpm151_sanmarcos.a.ID 1 2 DERIVED flc eq_ref PRIMARY PRIMARY 4 cpm151_sanmarcos.flprimary.Contacts_ID 1 2 DERIVED flall ref Leases_ID Leases_ID 4 cpm151_sanmarcos.a.ID 1 2 DERIVED a ref LeaseStartDate,Units_ID Units_ID 4 cpm151_sanmarcos.u.ID 20 2 DERIVED clprimary ref Type,Leases_ID Leases_ID 4 cpm151_sanmarcos.a.ID 1 2 DERIVED clc eq_ref PRIMARY PRIMARY 4 cpm151_sanmarcos.clprimary.Contacts_ID 1 2 DERIVED clall ref Leases_ID Leases_ID 4 cpm151_sanmarcos.a.ID 1 now, _v_properties_master_list is a fairly complex and I will post that separately if needed. Thanks!]]> I am not as familiar with the EXPLAIN feature as I should be, can anyone help me with this slow query? Sorry if the table is a bit scattered:



here is my query:

EXPLAIN SELECT m . * /* number of leases that show present COUNT(DISTINCT l.ID) AS Leases,*/
FROM _v_properties_master_list m
LEFT JOIN gl_leases l ON m.ID = l.Units_ID
AND /* the unit/house/etc is leased AS OF THE INTENDED MOVE-IN DAY OF THE SEARCH - we filter this out outside of the left join .. */ '2013-05-03'
BETWEEN l.LeaseStartDate
AND IF( l.LeaseTerminationDate, l.LeaseTerminationDate, IF( l.LeaseEndDate, l.LeaseEndDate, '2199-12-31' ) )
WHERE m.Active =1
AND
TYPE IN (
'APT'
)
AND Bedrooms =1
AND Bathrooms =1
AND PropertyCity
IN (
'San Marcos'
)
AND (
1
)
AND m.ID
IN ( 105, 848 )
GROUP BY m.ID
ORDER BY PropertyName ASC


and here is the result:

id select_type table type possible_keys key key_len ref rows Extra
1 PRIMARY <derived2> ALL NULL NULL NULL NULL 777 Using where; Using temporary; Using filesort
1 PRIMARY l ref LeaseStartDate,Units_ID Units_ID 4 m.ID 20
2 DERIVED cl ALL PRIMARY NULL NULL NULL 423 Using temporary; Using filesort
2 DERIVED p ref Clients_ID Clients_ID 4 cpm151_sanmarcos.cl.ID 1 Using where
2 DERIVED u ref Clients_ID Clients_ID 4 cpm151_sanmarcos.p.ID 2
2 DERIVED a ref LeaseStartDate,Units_ID Units_ID 4 cpm151_sanmarcos.u.ID 20
2 DERIVED flprimary ref Type,Leases_ID Leases_ID 4 cpm151_sanmarcos.a.ID 1
2 DERIVED flc eq_ref PRIMARY PRIMARY 4 cpm151_sanmarcos.flprimary.Contacts_ID 1
2 DERIVED flall ref Leases_ID Leases_ID 4 cpm151_sanmarcos.a.ID 1
2 DERIVED a ref LeaseStartDate,Units_ID Units_ID 4 cpm151_sanmarcos.u.ID 20
2 DERIVED clprimary ref Type,Leases_ID Leases_ID 4 cpm151_sanmarcos.a.ID 1
2 DERIVED clc eq_ref PRIMARY PRIMARY 4 cpm151_sanmarcos.clprimary.Contacts_ID 1
2 DERIVED clall ref Leases_ID Leases_ID 4 cpm151_sanmarcos.a.ID 1

now, _v_properties_master_list is a fairly complex and I will post that separately if needed. Thanks! ]]> Database sfullman http://board.phpbuilder.com/showthread.php?10389613-explain-a-query-please-help execute () on a non-object http://board.phpbuilder.com/showthread.php?10389593-execute-()-on-a-non-object&goto=newpost Thu, 02 May 2013 15:09:58 GMT error); // Check connection if ($mysqli->connect_errno) { echo "Hey you dolt, Failed to connect to MySQL: (" . $mysqli->connect_errno . ") " . $mysqli->connect_error; } ///////no good $Quest = "SELECT WorkDate FROM InTime"; $stmt = $mysqli->prepare($Quest); $stmt->execute(); // <- error happens here $DateResult = $stmt->get_result(); $TestWorkDate = $row['WorkDate']; echo $TestWorkDate . ' a ' . $WorkDate . '
'; ini_set('auto_detect_line_endings', true); --------- Everything was good at 5:00 yesterday. Why now?]]> :glare: I am getting this error on every one of my scripts:

Code:
Fatal error: Call to a member function execute() on a non-object in /Library/WebServer/Documents/DispatchReports/InTime.php on line 55
The offending code is:
PHP Code:
$host="localhost";
$user="root";
$password="g1G3m#1989";
$Dbname = "CallsToDispatch";

$mysqli = new mysqli($host, $user, $password, $Dbname) or die('host doesnt work ' . $mysqli->error);

// Check connection
if ($mysqli->connect_errno) {
    echo "Hey you dolt, Failed to connect to MySQL: (" . $mysqli->connect_errno . ") " . $mysqli->connect_error;
}

///////no good


$Quest = "SELECT WorkDate FROM InTime";

    $stmt = $mysqli->prepare($Quest);

$stmt->execute(); // <- error happens here
$DateResult = $stmt->get_result();
        
$TestWorkDate = $row['WorkDate'];
echo $TestWorkDate . ' a ' . $WorkDate . '<br>';
    
ini_set('auto_detect_line_endings', true); 
Everything was good at 5:00 yesterday. Why now? ]]> Database timstring http://board.phpbuilder.com/showthread.php?10389593-execute-()-on-a-non-object Jquery AJAX response from PHP has brackets around the JSON object http://board.phpbuilder.com/showthread.php?10389589-Jquery-AJAX-response-from-PHP-has-brackets-around-the-JSON-object&goto=newpost Thu, 02 May 2013 01:56:26 GMT connect_error) { die('Connect Error (' . $mysqli->connect_errno . ') ' . $mysqli->connect_error); } $sql = 'SELECT todo,date,name,id FROM task WHERE todo IS NOT NULL || todo > "" ' ; $sqlOrder = 'Order by Date' ; $sql .= $sqlOrder ; $result = $mysqli->query($sql); if($result = $mysqli->query($sql)) { $i= 0; while($row = $result->fetch_object()) { $function_result[$i]= $row; $i++; } //end while header('Content-type: application/json'); echo json_encode($function_result); }//end if }//end function --------- The problem is when I don't send the header the JSON encoded string has an extra bracket around it. The header is supposed to tell Jquery that it should be expecting a JSON encoded object but sending the header doesn't get rid of the bracket. This is the header that is returned in the browser from the PHP script. http://localhost:8888/todo/todo1.html GET /todo/todo1.html HTTP/1.1 Host: localhost:8888 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.8; rv:20.0) Gecko/20100101 Firefox/20.0 Accept: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8 Accept-Language: en-US,en;q=0.5 Accept-Encoding: gzip, deflate Connection: keep-alive If-Modified-Since: Thu, 02 May 2013 01:47:33 GMT If-None-Match: "c4a50a1-1915-4dbb26b051740" Cache-Control: max-age=0 HTTP/1.1 304 Not Modified Date: Thu, 02 May 2013 01:54:00 GMT Server: Apache/2.2.23 (Unix) mod_ssl/2.2.23 OpenSSL/0.9.8r DAV/2 PHP/5.4.10 Connection: Keep-Alive Keep-Alive: timeout=5, max=100 Etag: "c4a50a1-1915-4dbb26b051740" ---------------------------------------------------------- http://localhost:8888/todo/todo1.css GET /todo/todo1.css HTTP/1.1 Host: localhost:8888 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.8; rv:20.0) Gecko/20100101 Firefox/20.0 Accept: text/css,*/*;q=0.1 Accept-Language: en-US,en;q=0.5 Accept-Encoding: gzip, deflate Referer: http://localhost:8888/todo/todo1.html Connection: keep-alive If-Modified-Since: Tue, 19 Mar 2013 21:15:41 GMT If-None-Match: "c4d742b-1a5d-4d84d9b929940" Cache-Control: max-age=0 HTTP/1.1 304 Not Modified Date: Thu, 02 May 2013 01:54:00 GMT Server: Apache/2.2.23 (Unix) mod_ssl/2.2.23 OpenSSL/0.9.8r DAV/2 PHP/5.4.10 Connection: Keep-Alive Keep-Alive: timeout=5, max=99 Etag: "c4d742b-1a5d-4d84d9b929940" ---------------------------------------------------------- http://ajax.googleapis.com/ajax/libs/jquery/1.9.1/jquery.min.js GET /ajax/libs/jquery/1.9.1/jquery.min.js HTTP/1.1 Host: ajax.googleapis.com User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.8; rv:20.0) Gecko/20100101 Firefox/20.0 Accept: */* Accept-Language: en-US,en;q=0.5 Accept-Encoding: gzip, deflate Referer: http://localhost:8888/todo/todo1.html Connection: keep-alive If-Modified-Since: Fri, 08 Feb 2013 15:35:10 GMT Cache-Control: max-age=0 HTTP/1.1 304 Not Modified Date: Wed, 01 May 2013 13:54:44 GMT Expires: Thu, 01 May 2014 13:54:44 GMT Age: 43156 Server: GFE/2.0 ---------------------------------------------------------- http://ajax.googleapis.com/ajax/libs/jqueryui/1.10.1/jquery-ui.min.js GET /ajax/libs/jqueryui/1.10.1/jquery-ui.min.js HTTP/1.1 Host: ajax.googleapis.com User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.8; rv:20.0) Gecko/20100101 Firefox/20.0 Accept: */* Accept-Language: en-US,en;q=0.5 Accept-Encoding: gzip, deflate Referer: http://localhost:8888/todo/todo1.html Connection: keep-alive If-Modified-Since: Fri, 15 Feb 2013 22:11:00 GMT Cache-Control: max-age=0 HTTP/1.1 304 Not Modified Date: Wed, 01 May 2013 13:55:41 GMT Expires: Thu, 01 May 2014 13:55:41 GMT Age: 43099 Server: GFE/2.0 ---------------------------------------------------------- http://ajax.googleapis.com/ajax/libs/jqueryui/1.10.0/themes/overcast/jquery-ui.css GET /ajax/libs/jqueryui/1.10.0/themes/overcast/jquery-ui.css HTTP/1.1 Host: ajax.googleapis.com User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.8; rv:20.0) Gecko/20100101 Firefox/20.0 Accept: text/css,*/*;q=0.1 Accept-Language: en-US,en;q=0.5 Accept-Encoding: gzip, deflate Referer: http://localhost:8888/todo/todo1.html Connection: keep-alive If-Modified-Since: Thu, 24 Jan 2013 18:41:38 GMT Cache-Control: max-age=0 HTTP/1.1 304 Not Modified Date: Wed, 01 May 2013 21:38:06 GMT Expires: Thu, 01 May 2014 21:38:06 GMT Age: 15354 Server: GFE/2.0 ---------------------------------------------------------- http://ajax.aspnetcdn.com/ajax/modernizr/modernizr-2.0.6-development-only.js GET /ajax/modernizr/modernizr-2.0.6-development-only.js HTTP/1.1 Host: ajax.aspnetcdn.com User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.8; rv:20.0) Gecko/20100101 Firefox/20.0 Accept: */* Accept-Language: en-US,en;q=0.5 Accept-Encoding: gzip, deflate Referer: http://localhost:8888/todo/todo1.html Connection: keep-alive If-Modified-Since: Mon, 20 Jun 2011 21:39:37 GMT If-None-Match: "8e7a8f8d922fcc1:0" Cache-Control: max-age=0 HTTP/1.1 304 Not Modified Content-Type: application/x-javascript Age: 8324272 Date: Thu, 02 May 2013 01:54:00 GMT Expires: Sat, 25 Jan 2014 17:36:08 GMT Connection: keep-alive ---------------------------------------------------------- http://localhost:8888/todo/form_handler1.php GET /todo/form_handler1.php HTTP/1.1 Host: localhost:8888 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.8; rv:20.0) Gecko/20100101 Firefox/20.0 Accept: application/json, text/javascript, */*; q=0.01 Accept-Language: en-US,en;q=0.5 Accept-Encoding: gzip, deflate X-Requested-With: XMLHttpRequest Referer: http://localhost:8888/todo/todo1.html Connection: keep-alive Cache-Control: max-age=0 HTTP/1.1 200 OK Date: Thu, 02 May 2013 01:54:01 GMT Server: Apache/2.2.23 (Unix) mod_ssl/2.2.23 OpenSSL/0.9.8r DAV/2 PHP/5.4.10 X-Powered-By: PHP/5.4.10 Content-Length: 2788 Keep-Alive: timeout=5, max=98 Connection: Keep-Alive Content-Type: application/json ---------------------------------------------------------- http://ajax.googleapis.com/ajax/libs/jqueryui/1.10.0/themes/overcast/images/ui-bg_glass_60_eeeeee_1x400.png GET /ajax/libs/jqueryui/1.10.0/themes/overcast/images/ui-bg_glass_60_eeeeee_1x400.png HTTP/1.1 Host: ajax.googleapis.com User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.8; rv:20.0) Gecko/20100101 Firefox/20.0 Accept: image/png,image/*;q=0.8,*/*;q=0.5 Accept-Language: en-US,en;q=0.5 Accept-Encoding: gzip, deflate Referer: http://ajax.googleapis.com/ajax/libs/jqueryui/1.10.0/themes/overcast/jquery-ui.css Connection: keep-alive If-Modified-Since: Thu, 24 Jan 2013 18:41:38 GMT Cache-Control: max-age=0 HTTP/1.1 304 Not Modified Content-Type: image/png Date: Thu, 02 May 2013 01:54:01 GMT Expires: Fri, 02 May 2014 01:54:01 GMT Cache-Control: public, max-age=31536000 x-content-type-options: nosniff Server: sffe x-xss-protection: 1; mode=block ---------------------------------------------------------- Do you know how to modify MAMP setting so I can get JSON encoded data? I also tried JSON.stringify(data); to get rid of the brackets and that didn't work. Thanks,]]> Here is my function:
PHP Code:
function get_it(){
global $mysqli;    
if ($mysqli->connect_error) {
    die('Connect Error (' . $mysqli->connect_errno . ') '
            . $mysqli->connect_error);
}


$sql = 'SELECT todo,date,name,id FROM task WHERE todo IS NOT NULL || todo > "" ' ;
$sqlOrder = 'Order by Date' ;
$sql .= $sqlOrder ;

$result = $mysqli->query($sql);

if($result = $mysqli->query($sql)) {
    
$i= 0;
    while($row = $result->fetch_object()) {
    
 $function_result[$i]=     $row;
$i++; 
}    //end while
header('Content-type: application/json');
echo json_encode($function_result);

}//end if

}//end function 
The problem is when I don't send the header the JSON encoded string has an extra bracket around it. The header is supposed to tell Jquery that it should be expecting a JSON encoded object but sending the header doesn't get rid of the bracket. This is the header that is returned in the browser from the PHP script.
http://localhost:8888/todo/todo1.html

GET /todo/todo1.html HTTP/1.1
Host: localhost:8888
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.8; rv:20.0) Gecko/20100101 Firefox/20.0
Accept: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
Accept-Language: en-US,en;q=0.5
Accept-Encoding: gzip, deflate
Connection: keep-alive
If-Modified-Since: Thu, 02 May 2013 01:47:33 GMT
If-None-Match: "c4a50a1-1915-4dbb26b051740"
Cache-Control: max-age=0

HTTP/1.1 304 Not Modified
Date: Thu, 02 May 2013 01:54:00 GMT
Server: Apache/2.2.23 (Unix) mod_ssl/2.2.23 OpenSSL/0.9.8r DAV/2 PHP/5.4.10
Connection: Keep-Alive
Keep-Alive: timeout=5, max=100
Etag: "c4a50a1-1915-4dbb26b051740"
----------------------------------------------------------
http://localhost:8888/todo/todo1.css

GET /todo/todo1.css HTTP/1.1
Host: localhost:8888
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.8; rv:20.0) Gecko/20100101 Firefox/20.0
Accept: text/css,*/*;q=0.1
Accept-Language: en-US,en;q=0.5
Accept-Encoding: gzip, deflate
Referer: http://localhost:8888/todo/todo1.html
Connection: keep-alive
If-Modified-Since: Tue, 19 Mar 2013 21:15:41 GMT
If-None-Match: "c4d742b-1a5d-4d84d9b929940"
Cache-Control: max-age=0

HTTP/1.1 304 Not Modified
Date: Thu, 02 May 2013 01:54:00 GMT
Server: Apache/2.2.23 (Unix) mod_ssl/2.2.23 OpenSSL/0.9.8r DAV/2 PHP/5.4.10
Connection: Keep-Alive
Keep-Alive: timeout=5, max=99
Etag: "c4d742b-1a5d-4d84d9b929940"
----------------------------------------------------------
http://ajax.googleapis.com/ajax/libs.../jquery.min.js

GET /ajax/libs/jquery/1.9.1/jquery.min.js HTTP/1.1
Host: ajax.googleapis.com
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.8; rv:20.0) Gecko/20100101 Firefox/20.0
Accept: */*
Accept-Language: en-US,en;q=0.5
Accept-Encoding: gzip, deflate
Referer: http://localhost:8888/todo/todo1.html
Connection: keep-alive
If-Modified-Since: Fri, 08 Feb 2013 15:35:10 GMT
Cache-Control: max-age=0

HTTP/1.1 304 Not Modified
Date: Wed, 01 May 2013 13:54:44 GMT
Expires: Thu, 01 May 2014 13:54:44 GMT
Age: 43156
Server: GFE/2.0
----------------------------------------------------------
http://ajax.googleapis.com/ajax/libs...uery-ui.min.js

GET /ajax/libs/jqueryui/1.10.1/jquery-ui.min.js HTTP/1.1
Host: ajax.googleapis.com
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.8; rv:20.0) Gecko/20100101 Firefox/20.0
Accept: */*
Accept-Language: en-US,en;q=0.5
Accept-Encoding: gzip, deflate
Referer: http://localhost:8888/todo/todo1.html
Connection: keep-alive
If-Modified-Since: Fri, 15 Feb 2013 22:11:00 GMT
Cache-Control: max-age=0

HTTP/1.1 304 Not Modified
Date: Wed, 01 May 2013 13:55:41 GMT
Expires: Thu, 01 May 2014 13:55:41 GMT
Age: 43099
Server: GFE/2.0
----------------------------------------------------------
http://ajax.googleapis.com/ajax/libs.../jquery-ui.css

GET /ajax/libs/jqueryui/1.10.0/themes/overcast/jquery-ui.css HTTP/1.1
Host: ajax.googleapis.com
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.8; rv:20.0) Gecko/20100101 Firefox/20.0
Accept: text/css,*/*;q=0.1
Accept-Language: en-US,en;q=0.5
Accept-Encoding: gzip, deflate
Referer: http://localhost:8888/todo/todo1.html
Connection: keep-alive
If-Modified-Since: Thu, 24 Jan 2013 18:41:38 GMT
Cache-Control: max-age=0

HTTP/1.1 304 Not Modified
Date: Wed, 01 May 2013 21:38:06 GMT
Expires: Thu, 01 May 2014 21:38:06 GMT
Age: 15354
Server: GFE/2.0
----------------------------------------------------------
http://ajax.aspnetcdn.com/ajax/moder...opment-only.js

GET /ajax/modernizr/modernizr-2.0.6-development-only.js HTTP/1.1
Host: ajax.aspnetcdn.com
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.8; rv:20.0) Gecko/20100101 Firefox/20.0
Accept: */*
Accept-Language: en-US,en;q=0.5
Accept-Encoding: gzip, deflate
Referer: http://localhost:8888/todo/todo1.html
Connection: keep-alive
If-Modified-Since: Mon, 20 Jun 2011 21:39:37 GMT
If-None-Match: "8e7a8f8d922fcc1:0"
Cache-Control: max-age=0

HTTP/1.1 304 Not Modified
Content-Type: application/x-javascript
Age: 8324272
Date: Thu, 02 May 2013 01:54:00 GMT
Expires: Sat, 25 Jan 2014 17:36:08 GMT
Connection: keep-alive
----------------------------------------------------------
http://localhost:8888/todo/form_handler1.php

GET /todo/form_handler1.php HTTP/1.1
Host: localhost:8888
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.8; rv:20.0) Gecko/20100101 Firefox/20.0
Accept: application/json, text/javascript, */*; q=0.01
Accept-Language: en-US,en;q=0.5
Accept-Encoding: gzip, deflate
X-Requested-With: XMLHttpRequest
Referer: http://localhost:8888/todo/todo1.html
Connection: keep-alive
Cache-Control: max-age=0

HTTP/1.1 200 OK
Date: Thu, 02 May 2013 01:54:01 GMT
Server: Apache/2.2.23 (Unix) mod_ssl/2.2.23 OpenSSL/0.9.8r DAV/2 PHP/5.4.10
X-Powered-By: PHP/5.4.10
Content-Length: 2788
Keep-Alive: timeout=5, max=98
Connection: Keep-Alive
Content-Type: application/json
----------------------------------------------------------
http://ajax.googleapis.com/ajax/libs...eeee_1x400.png

GET /ajax/libs/jqueryui/1.10.0/themes/overcast/images/ui-bg_glass_60_eeeeee_1x400.png HTTP/1.1
Host: ajax.googleapis.com
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.8; rv:20.0) Gecko/20100101 Firefox/20.0
Accept: image/png,image/*;q=0.8,*/*;q=0.5
Accept-Language: en-US,en;q=0.5
Accept-Encoding: gzip, deflate
Referer: http://ajax.googleapis.com/ajax/libs.../jquery-ui.css
Connection: keep-alive
If-Modified-Since: Thu, 24 Jan 2013 18:41:38 GMT
Cache-Control: max-age=0

HTTP/1.1 304 Not Modified
Content-Type: image/png
Date: Thu, 02 May 2013 01:54:01 GMT
Expires: Fri, 02 May 2014 01:54:01 GMT
Cache-Control: public, max-age=31536000
x-content-type-options: nosniff
Server: sffe
x-xss-protection: 1; mode=block
----------------------------------------------------------

Do you know how to modify MAMP setting so I can get JSON encoded data?
I also tried JSON.stringify(data); to get rid of the brackets and that didn't work.
Thanks, ]]> Database jrough http://board.phpbuilder.com/showthread.php?10389589-Jquery-AJAX-response-from-PHP-has-brackets-around-the-JSON-object issue selecting records using LEFT OUTER JOIN. results not ignoring blank records http://board.phpbuilder.com/showthread.php?10389561-issue-selecting-records-using-LEFT-OUTER-JOIN.-results-not-ignoring-blank-records&goto=newpost Mon, 29 Apr 2013 23:39:50 GMT dbcon1 ->query("SELECT tbl_merchant.merchantname, tbl_questions.projectid, tbl_questions.merchantid, tbl_questions.question, tbl_questions.date FROM tbl_questions LEFT OUTER JOIN tbl_merchant ON tbl_merchant.uniquemerchantid = tbl_questions.merchantid WHERE tbl_questions.projectid = '$this->projectId' "); ---------------------------- part of the output Array ( [0] => Array ( [merchantname] => Cakewalk [projectid] => 096675edc895d5d03667e15c47d94e6651559e5e8ec36 [merchantid] => 666ee17c24f8c73d25be1dbf2e85ea6951537ab7da5f4 [question] => 1-0How big is your kitchen? [date] => 2013-04-26 11:14:00 ) [1] => Array ( [merchantname] => Borland [projectid] => 096675edc895d5d03667e15c47d94e6651559e5e8ec36 [merchantid] => ecb6bfe5ae52b191689adc1e41cd875c51733f8108552 [question] => 2-1 are there tiles installed in your kitchen and when where they installed? [date] => 2013-04-26 11:14:22 ) [2] => Array ( [merchantname] => Borland [projectid] => 096675edc895d5d03667e15c47d94e6651559e5e8ec36 [merchantid] => ecb6bfe5ae52b191689adc1e41cd875c51733f8108552 [question] => 3-2 more test questions and answerthere tiles installed in your kitchen and when where they installed? [date] => 2013-04-26 11:14:41 ) [3] => Array ( [merchantname] => Microsoft [projectid] => 096675edc895d5d03667e15c47d94e6651559e5e8ec36 [merchantid] => [question] => 4-3 replay from the person posted the project 1 [date] => 2013-04-28 16:24:25 ) [4] => Array ( [merchantname] => Adobe [projectid] => 096675edc895d5d03667e15c47d94e6651559e5e8ec36 [merchantid] => [question] => 4-3 replay from the person posted the project 1 [date] => 2013-04-28 16:24:25 ) [5] => Array ( [merchantname] => [projectid] => 096675edc895d5d03667e15c47d94e6651559e5e8ec36 [merchantid] => [question] => 4-3 replay from the person posted the project 1 [date] => 2013-04-28 16:24:25 )]]> Hello everybody,

Problem with the following statement, uniquemerchantid in some instance is blank but as you can see from the output i copy/pasted at the bottom its repeating the results due to empty fields.

Any help you can give me would be greatly appreciated.

$stmt = $this->dbcon1 ->query("SELECT
tbl_merchant.merchantname,
tbl_questions.projectid,
tbl_questions.merchantid,
tbl_questions.question,
tbl_questions.date
FROM tbl_questions
LEFT OUTER
JOIN tbl_merchant
ON tbl_merchant.uniquemerchantid = tbl_questions.merchantid
WHERE tbl_questions.projectid = '$this->projectId' ");

----------------------------
part of the output
Array
(
[0] => Array
(
[merchantname] => Cakewalk
[projectid] => 096675edc895d5d03667e15c47d94e6651559e5e8ec36
[merchantid] => 666ee17c24f8c73d25be1dbf2e85ea6951537ab7da5f4
[question] => 1-0How big is your kitchen?
[date] => 2013-04-26 11:14:00
)

[1] => Array
(
[merchantname] => Borland
[projectid] => 096675edc895d5d03667e15c47d94e6651559e5e8ec36
[merchantid] => ecb6bfe5ae52b191689adc1e41cd875c51733f8108552
[question] => 2-1 are there tiles installed in your kitchen and when where they installed?
[date] => 2013-04-26 11:14:22
)

[2] => Array
(
[merchantname] => Borland
[projectid] => 096675edc895d5d03667e15c47d94e6651559e5e8ec36
[merchantid] => ecb6bfe5ae52b191689adc1e41cd875c51733f8108552
[question] => 3-2 more test questions and answerthere tiles installed in your kitchen and when where they installed?
[date] => 2013-04-26 11:14:41
)

[3] => Array
(
[merchantname] => Microsoft
[projectid] => 096675edc895d5d03667e15c47d94e6651559e5e8ec36
[merchantid] =>
[question] => 4-3 replay from the person posted the project 1
[date] => 2013-04-28 16:24:25
)

[4] => Array
(
[merchantname] => Adobe
[projectid] => 096675edc895d5d03667e15c47d94e6651559e5e8ec36
[merchantid] =>
[question] => 4-3 replay from the person posted the project 1
[date] => 2013-04-28 16:24:25
)

[5] => Array
(
[merchantname] =>
[projectid] => 096675edc895d5d03667e15c47d94e6651559e5e8ec36
[merchantid] =>
[question] => 4-3 replay from the person posted the project 1
[date] => 2013-04-28 16:24:25
) ]]> Database robinson http://board.phpbuilder.com/showthread.php?10389561-issue-selecting-records-using-LEFT-OUTER-JOIN.-results-not-ignoring-blank-records <![CDATA[[RESOLVED] Two tables and two queries but I have an issue]]> http://board.phpbuilder.com/showthread.php?10389507-RESOLVED-Two-tables-and-two-queries-but-I-have-an-issue&goto=newpost Wed, 24 Apr 2013 16:00:26 GMT ' . $row['name'] . ' '; } ; $result = mysql_query ("SELECT * FROM rooms WHERE (hid = '$hid') AND rid NOT IN (SELECT rid FROM bookings WHERE (hid = '$hid') AND ((startdate >= ".$start->getTime()." OR enddate > ".$start->getTime().") AND (startdate < ".$end->getTime().")))"); $num_rows = mysql_num_rows($result); echo "$num_rows Rows"; mysql_free_result ($result); // Free up the resources. mysql_close(); --------- If anyone has any ideas on how to make it work with the hotel name and available rooms showing underneath I would be very pleased. Thank you for looking Have a great day and an even better one if you can help]]> Hi All

It would be great if someone can help.

I am building a very simple booking system for a group of small hotels. I have three tables one called hotel, one called rooms and one called bookings. Each hotel has an id called hid and each room in every hotel has the individual hotel id and individual room id called rid. When someone makes a booking it goes into the bookings table. When selected the idea is to show how many rooms are available in each hotel by means of filling out a quick form with $d $m $y and the end date of the vacation being $d1 $m1 $y1. i am trying to show each hotel and number of rooms available in the at hotel. I hope that makes sense.

So the list should look like Devon Hotel 3 rooms available Cary Hotel 2 rooms available.

When I break the code down each bit works but when I put it together the problem I have is it shows all the hotels but returns the words 0 rows. This is because the second query cant take the id hid from the first query. Here is the code

PHP Code:
include 'config.php';
include 'date.class.php';
$start = new Date(false ,$d, $m, $y);
$end = new Date(false ,$d1, $m1, $y1);
$query = "SELECT * FROM `hotel`ORDER BY RAND()";        
$result = mysql_query ($query); // Run the query.
while ($row = mysql_fetch_array($result, MYSQL_ASSOC))
 {
    echo '
        <h2>' . $row['name'] . '</h2>
    ';
}
;
$result = mysql_query ("SELECT * FROM rooms WHERE (hid = '$hid') AND rid NOT IN (SELECT rid FROM bookings WHERE (hid = '$hid') AND ((startdate >= ".$start->getTime()." OR enddate > ".$start->getTime().") AND (startdate < ".$end->getTime().")))");
$num_rows = mysql_num_rows($result);

echo "$num_rows Rows";

mysql_free_result ($result); // Free up the resources.    

mysql_close(); 
If anyone has any ideas on how to make it work with the hotel name and available rooms showing underneath I would be very pleased.

Thank you for looking

Have a great day and an even better one if you can help ]]> Database chrispos http://board.phpbuilder.com/showthread.php?10389507-RESOLVED-Two-tables-and-two-queries-but-I-have-an-issue <![CDATA[echo $_session['first name'] problems]]> http://board.phpbuilder.com/showthread.php?10389499-echo-_session-first-name-problems&goto=newpost Wed, 24 Apr 2013 06:12:35 GMT --------- to work, HTML: --------- Kamikazi-Studio
Kamikazi-Studio

Welcome, you have 0 Photos in your gallery click here to upload one.

 

When you have uploaded some photos you can have one as your image for your member page. This will also be the album cover which other members will see first.

 

Please remember that nudity or racist images are banned from this site, any use of such images will result in your account bieng banned from this site as well.

 

 

 

 

 


Your most recent comments

 

comment

 

 

comment

 

 

comment

 

 

 

 

 

 


Change your Password
Request a new Username

Change your Email Address

Logout

Your Comments (New Feature)

Your Album

Support

Contact Us

Rules of this site

 

 
--------- and i cant get it to respond however sesion id responds to me when i print_r. if anyone can have a look into why this might not be taken into account i would greatly appreciate it. Thank you.]]> Hi there,

(sorry if posted in wrong topic ive been awake for 18 hours lookin into this problem and others which i have now fixed but this one i cant figure out.)

Basicly i am trying to get:
PHP Code:
                <div class="content_header_01">
                <?php 
                echo  "Welcome " ;$_SESSION['first_name'];
                ?>
                </div>
to work,

<full page here>
HTML Code:
                <?php
                        session_start();
                        if(!session_is_registered($first_name)){
                        header("location:members_area.html");
                        }
                ?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
        <head>
                <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
                <title>Kamikazi-Studio</title>
                <link href="templatemo_style.css" rel="stylesheet" type="text/css" />
        </head>
<body>
        <div id="templatemo_container">
                <div id="templatemo_top_panel"> 
                        <div id="top_panel_ls">
                                <div id="templatemo_site_title">Kamikazi-Studio</div>
                        </div>

      <div id="top_panel_rs">
            <div id="search_section">
                <form action="#" method="get">
                    <input type="text" name="q" size="10" id="searchfield" title="searchfield" />
                  <input type="submit" name="Search" value="Search" alt="Search" id="searchbutton" title="Search" />
                </form>
                    <div class="cleaner"></div>
            </div>
           
            <div id="templatemo_menu">
                <ul>               
                    <li><a href="index.html" class="current">Home</a></li>
                    <li></li>
                    <li><a href="#"><span></span>Albums</a></li>
                    <li><a href="register.html"><span></span>Register</a></li>
                    <li></li>
                </ul> 
                <div class="cleaner"></div>       
            </div> <!-- end of menu -->

            <div class="cleaner"></div>
          </div>   
    </div> <!-- end of top _panel -->
   
    <div id="templatemo_banner">
   
        <div id="banner_header_01">Members Area</div>
        <div id="banner_header_02">Just for you</div>
        <div id="banner_text">
            <p>Update your personal details, passwords or even just view your comments you have made recently here.<br />
            </p>
            <div class="rc_btn_01"></div>
        </div>
    </div>        <!-- end of banner -->
   
    <div id="ct"></div>
    <div id="templatemo_content">

        <div id="content_left">
            <div class="content_left_280_section margin_right_40">
              <div class="content_header_01">
                  <?php
                      echo  "Welcome ";$_SESSION['first_name'];
                  ?>
              </div>   
                <p align="justify">Welcome, you have 0 Photos in your gallery<strong> click here </strong>to upload one.</p>
                <p align="justify">&nbsp;</p>
                <p align="justify">When you have uploaded some photos you can have one as your image for your member page. This will also be the album cover which other members will see first. </p>
                <p align="justify">&nbsp;</p>
                <p align="justify">Please remember that nudity or racist images are banned from this site, any use of such images will result in your account bieng banned from this site as well.</p>
                <p align="justify">&nbsp;</p>
                <p align="justify">&nbsp;</p>
                <p align="justify">&nbsp;</p>
                <p align="justify">&nbsp;</p>
                <p align="justify">&nbsp;</p>
                <p align="justify"><br />
                </p>
                <div class="cleaner"></div>
                <div class="rc_btn_01"></div> 
                <div class="cleaner"></div>
            </div>
            <div class="content_left_280_section margin_right_40">
              <div class="content_header_01">Your most recent comments</div>
              <p align="justify">&nbsp;</p>
              <p align="justify">comment</p>
              <p align="justify">&nbsp;</p>
              <hr />
              <p align="justify">&nbsp;</p>
              <p align="justify">comment</p>
              <p align="justify">&nbsp;</p>
              <hr />
              <p align="justify">&nbsp;</p>
              <p align="justify">comment</p>
              <p align="justify">&nbsp;</p>
              <p align="justify">&nbsp;</p>
              <p align="justify">&nbsp;</p>
              <p align="justify">&nbsp;</p>
              <p align="justify">&nbsp;</p>
              <p align="justify">&nbsp;</p>
              <p align="justify"><br />
              </p>
              <div class="cleaner"></div>
              <div class="rc_btn_01"></div>
              <div class="cleaner"></div>
            </div>
        </div>
        <!-- end of content left -->
       
        <div id="content_right"><!-- end of news section -->
            <div class="content_right_section">
              <p>Change your Password<br />
              Request a new Username</p>
              <p>Change your Email Address</p>
              <p><a href="logout.php">Logout</a></p>
              <hr />
              <p>Your Comments (New Feature)</p>
              <p>Your Album              </p>
              <hr />
              <p>Support</p>
              <p>Contact Us</p>
              <p>Rules of this site</p>
              <p>&nbsp;</p>
                <form action="#" method="get">
                </form>
                <div class="cleaner"></div>
            </div>
           
            <div class="margin_bottom_20 border_bottom"></div>
            <div class="margin_bottom_20"></div>
           
            <div class="content_right_section"></div>
       
            <div class="cleaner_h30">&nbsp;</div>
        </div> <!-- end of content right -->       
            <div class="cleaner"></div>
   
        </div> <!-- end of content -->
        <div id="cb"></div>
   
    <div id="templatemo_footer">
    Copyright © 2013 <a href="#">INSERT COPYRIGHT HERE</a></div> <!-- end of footer -->

</div> <!-- end of container -->
</body>
</html>
and i cant get it to respond however sesion id responds to me when i print_r.

if anyone can have a look into why this might not be taken into account i would greatly appreciate it.

Thank you. ]]> Database deadkamikazi http://board.phpbuilder.com/showthread.php?10389499-echo-_session-first-name-problems