advanced_search.php ERROR

[adidaxx]

Hi to all,

 

- i have osCommerce Online Merchant v2.2 RC2 , STS, Extra fields, UltraPics+lightbox;

- if i whant to search something i put in the search fields, and its working, ....but when i whant clik on advance search i get this error:

Parse error: syntax error, unexpected T_STRING in /home/xxxxx/public_html/catalog/advanced_search.php on line 236

 

soo what is to line 236:

<?php
// START: Extra Fields Contribution Search Fields 1.0
$pef_fields = tep_db_query("SELECT products_extra_fields_id, products_extra_fields_name FROM " . TABLE_PRODUCTS_EXTRA_FIELDS . " WHERE (languages_id = 0 OR languages_id = " . (int)$languages_id . ") AND products_extra_fields_status ORDER BY products_extra_fields_order");
ORDER BY products_extra_fields_order"); [color="#FF0000"] this is line 236[/color]
while ($field = tep_db_fetch_array($pef_fields))
{
?>
		  <tr>
			<td class="fieldKey"><?php echo $field['products_extra_fields_name']; ?></td>
			<td class="fieldValue"><?php echo tep_draw_input_field('pef_'.$field['products_extra_fields_id'], '', 'style="width: 300px"'); ?></td>
		  </tr>
		  <tr>
			<td colspan="2"><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
		  </tr>
<?php
}
// END: Extra Fields Contribution
?>

 

- what is wrong?

- thx for all, for your ideas....

[burt]

Get yourself a text editor that has line numbers. Ultraedit maybe.

 

Then you will know exactly where line 236 is, and the error is on (or near) that line.

[adidaxx]

i now where is line 236, but what's wrong there?

233			  <?php
234	  // START: Extra Fields Contribution Search Fields 1.0
235	  $pef_fields = tep_db_query("SELECT products_extra_fields_id, products_extra_fields_name FROM " .  TABLE_PRODUCTS_EXTRA_FIELDS . "	
	   WHERE (languages_id = 0 OR languages_id = " . (int)$languages_id . ") AND products_extra_fields_status ORDER BY  
	   products_extra_fields_order");
236	  ORDER BY products_extra_fields_order");
237	  while ($field = tep_db_fetch_array($pef_fields))
238	  {
239	   ?>
240			   <tr>
241				<td class="fieldKey"><?php echo $field['products_extra_fields_name']; ?></td>
242				<td class="fieldValue"><?php echo tep_draw_input_field('pef_'.$field['products_extra_fields_id'], '', 'style="width: 300px"'); ?></td>
243			  </tr>
244			  <tr>
245				<td colspan="2"><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
246			  </tr>
246		   <?php
248			  }
249			// END: Extra Fields Contribution
250			 ?>

 

what i have to modify to work?...

sorry i don't put from the start number to lines....

[lastblackjellybean]

Delete what's in line 236. It's just the end of line 235 pasted in again for some reason.

[adidaxx]

YES MAN...i read that lines so many times...and i don't see that..that is good to have some other eye on your code..., thx..yes is working

- i now am off-topic(created by me), but how can add extra info fields to New Product page, i have the fields(in database, and i use that estra fields to product list) where i have to change, or what?; what to be infobox or content box?...

- thx again for your good eye's...