I use also use dreamweaver but I usually just add PHP manunally to get info
from the database.
<?php
# FileName="Connection_php_mysql.htm"
# Type="MYSQL"
# HTTP="true"
$hostname_conn = "999.999.999.999";
$database_conn = "database;
$username_conn = "username";
$password_conn = "password";
$connection = mysql_connect($hostname_conn, $username_conn, $password_conn) or
trigger_error(mysql_error(),E_USER_ERROR);
mysql_select_db ($database_conn);
After connecting
Use a query to GET the data
$newsQuery = "SELECT * FROM news WHERE title LIKE '%$searchKeyword%' " ;
$newsResult = mysql_query($newsQuery) or die('Query failed: ' .
mysql_error());
Then display the data
<div id="main">
<div id="main_content">
<div id="mainPageTitle">
<h1> News </h1>
</div>
<?php $count = 0; while ($line = mysql_fetch_object($newsResult)) {
?>
<br /> <br />
<div id="subHeading">
<h2><?php echo $line->title; ?></h2>
</div>
<?php echo $line->image; ?>
<br /> <br />
<?php echo $line->description; ?>
<br /> <br />
<?php $count ++;}; ?>
</div>
<!--end of main content -->
Rafael <[EMAIL PROTECTED]> wrote: I have over
4,000 products in mySQL database, and I've successfully
connected to mySQL in Dreamweaver 8. My product database, includes
description of the product, price, image name of the products, etc.
Obviously I don't want to copy and paste every single product image,
description, price, on my site. How can I use queries in Dreamweaver
so that I can pull all that information directly off my database?
---------------------------------
Sponsored Link
$420,000 Mortgage for $1,399/month - Think You Pay Too Much For Your
Mortgage? Find Out!
[Non-text portions of this message have been removed]
