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

Stopped working!
So I had to change some stuff, none of it major. Stuff like the extension_dir and such. BEFORE I did

compile php5 with DOM
Hi,

I can't manage to compile php 5.3.0 from source on Windows to include DOM,
in spite of

Interpret Order
Hello all,

I'm wondering if I have this:

Code: $switch = array(
'one' =>

Table sorting
Hi,

I'm trying to modify the following in order to make the output table sorted alphabeticall

Guixt issue
Hello all,

We are experiencing the following problem with Guixt:

Some transact

Creating web pages by php
Hello again,
I was just wondering us there a way to use a php script to create a new web page. I

Session
I am having a little trouble with a session. Not sure if it is my browser or what. I know I do not

Php WordPress help
I am writing the following code for making a plugin

<?php
header("Content-Type

shoping cart issues
i´ve wrote this and works when i add an item to, my cart, but when i want to add othrer item just

Login script (probably a simple error)
dbConfig.php
Code: <?
// Replace the variable values below
// with your specific dat