StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POMember function Row
primarykey
Id
7033411
data
AcceptedAnswerId
7034877
AnswerCount
2
ClosedDate
CommentCount
2
CommunityOwnedDate
CreationDate
2011-08-11T21:58:12.207
FavoriteCount
0
LastActivityDate
2011-08-12T04:45:32.280
LastEditDate
2011-08-12T04:45:32.280
LastEditorUserId
1244239
OwnerUserId
1244239
ParentId
0
PostTypeId
1
Score
0
ViewCount
127
LastEditorDisplayName
text
Body
I tried running the query in my script and receiving this message. Anyone know why AND how to fix it. Fatal error: Call to a member function row() on a non-object <pre><code>$query_str = "SELECT MAX(userID) FROM kowmanager_users"; $this->db->query($query_str); $row = $query->row(); $userID = $row->userID; </code></pre> Edit: I found the syntax for this here: <a href="http://codeigniter.com/user_guide/database/active_record.html#select" rel="nofollow">http://codeigniter.com/user_guide/database/active_record.html#select</a> And came up with this for my needs but when I ran the script it gave me a 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 'Object' at line 1 Filename: /home/xtremer/public_html/kowmanager/models/user_model.php <pre><code>$this->db->select_max('userID'); $query_str = $this->db->get('kowmanager_users'); $rows = $this->db->query($query_str); $userID = $rows->userID; $userID = $userID + 1; </code></pre> Edit 2: For some reason the update isn't running. <pre><code> $query_str = "INSERT INTO kowmanager_users (username, password, password2, email, firstName, lastName, accessLevelID) VALUES (?, ?, ?, ?, ?, ?, ?)"; $this->db->query($query_str, array($username, $password[0], $password[1], $email, $firstName, $lastName, '1',)); $id = $this->db->insert_id(); $this->db->select_max('userID'); $query = $this->db->get('kowmanager_users'); $row = $query->row(); $userID = $row->userID; echo $userID; echo " "; $userID = $userID + 1; echo $userID; $data = array('userID' => $userID); $where = "id = '".$id."'"; $str = $this->db->update_string('kowmanager_users', $data, $where); </code></pre> Edit: Here's my full page code: <a href="http://pastebin.com/7sJt7V09" rel="nofollow">http://pastebin.com/7sJt7V09</a>
Tags
<php><codeigniter>
Title
Member function Row
singulars
PostAcceptedAnswerId
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USJeff Davidson
UserOwnerUserId
1. USJeff Davidson
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
2. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. COWhat is in `$query`?
 singulars
 PostPostId
 POMember function Row
 UserUserId
 USBrad
2. COIts only going to return the max userID from the query so it'll only be 5 digits like 10001
 singulars
 PostPostId
 POMember function Row
 UserUserId
 USJeff Davidson

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.