variable in mysql

[Colin-Roberts]

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

[Colin-Roberts]

wow nvm i figured it out

[LMS16]

$result = mysql_query("SELECT * FROM comments WHERE userwall='<?php echo $loggedin['username']; ?>' ORDER BY id DESC");

Wow, Im glad you figured that out lol

Lew.

[Colin-Roberts]

lewie for the record your way doesn't work, it gives errors.

[Irrorate]

$result = mysql_query("SELECT * FROM comments WHERE userwall='<?php echo $loggedin['username']; ?>' ORDER BY id DESC");

Wow, Im glad you figured that out lol

Lew.

If you're using a result variable... you're going to have the PHP tags open already.

$result = mysql_query("SELECT * FROM comments WHERE userwall = $loggedin['username'] ORDER BY id DESC"); should work fine... I've not used PHP in a long time.

[LMS16]

lewie for the record your way doesn't work, it gives errors.

Sorry lol, I should of known that. I was at work at the time


$result = mysql_query("SELECT * FROM `comments` WHERE` userwall` = '" . $loggedin['username'] . "' ORDER BY `id` DESC");

Thats how I would have coded it :) I like my full stops lol

Lew.

[Apolva]

Sorry lol, I should of known that. I was at work at the time


$result = mysql_query("SELECT * FROM `comments` WHERE` userwall` = '" . $loggedin['username'] . "' ORDER BY `id` DESC");

Thats how I would have coded it :) I like my full stops lol

Lew.

Your backquotes are messed up :D



$result = mysql_query("SELECT * FROM `comments` WHERE `userwall` = '".mysql_real_escape_string($loggedin['username'])."' ORDER BY `id` DESC;");

[LMS16]

Your backquotes are messed up :D



$result = mysql_query("SELECT * FROM `comments` WHERE `userwall` = '".mysql_real_escape_string($loggedin['username'])."' ORDER BY `id` DESC;");


Lol, I did it quickly :) I like to have spaces between my " . "'s lol

Lew.