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

GMail like Chat in ASP.NET
Hi,Can anyone suggest me, how to incorporate GMail like chat in my existing ASP.Net application.I wa

help with email script...
hey

I need help with my mail script

when the form on http://www.mcgdesignstudio.com/c

SQL Query/echo not working
Hey all,

I'm trying to run (what I thought) was a simple operation and it isn't working. I h

reating a background image
I am building a site in drupal and have a php form in it, due to certain annoyances with module buil

Error: SQL Syntax; Line 1
Code:

<?php require "global_settings.php"; ?>
<title&g

Search with relational database
Hey,

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

mysql_query returning boolean instead of mysql ressource
Hi,

I seem to have a weird issue with the php command mysql_query. I pass 2 arguments the que

php/xmlrpc class issue
I am working on xml-rpc in php to start with.

I have a class that only has variables defined

php or sql?
Sorry not sure if this is a sql problem or php the following code is supposed to delete data from th

Passing Variables
What I'm wanting to do is when the user clicks on Arenas it will know the name of the country it's w