Quick SQL question-SOLVED
public function get_user($email) {
global $db;
$result=$db->query("SELECT * FROM hotel WHERE primaryEmail='$email'") or $result=$db->query("SELECT * FROM vendor WHERE primaryEmail='$email'");
$result_set=$db->fetch_array($result);
$this->user_id=$result_set['user_id'];
$this->email=$result_set['email'];
$this->user_name=$result_set['user_name'];
}
-
Mkj -
[ 1 ] Thanks - 1 reply
{{ DiscussionBoard.errors[7597539].message }}-
PHPSpaZ -
Thanks
{{ DiscussionBoard.errors[7597598].message }} -
-
-
KirkMcD -
[ 1 ] Thanks - 2 replies
{{ DiscussionBoard.errors[7598376].message }}-
PHPSpaZ -
Thanks - 1 reply
{{ DiscussionBoard.errors[7598439].message }}-
capsoon -
[ 1 ] Thanks - 1 reply
{{ DiscussionBoard.errors[7599699].message }}-
PHPSpaZ -
Thanks
{{ DiscussionBoard.errors[7602169].message }} -
-
-
-
PHPSpaZ -
Thanks
{{ DiscussionBoard.errors[7602158].message }} -
-