Click here to Skip to main content
15,566,733 members
Home / Discussions / Linux, Apache, MySQL, PHP
   

Linux, Apache, MySQL, PHP

 
GeneralRe: str_replace vs hebrevc Pin
Luc Pattyn26-Nov-09 10:46
sitebuilderLuc Pattyn26-Nov-09 10:46 
GeneralRe: str_replace vs hebrevc Pin
Quiltfish26-Nov-09 10:58
Quiltfish26-Nov-09 10:58 
GeneralRe: str_replace vs hebrevc Pin
Luc Pattyn26-Nov-09 13:14
sitebuilderLuc Pattyn26-Nov-09 13:14 
QuestionHelp debug a php function with database and JOIN query. Pin
djkee24-Nov-09 21:10
djkee24-Nov-09 21:10 
AnswerRe: Help debug a php function with database and JOIN query. Pin
fly90424-Nov-09 22:25
fly90424-Nov-09 22:25 
GeneralRe: Help debug a php function with database and JOIN query. Pin
djkee24-Nov-09 22:40
djkee24-Nov-09 22:40 
GeneralRe: Help debug a php function with database and JOIN query. Pin
fly90424-Nov-09 22:44
fly90424-Nov-09 22:44 
GeneralRe: Help debug a php function with database and JOIN query. Pin
djkee24-Nov-09 23:13
djkee24-Nov-09 23:13 
Thanks, i fixed it and its compiling now but i cant get the scores out Frown | :(

Here is the function:
function am_getlatestscores($db, $cat) {
global $db;
    $sql = "SELECT * FROM `AMCMS_highscores` JOIN `AMCMS_users` WHERE `primkey`=`username` ORDER BY `primkey` DESC LIMIT 10;";
    $res = am_queries($db, $sql);
    return $res;
}



Here is how i output them in another file:
$higharray = am_getlatestscores($db, 'none', 'list');
foreach ($higharray as $hhscore) {
echo '<font><a href="./index.php?cat='.hhscore.'">$hhscore</a></font>


But it wont output anything Frown | :( I am sorry if its very simple but i am learning Big Grin | :-D
GeneralRe: Help debug a php function with database and JOIN query. Pin
fly90424-Nov-09 23:42
fly90424-Nov-09 23:42 
GeneralRe: Help debug a php function with database and JOIN query. [modified] Pin
djkee25-Nov-09 1:04
djkee25-Nov-09 1:04 
GeneralRe: Help debug a php function with database and JOIN query. Pin
fly90425-Nov-09 1:08
fly90425-Nov-09 1:08 
GeneralRe: Help debug a php function with database and JOIN query. [modified] Pin
djkee25-Nov-09 1:30
djkee25-Nov-09 1:30 
GeneralRe: Help debug a php function with database and JOIN query. Pin
cjoki25-Nov-09 11:29
cjoki25-Nov-09 11:29 
QuestionImage uploads to server with php and mySQL Pin
wartotojas24-Nov-09 9:17
wartotojas24-Nov-09 9:17 
Questionpost data missing after php parses raw post to post variable Pin
cjoki24-Nov-09 8:34
cjoki24-Nov-09 8:34 
AnswerRe: post data missing after php parses raw post to post variable Pin
fly90424-Nov-09 10:04
fly90424-Nov-09 10:04 
GeneralRe: post data missing after php parses raw post to post variable Pin
cjoki24-Nov-09 11:01
cjoki24-Nov-09 11:01 
GeneralRe: post data missing after php parses raw post to post variable Pin
fly90424-Nov-09 11:14
fly90424-Nov-09 11:14 
GeneralRe: post data missing after php parses raw post to post variable Pin
Marc Firth24-Nov-09 23:46
Marc Firth24-Nov-09 23:46 
GeneralRe: post data missing after php parses raw post to post variable Pin
cjoki25-Nov-09 9:43
cjoki25-Nov-09 9:43 
GeneralRe: post data missing after php parses raw post to post variable Pin
Marc Firth25-Nov-09 23:20
Marc Firth25-Nov-09 23:20 
GeneralRe: post data missing after php parses raw post to post variable Pin
cjoki27-Nov-09 11:37
cjoki27-Nov-09 11:37 
QuestionProblem with Visual Cpp compiler Pin
Game-point23-Nov-09 19:10
Game-point23-Nov-09 19:10 
AnswerRe: Problem with Visual Cpp compiler Pin
Richard MacCutchan1-Dec-09 3:29
mveRichard MacCutchan1-Dec-09 3:29 
AnswerRe: Problem with Visual Cpp compiler Pin
LloydA11114-Jan-10 9:42
LloydA11114-Jan-10 9:42 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.