Help Please query a query on the same page or search page.

[richardandrewle]

I am doing a site and I need the content to be dynamic like so I can query the data base and query the content to display but when it comes to displaying the results instantly on the same page when the link is click from the queried list on the side. I am clueless as to what to do in order to achieve and use a page template to display the content. (like search results.)

Here is the link :

http://www.cigaradvisor.com/brands.cfm

thank you for any help that you can give ahead of time.

Blessings,
richard lee

[laserlight]

You are using PHP? Also, please read my link on how to ask smart questions.

[richardandrewle]

yes I am using php 5 and mysql 4.1 sorry. I read alot of you article.

I've search mysql and php and forum and manuals and I can't find out how to do the above.

1. I can get data from database.

2. I can display the results on page.

3. I can create links etc with results.

4. but I can't link to knew results from the queried results.

5. thus I can't get results to display on same page.

(I research subqueries a lot and that wasn't what I was looking for.)

[richardandrewle]

here is the page http://www.askthecigarguys.com/dev/

[richardandrewle]

here is the code:

<?
$databasename='borlee2_cbrands'; // Name of the database
$tablename='cigars'; // Name of the table
$mysqladd='mysql4.freehostia.com'; // Address to the MySQL Server - Usually localhost but could be an IP address
$mysqluser='***'; // Your MySQL UserName
$mysqlpass='***'; // Your MySQL Password

//CONNECT TO MYSQL
$link=mysql_connect($mysqladd, $mysqluser, $mysqlpass) or die('Could not connect to database: ' . mysql_error());

//CONNECT TO DATABASE
mysql_select_db($databasename, $link) or die('Could not connect to table: ' . mysql_error());

//GET THE TABLE DATA
//you can edit the $sql= line to any sort of SELECT statement to get the desired results
//e.g. "SELECT FROM ".$tablename." WHERE name LIKE 'a%' ORDER BY name desc";
//the example would give all in table with a name that started with a or A and order the results alphabetically
$results=array();
//$sql="SELECT FROM ".$tablename."";
$sql="SELECT * FROM ".$tablename." WHERE letter LIKE 'a'";
$result = mysql_query($sql, $link) or die('Error: ' . mysql_error());
while($a_row = mysql_fetch_array($result, MYSQL_ASSOC)) array_push($results, $a_row);

if(count($results)){
//DISPLAY THE DATA
foreach($results as $r){
echo('<li><a href="'.$r[link].'"><h2>'.$r[name].'</h2></a> - '.$r[short_info].' - '.$r[special].'<br /><li><a href="'.$r[link].'"><img src="'.$r[image_link].'" /></a></li>'

	);
}

}else{
echo('Sorry - no results found');
}

?>
</div>
<div style="float:left; margin-left: 60px; margin-top:15px;">
<?
$databasename='borlee2_cbrands'; // Name of the database
$tablename='cigars'; // Name of the table
$mysqladd='mysql4.freehostia.com'; // Address to the MySQL Server - Usually localhost but could be an IP address
$mysqluser='***'; // Your MySQL UserName
$mysqlpass='***'; // Your MySQL Password

//CONNECT TO MYSQL
$link=mysql_connect($mysqladd, $mysqluser, $mysqlpass) or die('Could not connect to database: ' . mysql_error());

//CONNECT TO DATABASE
mysql_select_db($databasename, $link) or die('Could not connect to table: ' . mysql_error());

//GET THE TABLE DATA
//you can edit the $sql= line to any sort of SELECT statement to get the desired results
//e.g. "SELECT FROM ".$tablename." WHERE name LIKE 'a%' ORDER BY name desc";
//the example would give all in table with a name that started with a or A and order the results alphabetically
$results=array();
$sql="SELECT FROM ".$tablename."";
//$sql="SELECT * FROM ".$tablename." WHERE letter LIKE 'a'";
$result = mysql_query($sql, $link) or die('Error: ' . mysql_error());
while($a_row = mysql_fetch_array($result, MYSQL_ASSOC)) array_push($results, $a_row);

if(count($results)){
//DISPLAY THE DATA
foreach($results as $r){
echo('<li><a href="single.php?id='.$r[key].'">'.$r[name].'</a> </li>');
}
}else{
echo('Sorry - no results found');
}

?>

</div>