Changeset 10 for trunk/category.php
- Timestamp:
- May 17, 2003, 12:49:14 PM (22 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/category.php
r9 r10 54 54 $page['tab_expand'] = array(); 55 55 $query = 'select id'; 56 $query.= ' from '. $prefixeTable.'categories';56 $query.= ' from '.PREFIX_TABLE.'categories'; 57 57 $query.= ' where id_uppercat is null;'; 58 58 $result = mysql_query( $query ); … … 126 126 // searching the number of favorite picture 127 127 $query = 'select count(*) as count'; 128 $query.= ' from '. $prefixeTable.'favorites';128 $query.= ' from '.PREFIX_TABLE.'favorites'; 129 129 $query.= ' where user_id = '.$user['id'].';'; 130 130 $result = mysql_query( $query ); … … 241 241 $query = 'select id,file,date_available,comment,'; 242 242 $query.= ' author,tn_ext,name,filesize,width,height,cat_id'; 243 $query.= ' from '. $prefixeTable.'images';243 $query.= ' from '.PREFIX_TABLE.'images'; 244 244 $query.= $page['where']; 245 245 $query.= $conf['order_by']; … … 340 340 $vtp->addSession( $handle, 'nb_comments' ); 341 341 $query = 'select count(*) as nb_comments'; 342 $query.= ' from '. $prefixeTable.'comments';342 $query.= ' from '.PREFIX_TABLE.'comments'; 343 343 $query.= ' where image_id = '.$row['id']; 344 344 $query.= ';'; … … 374 374 375 375 $query = 'select id,name,dir,date_dernier'; 376 $query.= ' from '. $prefixeTable.'categories';376 $query.= ' from '.PREFIX_TABLE.'categories'; 377 377 $query.= ' where id_uppercat = '.$page['cat']; 378 378 $query.= ' order by rank;'; … … 398 398 399 399 $query = 'select file,tn_ext'; 400 $query.= ' from '. $prefixeTable.'images';400 $query.= ' from '.PREFIX_TABLE.'images'; 401 401 $query.= ' where cat_id = '.$cat_row['id']; 402 402 $query.= ' order by rand()';
Note: See TracChangeset
for help on using the changeset viewer.