php+mysql (povezano) neka pitanja

Kako da citam podatke iz databaze (mysql), kako da pisem u nju preko php-ea...

npr. iz textfielda

sluzilo bi mi kao registracija...

dakle da se u tabeli ispise

user_id
username
user_password
user_email

itd.

[QUOTE]?php include ("config.php");
$sql = INSERT INTO phpbb_users VALUES (`$_POST[user_id]`, `$_POST[username]`, `$_POST[user_password]`, `$_POST[user_email]`);
if(isset($_POST['Submit']))
{

$username = $_POST['username'];
$password = $_POST['user_password'];
$location= $_POST['user_email'];?[/QUOTE]

tu nesto ne valja, sta trebam ispraviti?

$sql = (INSERT INTO phpbb_users VALUES (`$_POST[user_id]`, `$_POST[username]`, `$_POST[user_password]`, `$_POST[user_email]`));

valjda bi prije VALUES trebalo pisati GDJE hoces da ubacis sve to.. npr

<?

$nesto = $HTTP_POST_VARS['nesto']; //umjesto ovog moze biti kao i kod tebe $_POST[nesto]
$nesto1 = $HTTP_POST_VARS['nesto1'];
$nesto2 = $HTTP_POST_VARS['nesto2'];
$nesto3 = $HTTP_POST_VARS['nesto3'];

$sql = mysql_query(insert into tabela (nesto,nesto1,nesto2,nesto3) VALUES ('$nesto','$nesto1','$nesto2','$nesto3')) or die (mysql error());

?>
ovo or die (mysql_error()) uvijek stavljaj (:



a da vadis

$sql = mysql_query("SELECT * FROM tabela") or die (mysql_error());
while ($vadi=mysql_fetch_array($sql)) {

echo $vadi[username]; // ispisace svaki username

echo $vadi[user_id]; // ispisace svaki id

}

<?php include ("config.php");
$username = $_POST['username'];
$password = $_POST['user_password'];
$location= $_POST['user_email'];


$username = $_POST['username'];
$password = $_POST['user_password'];
$email = $_POST['user_email']

$sql = mysql_query(insert into phpbb_user VALUES (username, user_password, user_email)(values'$username','$user_password','$user_email')) or die (mysql error());

?>



Kaze:

Parse error: parse error in d:program fileseasyphp1-8wwwgamezoneforumregistracija2.php on line 11

$username = $_POST['username'];
$password = $_POST['user_password'];
$location= $_POST['user_email'];


$username = $_POST['username'];
$password = $_POST['user_password'];
$email = $_POST['user_email']

$sql = mysql_query(insert into phpbb_user VALUES (username, user_password, user_email)(values'$username','$user_password','$user_email')) or die (mysql error());

?>



Kaze:

Parse error: parse error in d:\program files\easyphp1-8\www\gamezone\forum\registracija2.php on line 11