CRE Loaded Community

Banner


Board index » Web Design and Development » Contribution Garage

All times are UTC - 5 hours




Post new topic Reply to topic  [ 3 posts ] 
Author Message
 Post subject: SQL syntax error
PostPosted: Wed Oct 13, 2004 1:50 pm 
Offline
CRE Addict
User avatar

Joined: Sun Aug 31, 2003 12:00 am
Posts: 258
Take a look at this bit of code.
I keep getting an SQL error on the querry. Im not seing whats wrong here so I was hoping one of you would.


Code:
             
<?php
$attributes_query = tep_db_query("select * from " . TABLE_PRODUCTS_OPTIONS . " where language_id = '" . (int)$languages_id . "'");
           while ($attributes = tep_db_fetch_array($attributes_query)) {?>
              <tr>
                <td class="fieldKey"><?php echo $attributes["products_options_name"]; ?></td>
                <?php
                $option_values_query = tep_db_query("select pv.products_options_values_id, pv.products_options_values_name from ". TABLE_PRODUCTS_OPTIONS_VALUES . " pv, ". TABLE_PRODUCTS_OPTIONS ." po join " . TABLE_PRODUCTS_OPTIONS_VALUES_TO_PRODUCTS_OPTIONS . " popv on (pv.products_options_values_id = popv.products_options_values_id) where popv.products_options_id = po.products_options_id and popv.products_options_id =" . $attributes["products_options_id"] . " and po.language_id =". (int)$languages_id . " group by products_options_values_id, products_options_values_name");
                echo '<td class="fieldValue">';
                echo '<select name="'.$attributes["products_options_name"].'">';
                echo '<option selected></option>';
                while ($option_values = tep_db_fetch_array($option_values_query)) {
                   echo '<option value="'.$option_values["products_options_values_id"].'">'.$option_values["products_options_values_name"].'</option>';
                }
                echo '</select>'; ?>


Top
 Profile  
 
 Post subject:
PostPosted: Wed Oct 13, 2004 10:21 pm 
Offline
CRE Legend
User avatar

Joined: Sun Nov 09, 2003 1:00 am
Posts: 7258
Location: Baconton, GA USA
What kind of SQL query error?

David

_________________
My CRE Loaded FAQ List
CRE Loaded Hosting


Top
 Profile  
 
 Post subject:
PostPosted: Thu Oct 14, 2004 2:09 pm 
Offline
CRE Addict
User avatar

Joined: Sun Aug 31, 2003 12:00 am
Posts: 258
Whoops, a SYNTAX error.


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 3 posts ] 

Board index » Web Design and Development » Contribution Garage

All times are UTC - 5 hours


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron
It is currently Thu Feb 09, 2012 4:57 am
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group

Login

Top Listing

1. Cart2Cart - Shopping...
    Category: Shopping Cart Database Conversion Scripts
    
2. Points & Rewards PLUS!...
    Category: Add-Ons
    
3. Configuration Server...
    Category: Fixes
    
4. Credit Card with CCV
    Category: Payment Modules
    
5. CC7333_ATS
    Category: Templates
    
Show more...

Follow Us on Twitter

An error occurred

Oops, an error seems to have occurred. We're sorry for any inconvenience this might have caused. If the error persists, feel free to tell us about it.

CRE Loaded Community Chat hosted by CRE Loaded.

Join now


Chat about what's on your mind. More about public chats.


© CRE Loaded is a product of Chain Reaction Ecommerce, Inc. Usage & Privacy Policy