i have this query:
$result = mysql_query("SELECT * FROM comments WHERE userwall='Colin Roberts' ORDER BY id DESC");
i want userwall to be a variable in relation to whose logged in.. how do i do this?
<?php echo $loggedin['username']; ?> echo's the the name of logged in user
Results 1 to 8 of 8
Thread: variable in mysql
-
variable in mysql
.:.:#14:.:. .:.: Impossible Is Nothing :.:. .:.: 845 Rep:.:.
.:.: Stand up for what is right, even if you stand alone:.:.
-
wow nvm i figured it out
.:.:#14:.:. .:.: Impossible Is Nothing :.:. .:.: 845 Rep:.:.
.:.: Stand up for what is right, even if you stand alone:.:.
-
Wow, Im glad you figured that out lolPHP Code:
$result = mysql_query("SELECT * FROM comments WHERE userwall='<?php echo $loggedin['username']; ?>' ORDER BY id DESC");
Lew.Im not here to be loved, I love to be hated :-}
-
lewie for the record your way doesn't work, it gives errors.
.:.:#14:.:. .:.: Impossible Is Nothing :.:. .:.: 845 Rep:.:.
.:.: Stand up for what is right, even if you stand alone:.:.
-
If you're using a result variable... you're going to have the PHP tags open already.
Originally Posted by Lewiie15
should work fine... I've not used PHP in a long time.PHP Code:$result = mysql_query("SELECT * FROM comments WHERE userwall = $loggedin['username'] ORDER BY id DESC");
-
Sorry lol, I should of known that. I was at work at the time Originally Posted by Colin-Roberts
Thats how I would have coded itPHP Code:$result = mysql_query("SELECT * FROM `comments` WHERE` userwall` = '" . $loggedin['username'] . "' ORDER BY `id` DESC");
I like my full stops lol
Lew.Im not here to be loved, I love to be hated :-}
-
Your backquotes are messed up Originally Posted by Lewiie15
Sorry lol, I should of known that. I was at work at the time
Thats how I would have coded itPHP Code:$result = mysql_query("SELECT * FROM `comments` WHERE` userwall` = '" . $loggedin['username'] . "' ORDER BY `id` DESC");
I like my full stops lol
Lew.
PHP Code:$result = mysql_query("SELECT * FROM `comments` WHERE `userwall` = '".mysql_real_escape_string($loggedin['username'])."' ORDER BY `id` DESC;");
-
Lol, I did it quickly Originally Posted by Apolva
Your backquotes are messed up
PHP Code:$result = mysql_query("SELECT * FROM `comments` WHERE `userwall` = '".mysql_real_escape_string($loggedin['username'])."' ORDER BY `id` DESC;");
I like to have spaces between my " . "'s lol
Lew.Im not here to be loved, I love to be hated :-}
Reply With Quote
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts