StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POI have a problem with mysql and php
primarykey
Id
2783228
data
AcceptedAnswerId
0
AnswerCount
3
ClosedDate
CommentCount
1
CommunityOwnedDate
CreationDate
2010-05-06T17:48:26.070
FavoriteCount
0
LastActivityDate
2010-05-06T18:24:25.603
LastEditDate
2010-05-06T18:00:57.750
LastEditorUserId
187606
OwnerUserId
321725
ParentId
0
PostTypeId
1
Score
0
ViewCount
129
LastEditorDisplayName
text
Body
I have a problem, this is my code: <pre><code> $db = new mysqli("localhost", "root", "", "blah"); $result1 = $db->query("select * from c_register where email = '$eml' and password = '$pass'"); if($result1->fetch_array()) { $auth->createSession(); $_SESSION['user'] = 'client'; promptUser("You have successfully logged in!!!","index.php"); } $db = new mysqli("localhost", "root", "", "blah"); $result2 = $db->query("select * from b_register where email = '$eml' and password = '$pass'"); if($result2->fetch_array()) { $auth->createSession(); $_SESSION['user'] = 'business'; promptUser("You have successfully logged in!!!","index.php"); } $db = new mysqli("localhost", "root", "", "blah"); $result3 = $db->query("select * from g_register where email = '$eml' and password = '$pass'"); if($result3->fetch_array()) { $auth->createSession(); $_SESSION['user'] = 'employee'; promptUser("You have successfully logged in!!!","index.php"); } $db = new mysqli("localhost", "root", "", "blah"); $result4 = $db->query("select * from k_register where email = '$eml' and password = '$pass'"); if($result4->fetch_array()) { $auth->createSession(); $_SESSION['user'] = 'super'; promptUser("You have successfully logged in!!!","index.php"); } else { promptUser("Username/Password do not match. Please try again!!!",""); } </code></pre> Funny enough this code works, but I no that I went about it the wrong way. I am new with php and mysql, so please help. I also tried e.g<code>result4->free();</code> for all the variable that save the data, and I got this error: Fatal error: Call to a member function free() on a non-object in...
Tags
<php><mysql><mysqli>
Title
I have a problem with mysql and php
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USPekka 웃
UserOwnerUserId
1. USmneva
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
3. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. CO@neo: Please do not post "Here's my code, please fix it"-type of questions. Work out where the problem is, post the relevant section of code only, and make exact statements about expected behavior and any error messages you get.
 singulars
 PostPostId
 POI have a problem with mysql and php
 UserUserId
 USTomalak

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.