mysql query

[snach15]

mokos ar elementāru scriptu bet nekas neiznāk :@

 

tātad kas šeit nav pareizi? gribu izvilkt no tabulas lai rāda katram individuāli savus credītus...

						<?php
// Make a MySQL Connection
mysql_connect("localhost", "root", "mana parole") or die(mysql_error());
mysql_select_db("topsite") or die(mysql_error());

$test = mysql_query("SELECT credits FROM users WHERE username = ".$_SESSION['user_username']."");
$test = mysql_fetch_row($test);
$test = $test[0];

echo $test;
?>

Edited August 4, 2010 by snach15

[Леший]

$test = mysql_query("SELECT credits FROM users WHERE username = '".$_SESSION['user_username']."'");

Pēdiņas.

 

EDIT: Pārliecinies, ka ir session_start();

Edited August 4, 2010 by Леший

[snach15]

paldies! vis darbojas

[Kemito]

Uz notepad++ takš viss pa krāsām skaisti dalās, kā nākas, un visu var redzēt :)

[Леший]

Kemito, šis ir cits variants

field = asdf

pret

field = 'adsf'

Editors nebļaus.