I have been messing around with osCommerce for the last day or so. I'm not highly skilled in .php, but I have managed to get around and customize myself.<br /><br />I am having trouble trying to find a spot that I know I've probably seen while going through the files, so I figured I'd ask here. All I want is the file that it would be in, not how to do it <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/biggrin.gif" style="vertical-align:middle" emoid="
" border="0" alt="biggrin.gif" /> <br /><br />After I have clicked on a link in "Categories" it pulls up the items for that "Category" and at the top of the items is:<br /><br />"Let's See What We Have Here"<br /><br />Where is that so I can edit it?<br /><br />Thanks in advance!<!--content-->
errr... Never mind <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/goof.gif" style="vertical-align:middle" emoid=":goof:" border="0" alt="goof.gif" /> <br /><br /> <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/tchrocks!.gif" style="vertical-align:middle" emoid=":tchrocks!:" border="0" alt="tchrocks!.gif" /><!--content-->
Glad you found it out.<!--content-->
Thank you <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/clapping.gif" style="vertical-align:middle" emoid=":clapping:" border="0" alt="clapping.gif" /> <br /><br />I figured after I had posted I would *of course* find it myself <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/blink.gif" style="vertical-align:middle" emoid=":blink:" border="0" alt="blink.gif" /><!--content-->
That's the way it always works. <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/wink.gif" style="vertical-align:middle" emoid="
" border="0" alt="wink.gif" /><!--content-->
I've been ironing out the wrinkles that I have.. I keep running into this error... Any ideas?<br /><br />1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-20, 20' at line 1<br /><br />select o.orders_id, o.customers_name, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total from orders o left join orders_total ot on (o.orders_id = ot.orders_id), orders_status s where o.orders_status = s.orders_status_id and s.language_id = '1' and ot.class = 'ot_total' order by o.orders_id DESC limit -20, 20<br /><br />[TEP STOP]<br /><br />So far so good, but now this is more than confusing to me <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/blink.gif" style="vertical-align:middle" emoid=":blink:" border="0" alt="blink.gif" /><!--content-->
<img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/sad.gif" style="vertical-align:middle" emoid="
" border="0" alt="sad.gif" /><!--content-->
Was that a bump?<br /><br />Try changing "DESC limit -20, 20" <br /><br />to <br /><br />"DESC limit 20"<!--content-->
" border="0" alt="biggrin.gif" /> <br /><br />After I have clicked on a link in "Categories" it pulls up the items for that "Category" and at the top of the items is:<br /><br />"Let's See What We Have Here"<br /><br />Where is that so I can edit it?<br /><br />Thanks in advance!<!--content-->errr... Never mind <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/goof.gif" style="vertical-align:middle" emoid=":goof:" border="0" alt="goof.gif" /> <br /><br /> <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/tchrocks!.gif" style="vertical-align:middle" emoid=":tchrocks!:" border="0" alt="tchrocks!.gif" /><!--content-->
Glad you found it out.<!--content-->
Thank you <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/clapping.gif" style="vertical-align:middle" emoid=":clapping:" border="0" alt="clapping.gif" /> <br /><br />I figured after I had posted I would *of course* find it myself <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/blink.gif" style="vertical-align:middle" emoid=":blink:" border="0" alt="blink.gif" /><!--content-->
That's the way it always works. <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/wink.gif" style="vertical-align:middle" emoid="
" border="0" alt="wink.gif" /><!--content-->I've been ironing out the wrinkles that I have.. I keep running into this error... Any ideas?<br /><br />1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-20, 20' at line 1<br /><br />select o.orders_id, o.customers_name, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total from orders o left join orders_total ot on (o.orders_id = ot.orders_id), orders_status s where o.orders_status = s.orders_status_id and s.language_id = '1' and ot.class = 'ot_total' order by o.orders_id DESC limit -20, 20<br /><br />[TEP STOP]<br /><br />So far so good, but now this is more than confusing to me <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/blink.gif" style="vertical-align:middle" emoid=":blink:" border="0" alt="blink.gif" /><!--content-->
<img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/sad.gif" style="vertical-align:middle" emoid="
" border="0" alt="sad.gif" /><!--content-->Was that a bump?<br /><br />Try changing "DESC limit -20, 20" <br /><br />to <br /><br />"DESC limit 20"<!--content-->