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

Your Answer:

Login to answer

Other forums

Problems with array
This code is the last lines in an upload script that uploads 4 images at the same time and writes th

for some reason mysql query not working, not inserting, please check it out
This code is not inserting anything into my db, don't know why, the $_SESSION variable does contain

Email "$"
Hello!!

Any PHP guy with a bit of a knowledge in Flash ?

When I send a JPEG from flash

form help
this doesn't work. i want the form action to go the location.href of the submit button chosen.. how

PHP4 to PHP5 Conversion
Hi Everyone,

I am working on a site that is built up on PHP4 and each page is being started f

PEAR Email Attachment w/ $gpg
I have no issues with this code if I take out the attachement section and include the info in the em

How to restrict the display of report variants
Hello All,

I want t know how to restrict the display of report variants.
I mean, whe

foreach and array need help combining
Hi guys.

Here's the code

Code: array(
'tag' => 'code',<

please hep to get values from a table row
can anyone tel me how I can select and get data from one row by pressing an Edit button in that row

Preloading images
Posting this question here because I am not sure where this should belong.I am building an asp.net a