Click here to Skip to main content
16,021,432 members
Home / Discussions / Linux, Apache, MySQL, PHP
   

Linux, Apache, MySQL, PHP

 
GeneralRe: str_replace vs hebrevc Pin
Luc Pattyn26-Nov-09 9:46
sitebuilderLuc Pattyn26-Nov-09 9:46 
GeneralRe: str_replace vs hebrevc Pin
Quiltfish26-Nov-09 9:58
Quiltfish26-Nov-09 9:58 
GeneralRe: str_replace vs hebrevc Pin
Luc Pattyn26-Nov-09 12:14
sitebuilderLuc Pattyn26-Nov-09 12:14 
QuestionHelp debug a php function with database and JOIN query. Pin
djkee24-Nov-09 20:10
djkee24-Nov-09 20:10 
AnswerRe: Help debug a php function with database and JOIN query. Pin
fly90424-Nov-09 21:25
fly90424-Nov-09 21:25 
GeneralRe: Help debug a php function with database and JOIN query. Pin
djkee24-Nov-09 21:40
djkee24-Nov-09 21:40 
GeneralRe: Help debug a php function with database and JOIN query. Pin
fly90424-Nov-09 21:44
fly90424-Nov-09 21:44 
GeneralRe: Help debug a php function with database and JOIN query. Pin
djkee24-Nov-09 22:13
djkee24-Nov-09 22: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 22:42
fly90424-Nov-09 22:42 
GeneralRe: Help debug a php function with database and JOIN query. [modified] Pin
djkee25-Nov-09 0:04
djkee25-Nov-09 0:04 
GeneralRe: Help debug a php function with database and JOIN query. Pin
fly90425-Nov-09 0:08
fly90425-Nov-09 0:08 
GeneralRe: Help debug a php function with database and JOIN query. [modified] Pin
djkee25-Nov-09 0:30
djkee25-Nov-09 0:30 
GeneralRe: Help debug a php function with database and JOIN query. Pin
cjoki25-Nov-09 10:29
cjoki25-Nov-09 10:29 
QuestionImage uploads to server with php and mySQL Pin
wartotojas24-Nov-09 8:17
wartotojas24-Nov-09 8:17 
Questionpost data missing after php parses raw post to post variable Pin
cjoki24-Nov-09 7:34
cjoki24-Nov-09 7:34 
AnswerRe: post data missing after php parses raw post to post variable Pin
fly90424-Nov-09 9:04
fly90424-Nov-09 9:04 
GeneralRe: post data missing after php parses raw post to post variable Pin
cjoki24-Nov-09 10:01
cjoki24-Nov-09 10:01 
GeneralRe: post data missing after php parses raw post to post variable Pin
fly90424-Nov-09 10:14
fly90424-Nov-09 10:14 
GeneralRe: post data missing after php parses raw post to post variable Pin
Marc Firth24-Nov-09 22:46
Marc Firth24-Nov-09 22:46 
GeneralRe: post data missing after php parses raw post to post variable Pin
cjoki25-Nov-09 8:43
cjoki25-Nov-09 8:43 
GeneralRe: post data missing after php parses raw post to post variable Pin
Marc Firth25-Nov-09 22:20
Marc Firth25-Nov-09 22:20 
GeneralRe: post data missing after php parses raw post to post variable Pin
cjoki27-Nov-09 10:37
cjoki27-Nov-09 10:37 
QuestionProblem with Visual Cpp compiler Pin
Game-point23-Nov-09 18:10
Game-point23-Nov-09 18:10 
AnswerRe: Problem with Visual Cpp compiler Pin
Richard MacCutchan1-Dec-09 2:29
mveRichard MacCutchan1-Dec-09 2:29 
AnswerRe: Problem with Visual Cpp compiler Pin
LloydA11114-Jan-10 8:42
LloydA11114-Jan-10 8: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.