mysql select with $_get ?

Posted on 16th Feb 2014 07:03 pm by admin

Hi, i have this code:
Code: // If char id is 0 and character dont exist do:
if ($_GET["id"] == "0")
{
die "A character ID can never be 0. This character does not exists or have not been created yet!
Please create a new character first.";
}
else

// Get the character stats from the wc_characters table
$charinfo = mysql_query("SELECT CharacterId, class, points, level, xp, reqxp, money, str, agi, inte, sta, backs, chests, feet, hands, helmets, legs, necks, wrists, leftweapons, rightweapons, waists, tinkers, shoulders, rings, profession1, profession2, playerId, hp, mn, armor, dps, rank FROM wc_characters WHERE CharacterId ='$_SESSION[valid_user]'")
or die(mysql_error());
Now for my where clause, i want the ID = the ID the user inputs in the URL, like here:
if ($_GET["id"] == "0")
So if a user gets to a url like ?id=1 it should select where characterid = 1

Other php-forum

IS this code correct
The reason i ask is everything underneath it appears to be alink as well, tis blimmin annoying

Code working in IE but not FireFox
I created a dynamic navigation list for my website based off of a table in my database. The code is

Simple Variable Question
Hi everyone.... again,

I am really getting into php still. Learning more every day. I love it

Help with looping
I have a comma separated list of colors taken from a database ($ICo) and a directory of images named

PHP MySQL Return Results Issue
Hi guys,

I'm running joomla and made a module which is using ajax.
Basically i just have a

split string
Hi all

i have some names (imploded by comma):
Code: toronto,paris,madrid
Now, i would

Having a problem get the selected item from a drop down menu
I have been looking at this for days now.

I have a drop down menu that get it's values from a

cURL error
So here is my code... I got it off of here... http://www.youtube.com/watch?v=XcgQUsorF_8
Because

PHP/Database issue
My friend is helping me make a database where you go to a certain webpage of my site and the page wi

Search in the PHP Files
have to search asterisk(*) in the php code of the php files .
In the html page one text box