custom inventory look

[slingman]

i need to have a page that shows the inventory of one specific item but in a very large font

ie an ezpage with the sql query embedded that just i code the html around it

anyone point me in the direction of how to structure the sql query :)

[dbltoe]

a google search of "sql queries in php" yields this.

Is this your only product?

[slingman]

re:only product - no but only have a few and its the main product

[dbltoe]

Is this specifically something NOT contained in the product description?

[slingman]

no its just the products inventory

the idea is basically to have an ezpage showing a "counter" of how much stock is left on this one item - the counter being the inventory level with the font size or form style being very large

[dbltoe]

The "counter" is already there by default as the quantity. You could have a specific css file for that product's page to change the quantity font when that page is called.

[dbltoe]

The CSS_read_me.txt in the includes/templates/template_default/css folder tells how you would name the special stylesheet.

[slingman]

i´´m not worried about the size, i´´m trying to get the coding into a seperate, effectively static, page - ie an ezpage

ie something like this (very basic) that i can put into the contents of an ezpage

"Hurry we only have:

<div class"100pxfontsize">
<?php echo get stock level for product #id1?></div>

units of this product left"

[seethrou]

By search there is a topic about this, please refer to it.
PHP inside ezpages

.

[slingman]

thanks but i still dont know how to pull the inventory data from the db and display it ;)