MySQL datu nolasiishana

[Klokjis]

Probleeminja... it kaa $_SESSION['g523s'] veertiiba ir 'VERTIBA'.

echo $_SESSION['g523s']; // atteelojas arii taa VERTIBA

Bet nolasot no MySQL attieciigos datus aile1, aile2, aile3 ir tukshas. ja uname='$x' vietaa ieliek uname='VERTIBA', tad viss normaali. aile 1, 2 un 3 ir ar saviem datiem, kaa vajag. a Porke vinjsh pie -> uname='$x' <- neatteelo datus kaa vajag?

 

<?

$x = $_SESSION['g523s'];

$query = "SELECT * FROM $table WHERE uname='$x' ";
$result = mysql_query($query);		
$row = mysql_fetch_array($result);

echo $row['aile1'];
echo "<br>";
echo $row['aile2'];
echo "<br>";
echo $row['aile3'];
echo "<br>";

?>

[Blitz]

nu panem uzstaisi echo "$query" un apskaties ko vins tur saraksta...

 

kautkur moska kada atstarpe iekjeras vai kkas cits....

Edited March 20, 2006 by Blitz

[Klokjis]

nu vinjsh atteelo taa kaa $x buutu tukshums -> SELECT * FROM tabula WHERE uname=''

[Kristabs]

session_start(); nav aizmirsts?

[Klokjis]

nav gan... pirms head'a ir session_start();

 

edit: un ar echo $_SESSION['g523s']; vinjsh atteelo veertiibu.

Edited March 20, 2006 by Klokjis

[v3rb0]

kam to $x tur?

 

'SELECT * FROM $table WHERE uname="'.$_SESSION['g523s'].'"';

vai

sprintf('SELECT * FROM $table WHERE uname="%s"',$_SESSION['g523s']);

vai

..

[Klokjis]

pieljauju ka gljux ir shajaa liinijaa:

 

$x = $_SESSION['g523s'];

 

jo ar echo $_SESSION['g523s']; vinjsh atteelo VERTIBA, bet ar echo $x; neatteelo neko. bet porke??

[Klokjis]

tnx. it kaa aizgaaja.