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

form problem
Hi all, I think this is going to be easy to resolve but for I have been looking at it to long and I

Material Master Update through BAPI - Follow up material not updated
Hi Experts,

I am updating the material master through a custom transaction using the BAPI

Question about ShowWindow()
Hello....

I'm struggling with sumpin, and I hope y'all can help.

I've got a CFormView

Oracle Connectivity
Hi Every One,

Can we access SAP from oracle database.If it possible then please spec

RSS poster script?
I have found a script that posts RSS's for me on a site that I'm building. However I would like to a

A rank users order by points
I want to make an insert from table 'rank' , with number (rank) from the cod blow, to fild users.ran

Header redirect
Hello ive got a problem ive got form with its action set to itself.
Code: <form id="f

DELETE rows based on content
I have a link in my rows

$bit="http://bit.ly/abcd";
$query = mysql_query("D

printing links
Hi every1

i am connecting to a table in sql and the looping through with a while ($ var = my

Search with relational database
Hey,

I have quite a complicated (for me anyway ) relational database for an apartments syste