Mixing
SQL - how to get related values from 2 tables
I have a table which is based on userid which contains user favorite images
I have another table which contains the user name and user id of users
I want to run a query where i insert a name into a query, it then retrieves the userid and uses this userid to search the table of favorites returning the username and the images selected
I'm quite new to SQL so appreciate any help
SELECT *
FROM `atabl_users`
WHERE `name` LIKE 'user to input value'
LIMIT 0 , 30
SELECT *
FROM `atabl_joomgallery_users`
WHERE `uid` =17
ORDER BY `azc6a_joomgallery_users`.`uid` ASC
LIMIT 0 , 30
mysql sql
edited Nov 22 '18 at 9:50
a_horse_with_no_name
301k46458551
asked Nov 22 '18 at 9:32
itye1970itye1970
151212
add a comment |
I have a table which is based on userid which contains user favorite images
I have another table which contains the user name and user id of users
I want to run a query where i insert a name into a query, it then retrieves the userid and uses this userid to search the table of favorites returning the username and the images selected
I'm quite new to SQL so appreciate any help
SELECT *
FROM `atabl_users`
WHERE `name` LIKE 'user to input value'
LIMIT 0 , 30
SELECT *
FROM `atabl_joomgallery_users`
WHERE `uid` =17
ORDER BY `azc6a_joomgallery_users`.`uid` ASC
LIMIT 0 , 30
mysql sql
edited Nov 22 '18 at 9:50
a_horse_with_no_name
301k46458551
asked Nov 22 '18 at 9:32
itye1970itye1970
151212
Please add structure (list of columns) of the atabl_users table to your question
– Joakim Danielson
Nov 22 '18 at 10:20
users table has the following : id name username email The joomgallery table has the following uid uuserid piclist
– itye1970
Nov 22 '18 at 10:23
add a comment |
I have a table which is based on userid which contains user favorite images
I have another table which contains the user name and user id of users
I want to run a query where i insert a name into a query, it then retrieves the userid and uses this userid to search the table of favorites returning the username and the images selected
I'm quite new to SQL so appreciate any help
SELECT *
FROM `atabl_users`
WHERE `name` LIKE 'user to input value'
LIMIT 0 , 30
SELECT *
FROM `atabl_joomgallery_users`
WHERE `uid` =17
ORDER BY `azc6a_joomgallery_users`.`uid` ASC
LIMIT 0 , 30
mysql sql
edited Nov 22 '18 at 9:50
a_horse_with_no_name
301k46458551
asked Nov 22 '18 at 9:32
itye1970itye1970
151212
I have a table which is based on userid which contains user favorite images
I have another table which contains the user name and user id of users
I want to run a query where i insert a name into a query, it then retrieves the userid and uses this userid to search the table of favorites returning the username and the images selected
I'm quite new to SQL so appreciate any help
SELECT *
FROM `atabl_users`
WHERE `name` LIKE 'user to input value'
LIMIT 0 , 30
SELECT *
FROM `atabl_joomgallery_users`
WHERE `uid` =17
ORDER BY `azc6a_joomgallery_users`.`uid` ASC
LIMIT 0 , 30
mysql sql
mysql sql
edited Nov 22 '18 at 9:50
a_horse_with_no_name
301k46458551
asked Nov 22 '18 at 9:32
itye1970itye1970
151212
edited Nov 22 '18 at 9:50
a_horse_with_no_name
301k46458551
asked Nov 22 '18 at 9:32
itye1970itye1970
151212
edited Nov 22 '18 at 9:50
a_horse_with_no_name
301k46458551
edited Nov 22 '18 at 9:50
a_horse_with_no_name
301k46458551
edited Nov 22 '18 at 9:50
a_horse_with_no_name
301k46458551
301k46458551
asked Nov 22 '18 at 9:32
itye1970itye1970
151212
asked Nov 22 '18 at 9:32
itye1970itye1970
151212
asked Nov 22 '18 at 9:32
itye1970itye1970
151212
151212
Please add structure (list of columns) of the atabl_users table to your question
– Joakim Danielson
Nov 22 '18 at 10:20
users table has the following : id name username email The joomgallery table has the following uid uuserid piclist
– itye1970
Nov 22 '18 at 10:23
add a comment |
Please add structure (list of columns) of the atabl_users table to your question
– Joakim Danielson
Nov 22 '18 at 10:20
users table has the following : id name username email The joomgallery table has the following uid uuserid piclist
– itye1970
Nov 22 '18 at 10:23
Please add structure (list of columns) of the atabl_users table to your question
– Joakim Danielson
Nov 22 '18 at 10:20
Please add structure (list of columns) of the atabl_users table to your question
– Joakim Danielson
Nov 22 '18 at 10:20
users table has the following : id name username email The joomgallery table has the following uid uuserid piclist
– itye1970
Nov 22 '18 at 10:23
users table has the following : id name username email The joomgallery table has the following uid uuserid piclist
– itye1970
Nov 22 '18 at 10:23
add a comment |
2 Answers
2
active
oldest
votes
You use JOIN to combine your queries
SELECT j.*
FROM atabl_joomgallery_users j
JOIN atabl_users u ON u.id = j.uuserid
WHERE u.name LIKE ?
Note that LIKE might return several users so if you get a unique user name as input value you can change the where clause to
WHERE u.name = ?
answered Nov 22 '18 at 9:48
Joakim DanielsonJoakim Danielson
9,2783724
i get this error : #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '? LIMIT 0, 30' at line 4
– itye1970
Nov 22 '18 at 9:50
You need to replace ? with a user name (the string you get as input) for example 'john'
– Joakim Danielson
Nov 22 '18 at 9:58
i still get error 1054 - Unknown column 'au.uid' in 'on clause': SELECT * FROM atabl_users au INNER JOIN atabl_joomgallery_users aju ON au.uid = aju.uid WHERE au.name LIKE "fred" AND aju.uid = 17 LIMIT 30
– itye1970
Nov 22 '18 at 10:02
That comment isn't for me, is it? Anyway use single not double quotes around text strings. Also what is the name of the user id column in atabl_users?
– Joakim Danielson
Nov 22 '18 at 10:06
thanks for the help, i need to input the user name and from this user name i need to get the user id and pass this into the table which contains the favorites this will then be used to retrieve the users favorites from the favorites table which users userid .
– itye1970
Nov 22 '18 at 10:11
|
show 7 more comments
If you are requiring all information from two tables, you require an ID that they both share, so that they can be linked (joined) together.
Based on the information you provided, I'm assuming that both tables contain the value "uid" as the user id.
As such, the following query should be used :
"SELECT * FROM atabl_users au INNER JOIN atabl_joomgallery_users aju ON au.uid = aju.uid WHERE au.name LIKE ? AND aju.uid = 17 LIMIT 30"
I've removed the ORDER BY, as you would need a different one. There is no use in ordering by uid if you've specified it as 17.
To explain, we are asking to get all information * from table atable_users, then we're assigning it a shorthand value of au, to make it easier to read later on. We're then joining this table set with another table, based on the two unique values. Then we can refine our search using our WHERE values, and then lastly LIMIT the result set by 30.
answered Nov 22 '18 at 9:42
cmprogramcmprogram
1,194619
I tried but got this error? #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '"SELECT * FROM atable_users au INNER JOIN atable___joomgallery_users aju ON au.uid ' at line 1
– itye1970
Nov 22 '18 at 9:47
@itye1970 I made a spelling error in your table name, and you can see it in the error of the comment you posted. I've amended it now.
– cmprogram
Nov 22 '18 at 9:50
i get this error now #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '? AND aju.uid = 17 LIMIT 30"' at line 1
– itye1970
Nov 22 '18 at 10:04
You have to replace "?" with whatever you were going to input with 'user to input value'. Try replacing ? with a default value that you know exists.
– cmprogram
Nov 22 '18 at 10:06
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53427754%2fsql-how-to-get-related-values-from-2-tables%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
You use JOIN to combine your queries
SELECT j.*
FROM atabl_joomgallery_users j
JOIN atabl_users u ON u.id = j.uuserid
WHERE u.name LIKE ?
Note that LIKE might return several users so if you get a unique user name as input value you can change the where clause to
WHERE u.name = ?
answered Nov 22 '18 at 9:48
Joakim DanielsonJoakim Danielson
9,2783724
i get this error : #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '? LIMIT 0, 30' at line 4
– itye1970
Nov 22 '18 at 9:50
You need to replace ? with a user name (the string you get as input) for example 'john'
– Joakim Danielson
Nov 22 '18 at 9:58
i still get error 1054 - Unknown column 'au.uid' in 'on clause': SELECT * FROM atabl_users au INNER JOIN atabl_joomgallery_users aju ON au.uid = aju.uid WHERE au.name LIKE "fred" AND aju.uid = 17 LIMIT 30
– itye1970
Nov 22 '18 at 10:02
That comment isn't for me, is it? Anyway use single not double quotes around text strings. Also what is the name of the user id column in atabl_users?
– Joakim Danielson
Nov 22 '18 at 10:06
thanks for the help, i need to input the user name and from this user name i need to get the user id and pass this into the table which contains the favorites this will then be used to retrieve the users favorites from the favorites table which users userid .
– itye1970
Nov 22 '18 at 10:11
|
show 7 more comments
You use JOIN to combine your queries
SELECT j.*
FROM atabl_joomgallery_users j
JOIN atabl_users u ON u.id = j.uuserid
WHERE u.name LIKE ?
Note that LIKE might return several users so if you get a unique user name as input value you can change the where clause to
WHERE u.name = ?
answered Nov 22 '18 at 9:48
Joakim DanielsonJoakim Danielson
9,2783724
i get this error : #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '? LIMIT 0, 30' at line 4
– itye1970
Nov 22 '18 at 9:50
You need to replace ? with a user name (the string you get as input) for example 'john'
– Joakim Danielson
Nov 22 '18 at 9:58
i still get error 1054 - Unknown column 'au.uid' in 'on clause': SELECT * FROM atabl_users au INNER JOIN atabl_joomgallery_users aju ON au.uid = aju.uid WHERE au.name LIKE "fred" AND aju.uid = 17 LIMIT 30
– itye1970
Nov 22 '18 at 10:02
That comment isn't for me, is it? Anyway use single not double quotes around text strings. Also what is the name of the user id column in atabl_users?
– Joakim Danielson
Nov 22 '18 at 10:06
thanks for the help, i need to input the user name and from this user name i need to get the user id and pass this into the table which contains the favorites this will then be used to retrieve the users favorites from the favorites table which users userid .
– itye1970
Nov 22 '18 at 10:11
|
show 7 more comments
You use JOIN to combine your queries
SELECT j.*
FROM atabl_joomgallery_users j
JOIN atabl_users u ON u.id = j.uuserid
WHERE u.name LIKE ?
Note that LIKE might return several users so if you get a unique user name as input value you can change the where clause to
WHERE u.name = ?
answered Nov 22 '18 at 9:48
Joakim DanielsonJoakim Danielson
9,2783724
You use JOIN to combine your queries
SELECT j.*
FROM atabl_joomgallery_users j
JOIN atabl_users u ON u.id = j.uuserid
WHERE u.name LIKE ?
Note that LIKE might return several users so if you get a unique user name as input value you can change the where clause to
WHERE u.name = ?
answered Nov 22 '18 at 9:48
Joakim DanielsonJoakim Danielson
9,2783724
edited Nov 22 '18 at 10:29
answered Nov 22 '18 at 9:48
Joakim DanielsonJoakim Danielson
9,2783724
answered Nov 22 '18 at 9:48
Joakim DanielsonJoakim Danielson
9,2783724
answered Nov 22 '18 at 9:48
Joakim DanielsonJoakim Danielson
9,2783724
9,2783724
i get this error : #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '? LIMIT 0, 30' at line 4
– itye1970
Nov 22 '18 at 9:50
You need to replace ? with a user name (the string you get as input) for example 'john'
– Joakim Danielson
Nov 22 '18 at 9:58
i still get error 1054 - Unknown column 'au.uid' in 'on clause': SELECT * FROM atabl_users au INNER JOIN atabl_joomgallery_users aju ON au.uid = aju.uid WHERE au.name LIKE "fred" AND aju.uid = 17 LIMIT 30
– itye1970
Nov 22 '18 at 10:02
That comment isn't for me, is it? Anyway use single not double quotes around text strings. Also what is the name of the user id column in atabl_users?
– Joakim Danielson
Nov 22 '18 at 10:06
thanks for the help, i need to input the user name and from this user name i need to get the user id and pass this into the table which contains the favorites this will then be used to retrieve the users favorites from the favorites table which users userid .
– itye1970
Nov 22 '18 at 10:11
|
show 7 more comments
i get this error : #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '? LIMIT 0, 30' at line 4
– itye1970
Nov 22 '18 at 9:50
You need to replace ? with a user name (the string you get as input) for example 'john'
– Joakim Danielson
Nov 22 '18 at 9:58
i still get error 1054 - Unknown column 'au.uid' in 'on clause': SELECT * FROM atabl_users au INNER JOIN atabl_joomgallery_users aju ON au.uid = aju.uid WHERE au.name LIKE "fred" AND aju.uid = 17 LIMIT 30
– itye1970
Nov 22 '18 at 10:02
That comment isn't for me, is it? Anyway use single not double quotes around text strings. Also what is the name of the user id column in atabl_users?
– Joakim Danielson
Nov 22 '18 at 10:06
thanks for the help, i need to input the user name and from this user name i need to get the user id and pass this into the table which contains the favorites this will then be used to retrieve the users favorites from the favorites table which users userid .
– itye1970
Nov 22 '18 at 10:11
i get this error : #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '? LIMIT 0, 30' at line 4
– itye1970
Nov 22 '18 at 9:50
i get this error : #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '? LIMIT 0, 30' at line 4
– itye1970
Nov 22 '18 at 9:50
You need to replace ? with a user name (the string you get as input) for example 'john'
– Joakim Danielson
Nov 22 '18 at 9:58
You need to replace ? with a user name (the string you get as input) for example 'john'
– Joakim Danielson
Nov 22 '18 at 9:58
i still get error 1054 - Unknown column 'au.uid' in 'on clause': SELECT * FROM atabl_users au INNER JOIN atabl_joomgallery_users aju ON au.uid = aju.uid WHERE au.name LIKE "fred" AND aju.uid = 17 LIMIT 30
– itye1970
Nov 22 '18 at 10:02
i still get error 1054 - Unknown column 'au.uid' in 'on clause': SELECT * FROM atabl_users au INNER JOIN atabl_joomgallery_users aju ON au.uid = aju.uid WHERE au.name LIKE "fred" AND aju.uid = 17 LIMIT 30
– itye1970
Nov 22 '18 at 10:02
That comment isn't for me, is it? Anyway use single not double quotes around text strings. Also what is the name of the user id column in atabl_users?
– Joakim Danielson
Nov 22 '18 at 10:06
That comment isn't for me, is it? Anyway use single not double quotes around text strings. Also what is the name of the user id column in atabl_users?
– Joakim Danielson
Nov 22 '18 at 10:06
thanks for the help, i need to input the user name and from this user name i need to get the user id and pass this into the table which contains the favorites this will then be used to retrieve the users favorites from the favorites table which users userid .
– itye1970
Nov 22 '18 at 10:11
thanks for the help, i need to input the user name and from this user name i need to get the user id and pass this into the table which contains the favorites this will then be used to retrieve the users favorites from the favorites table which users userid .
– itye1970
Nov 22 '18 at 10:11
|
show 7 more comments
If you are requiring all information from two tables, you require an ID that they both share, so that they can be linked (joined) together.
Based on the information you provided, I'm assuming that both tables contain the value "uid" as the user id.
As such, the following query should be used :
"SELECT * FROM atabl_users au INNER JOIN atabl_joomgallery_users aju ON au.uid = aju.uid WHERE au.name LIKE ? AND aju.uid = 17 LIMIT 30"
I've removed the ORDER BY, as you would need a different one. There is no use in ordering by uid if you've specified it as 17.
To explain, we are asking to get all information * from table atable_users, then we're assigning it a shorthand value of au, to make it easier to read later on. We're then joining this table set with another table, based on the two unique values. Then we can refine our search using our WHERE values, and then lastly LIMIT the result set by 30.
answered Nov 22 '18 at 9:42
cmprogramcmprogram
1,194619
I tried but got this error? #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '"SELECT * FROM atable_users au INNER JOIN atable___joomgallery_users aju ON au.uid ' at line 1
– itye1970
Nov 22 '18 at 9:47
@itye1970 I made a spelling error in your table name, and you can see it in the error of the comment you posted. I've amended it now.
– cmprogram
Nov 22 '18 at 9:50
i get this error now #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '? AND aju.uid = 17 LIMIT 30"' at line 1
– itye1970
Nov 22 '18 at 10:04
You have to replace "?" with whatever you were going to input with 'user to input value'. Try replacing ? with a default value that you know exists.
– cmprogram
Nov 22 '18 at 10:06
add a comment |
If you are requiring all information from two tables, you require an ID that they both share, so that they can be linked (joined) together.
Based on the information you provided, I'm assuming that both tables contain the value "uid" as the user id.
As such, the following query should be used :
"SELECT * FROM atabl_users au INNER JOIN atabl_joomgallery_users aju ON au.uid = aju.uid WHERE au.name LIKE ? AND aju.uid = 17 LIMIT 30"
I've removed the ORDER BY, as you would need a different one. There is no use in ordering by uid if you've specified it as 17.
To explain, we are asking to get all information * from table atable_users, then we're assigning it a shorthand value of au, to make it easier to read later on. We're then joining this table set with another table, based on the two unique values. Then we can refine our search using our WHERE values, and then lastly LIMIT the result set by 30.
answered Nov 22 '18 at 9:42
cmprogramcmprogram
1,194619
I tried but got this error? #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '"SELECT * FROM atable_users au INNER JOIN atable___joomgallery_users aju ON au.uid ' at line 1
– itye1970
Nov 22 '18 at 9:47
@itye1970 I made a spelling error in your table name, and you can see it in the error of the comment you posted. I've amended it now.
– cmprogram
Nov 22 '18 at 9:50
i get this error now #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '? AND aju.uid = 17 LIMIT 30"' at line 1
– itye1970
Nov 22 '18 at 10:04
You have to replace "?" with whatever you were going to input with 'user to input value'. Try replacing ? with a default value that you know exists.
– cmprogram
Nov 22 '18 at 10:06
add a comment |
If you are requiring all information from two tables, you require an ID that they both share, so that they can be linked (joined) together.
Based on the information you provided, I'm assuming that both tables contain the value "uid" as the user id.
As such, the following query should be used :
"SELECT * FROM atabl_users au INNER JOIN atabl_joomgallery_users aju ON au.uid = aju.uid WHERE au.name LIKE ? AND aju.uid = 17 LIMIT 30"
I've removed the ORDER BY, as you would need a different one. There is no use in ordering by uid if you've specified it as 17.
To explain, we are asking to get all information * from table atable_users, then we're assigning it a shorthand value of au, to make it easier to read later on. We're then joining this table set with another table, based on the two unique values. Then we can refine our search using our WHERE values, and then lastly LIMIT the result set by 30.
answered Nov 22 '18 at 9:42
cmprogramcmprogram
1,194619
If you are requiring all information from two tables, you require an ID that they both share, so that they can be linked (joined) together.
Based on the information you provided, I'm assuming that both tables contain the value "uid" as the user id.
As such, the following query should be used :
"SELECT * FROM atabl_users au INNER JOIN atabl_joomgallery_users aju ON au.uid = aju.uid WHERE au.name LIKE ? AND aju.uid = 17 LIMIT 30"
I've removed the ORDER BY, as you would need a different one. There is no use in ordering by uid if you've specified it as 17.
To explain, we are asking to get all information * from table atable_users, then we're assigning it a shorthand value of au, to make it easier to read later on. We're then joining this table set with another table, based on the two unique values. Then we can refine our search using our WHERE values, and then lastly LIMIT the result set by 30.
answered Nov 22 '18 at 9:42
cmprogramcmprogram
1,194619
edited Nov 22 '18 at 9:49
answered Nov 22 '18 at 9:42
cmprogramcmprogram
1,194619
answered Nov 22 '18 at 9:42
cmprogramcmprogram
1,194619
answered Nov 22 '18 at 9:42
cmprogramcmprogram
1,194619
1,194619
I tried but got this error? #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '"SELECT * FROM atable_users au INNER JOIN atable___joomgallery_users aju ON au.uid ' at line 1
– itye1970
Nov 22 '18 at 9:47
@itye1970 I made a spelling error in your table name, and you can see it in the error of the comment you posted. I've amended it now.
– cmprogram
Nov 22 '18 at 9:50
i get this error now #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '? AND aju.uid = 17 LIMIT 30"' at line 1
– itye1970
Nov 22 '18 at 10:04
You have to replace "?" with whatever you were going to input with 'user to input value'. Try replacing ? with a default value that you know exists.
– cmprogram
Nov 22 '18 at 10:06
add a comment |
I tried but got this error? #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '"SELECT * FROM atable_users au INNER JOIN atable___joomgallery_users aju ON au.uid ' at line 1
– itye1970
Nov 22 '18 at 9:47
@itye1970 I made a spelling error in your table name, and you can see it in the error of the comment you posted. I've amended it now.
– cmprogram
Nov 22 '18 at 9:50
i get this error now #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '? AND aju.uid = 17 LIMIT 30"' at line 1
– itye1970
Nov 22 '18 at 10:04
You have to replace "?" with whatever you were going to input with 'user to input value'. Try replacing ? with a default value that you know exists.
– cmprogram
Nov 22 '18 at 10:06
I tried but got this error? #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '"SELECT * FROM atable_users au INNER JOIN atable___joomgallery_users aju ON au.uid ' at line 1
– itye1970
Nov 22 '18 at 9:47
I tried but got this error? #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '"SELECT * FROM atable_users au INNER JOIN atable___joomgallery_users aju ON au.uid ' at line 1
– itye1970
Nov 22 '18 at 9:47
@itye1970 I made a spelling error in your table name, and you can see it in the error of the comment you posted. I've amended it now.
– cmprogram
Nov 22 '18 at 9:50
@itye1970 I made a spelling error in your table name, and you can see it in the error of the comment you posted. I've amended it now.
– cmprogram
Nov 22 '18 at 9:50
i get this error now #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '? AND aju.uid = 17 LIMIT 30"' at line 1
– itye1970
Nov 22 '18 at 10:04
i get this error now #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '? AND aju.uid = 17 LIMIT 30"' at line 1
– itye1970
Nov 22 '18 at 10:04
You have to replace "?" with whatever you were going to input with 'user to input value'. Try replacing ? with a default value that you know exists.
– cmprogram
Nov 22 '18 at 10:06
You have to replace "?" with whatever you were going to input with 'user to input value'. Try replacing ? with a default value that you know exists.
– cmprogram
Nov 22 '18 at 10:06
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53427754%2fsql-how-to-get-related-values-from-2-tables%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Please add structure (list of columns) of the atabl_users table to your question
– Joakim Danielson
Nov 22 '18 at 10:20
users table has the following : id name username email The joomgallery table has the following uid uuserid piclist
– itye1970
Nov 22 '18 at 10:23