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

Linux, Apache, MySQL, PHP

 
Questionstr_replace vs hebrevc Pin
Quiltfish26-Nov-09 10:01
Quiltfish26-Nov-09 10:01 
AnswerRe: str_replace vs hebrevc Pin
fly90426-Nov-09 10:17
fly90426-Nov-09 10:17 
AnswerRe: str_replace vs hebrevc Pin
Luc Pattyn26-Nov-09 10:22
sitebuilderLuc Pattyn26-Nov-09 10:22 
GeneralRe: str_replace vs hebrevc Pin
Quiltfish26-Nov-09 10:39
Quiltfish26-Nov-09 10:39 
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 
Hello everyone Smile | :) I have a big problem with this function that i wrote myself and i am sure i messed something Frown | :(
Could somebody look at it and help me Debug it ?

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


The function is suppose to connect to the db, select the latest record from AMCMS_highscores and join the AMCMS_highscores (userkey) field with the AMCMS_users database and field (userkey). So then i will get the latest highscores from highscores database and get the username by looking for the userkey -> username. Display latest highscore and the user who made it.

Could anyone help me make this dream come true Smile | :) Please Cry | :((
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 
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 

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.