Value is not carrying to the variable

**StevenHu** · Oct 8, 2008 10:31

The following syntax is not working:

PHP Code:


include_once ("../includes_php/header.".$Brand.".php");

I want to insert the $Brand variable so the correct header will appear. If I insert the actual variable, then the header DOES appear. Here is more of the code:

PHP Code:


$plq = mysql_query 

(    "SELECT Photo, PartNo, ItemName, MSRP, Descr, Brand, DateCreated

    FROM aeproducts

    $where" 

); 



$Brand = $plq['Brand'];



$message = array(

    "<p class='msgbanner1'><strong>ERROR. Please try again another time.</strong></p>",

    "<p class='msgbanner1'><strong>Sorry, I cannot find that information. Please check your typing and try again.</strong></p>",

    "<p class='msgbanner2'>You searched for <strong>$text</strong></p>",

    "<p class='msgbanner2'><strong>Please try again without using punctuation.</strong></p>",

    "<p class='msgbanner2'>30 random items shown. Please specify your part(s) by using the Search box above.</p>",

    "<p class='msgbanner2'>Too many results returned. No thumbnails shown.</p>"



    );

?>



<table id="main">

    <tr><td colspan="2" id="header">

<!-- **** HEADER IMAGE ******* -->



<?php

include_once ("../includes_php/header.".$Brand.".php"); 

?>

How do I make sure the $Brand content goes from the query into the include line? I've tried several different possibilities of single and double quotes, with and without the concatenation. Warning message:

Warning: include_once(../includes_php/header..php) [function.include-once]: failed to open stream: No such file or directory

Again, adding the actual value in place of $Brand makes the script work.

Thanks,
Steve

**Jake Arkinstall** · Oct 8, 2008 10:38

The actual value of $Brand is... well, nothing.

You can't just treat a query like an array. You need to turn it into one:

PHP Code:


$plqq = mysql_query("SELECT Photo, PartNo, ItemName, MSRP, Descr, Brand, DateCreated FROM aeproducts $where");

$plq = mysql_fetch_array($plqq);

$Brand = $plq['Brand'];

$message = array( 

    "<p class='msgbanner1'><strong>ERROR. Please try again another time.</strong></p>", 

    "<p class='msgbanner1'><strong>Sorry, I cannot find that information. Please check your typing and try again.</strong></p>", 

    "<p class='msgbanner2'>You searched for <strong>$text</strong></p>", 

    "<p class='msgbanner2'><strong>Please try again without using punctuation.</strong></p>", 

    "<p class='msgbanner2'>30 random items shown. Please specify your part(s) by using the Search box above.</p>", 

    "<p class='msgbanner2'>Too many results returned. No thumbnails shown.</p>" 



    ); 

echo <<<HTML



<table id="main"> 

    <tr>

        <td colspan="2" id="header"> 

            <!-- **** HEADER IMAGE ******* --> 

HTML;

include_once ('../includes_php/header.'.$Brand.'.php');

?>

Off Topic:

By the way, table-based designs have been out the window for years. Using <div> tags with CSS styling is the best, and most powerful, way of building HTML designs

**StevenHu** · Oct 8, 2008 10:45

I neglected to build an array from the query first! ARRRRRRRgh.

Thanks!
Steve

User Tag List

Thread: Value is not carrying to the variable

Thread Tools

Display

Value is not carrying to the variable

Bookmarks

Bookmarks

Posting Permissions