Changeset 32 for branches/3
- Timestamp:
- Oct 14, 2008, 9:06:32 PM (16 years ago)
- Location:
- branches/3
- Files:
-
- 2 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/3/class/database.php
r31 r32 21 21 $this->LastQuery = "SELECT ".$What." FROM `".$this->Prefix.$Table."` WHERE ".$Condition; 22 22 $resul = $this->query($this->LastQuery); 23 echo $this->error;23 if ($this->error <> '') $this->error.': '.$this->LastQuery; 24 24 25 25 $this->LastNumRows = $resul->num_rows; -
branches/3/frontend.php
r31 r32 70 70 { // BEGIN function WriteOnlineUsers 71 71 global $database; 72 $Query = $database->select('UserOnline', ' *,count(*) as count_online_user,(SELECT Name FROM User WHERE User.Id = UserOnline.User) as Name');72 $Query = $database->select('UserOnline', 'count(*) as count'); 73 73 if ($database->LastDataSet) { 74 echo '<p>'.ONLINE_USERS; 74 echo '<p>'.ONLINE_USERS.$DbRow['count']; 75 $Query = $database->select('UserOnline', '*,(SELECT Name FROM User WHERE User.Id = UserOnline.User) as Name'); 75 76 while($DbRow = $Query->fetch_array()) 76 77 { 77 echo ''.$DbRow['Name'].' ';78 echo ''.$DbRow['Name'].'<br />'; 78 79 } 79 80 echo '</p>';
Note:
See TracChangeset
for help on using the changeset viewer.