Not sure how to add this query to my database:

Snoboreders · November 4, 2007

Ok, for some reason, I've blanked with phpMyAdmin, and have no idea how to do this:

1) apply the following query to your database:

ALTER TABLE `products` ADD `products_slide_images` TEXT NOT NULL ;

When I select my products table how do I simply add " the above line?

Thanks for the help,

Chris

Snoboreders · November 4, 2007

***Post deleted.

Snoboreders · November 4, 2007

I had trouble with the beginning and very end of the Picture Image Slide Show module

At the very end it says this:

9) go to catalog/popup_image.php and REPLACE the line where the image is drawn with this:

document.writeln('<img src="'+opener.getActiveSlideImage()+'"/>');

</script>

What exactly is a line where the image is drawn? Here is the code from which to find that line.

<?php
/*
 $Id: popup_image.php,v 1.18 2003/06/05 23:26:23 hpdl Exp $

 osCommerce, Open Source E-Commerce Solutions
 http://www.oscommerce.com

 Copyright (c) 2003 osCommerce

 Released under the GNU General Public License
*/

 require('includes/application_top.php');

 $navigation->remove_current_page();

 $products_query = tep_db_query("select pd.products_name, p.products_image from " . TABLE_PRODUCTS . " p left join " . TABLE_PRODUCTS_DESCRIPTION . " pd on p.products_id = pd.products_id where p.products_status = '1' and p.products_id = '" . (int)$HTTP_GET_VARS['pID'] . "' and pd.language_id = '" . (int)$languages_id . "'");
 $products = tep_db_fetch_array($products_query);
?>
<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">
<html <?php echo HTML_PARAMS; ?>>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>">
<title><?php echo $products['products_name']; ?></title>
<base href="<?php echo (($request_type == 'SSL') ? HTTPS_SERVER : HTTP_SERVER) . DIR_WS_CATALOG; ?>">
<script language="javascript"><!--
var i=0;
function resize() {
 if (navigator.appName == 'Netscape') i=40;
 if (document.images[0]) window.resizeTo(document.images[0].width +30, document.images[0].height+80-i);
 self.focus();
}
//--></script>


</head>
<body onload="resize();">
<?php echo tep_image(DIR_WS_IMAGES . $products['products_image'], $products['products_name']); ?>
</body>
</html>
<?php require('includes/application_bottom.php'); ?>

Sorry if these are all "newbie" problems. I thought by now I'd be able to figure this out.

Thanks,

Chris

♥geoffreywalton · November 4, 2007

Nearly didn't read this one as you had 1 reply and the answer once you know it is so simple.

In php myadmin, select your database and select your table.

Now comes the tricky part

Click on sql, paste the sql you have been given into the box replacing

SELECT * FROM `products` WHERE 1

And I'll leave you to work out what to do next

Enjoy

Not sure how to add this query to my database:

Recommended Posts

Snoboreders

Snoboreders

Snoboreders

♥geoffreywalton

Archived

Browse

Activity