Is this OK up to now?

[evo4ever]

They all. Im in the middle of writing up a script to insert data into a database using a form. Is my script correct up to now?:

<?php

$dbhost = "localhost";
$dbuser = "subastic";
$dbpassword = "";
$db = "evostation_com_1";

@mysql_connect($dbhost, $dbuser, $dbpassword) or die("Couldn't connect to MySQL Database");
@mysql_select_db($db) or die("Couldn't select Database");

$username = $row['username'];
$password = $row['password'];
$firstName = $row['firstName'];
$lastName = $row['lastName'];
$email = $row['email'];
$subdomain = $row['subdomain'];
$host = $row['host'];
$location = $row['location'];
$timezone = $row['timezone'];
$radio1 = $row['radio1'];
$radio2 = $row['radio2'];
$forum = $row['forum'];
$aboutus = $row['aboutus'];
$message = $row['message'];
$checkbox = $row['checkbox'];


$query = mysql_query "INSERT INTO hostee_info (username, password, firstName, lastName, email, subdomain, host, location, radio1, radio2, forum, aboutus, message, checkbox)
					  VALUES ('$username', '$password', '$firstName', '$lastName', '$email', '$subdomain', '$host', '$location', '$radio1', '$radio2', '$forum', '$aboutus', '$message', '$checkbox')";
return("true");	
?>

Thx.

[the_Igel]

No 🙂

First of all, $row isn't set. You forgot a SELECT statement or something.

And, then, you need parenthesis for mysql_query():

$query = mysql_query("whatever you need");

[evo4ever]

Could you be so kindly and correct my code and post it all back. Thx man.

[the_Igel]

$query = mysql_query("INSERT INTO hostee_info (username, password, firstName, lastName, email, subdomain, host, location, radio1, radio2, forum, aboutus, message, checkbox)
                          VALUES ('$username', '$password', '$firstName', '$lastName', '$email', '$subdomain', '$host', '$location', '$radio1', '$radio2', '$forum', '$aboutus', '$message', '$checkbox')");

As for $row, I don't know what it's supposed to be but I believe it is smth like

$r = mysql_query("SELECT * FROM somewhere WHERE id = $id");
if (!mysql_num_rows($r)) die('Wrong ID!');
$row = mysql_fetch_assoc($r);

[evo4ever]

Thx man! I have another question now lol. I have an email form written in php (obviously) In the code it has where the email is going to (the address). What I want is to have a drop down menu in the form to select which person they want to send the form to (multiple choice email addresses) Code as folllows:

$y_email = "[e-mail]";

Thats the email address variable. How do I put more than one email address in there? if the user choose to send the email to me it gets sent to me, however if they want to send it to a different member it'll get sent to them! get what i mean?

The contact page is here: www.evostation.com/view.php?PAGEID=contact to have a look at the form's layout.

Help would be appreciated. Thx.

[cgraz]

On your form, you have a select field called to. That select field becomes a variable ($to) when the visitor hits submit.

If the visitor selects Evo for example, the value would be [e-mail]

So what you'd want to do is take that value and create a variable with it.

$y_email = $to;

Hope this helps!