Insert rows?

mahkali

Hi there,

I am quite new to MySQL and I wondered how to insert rows to a table.
I got this table: 'domain'
Each of the records should have these fields in this order:
id,'inlognaam','password','voornaam','tussenvoegsel','achternaam','adres','postcode','plaatsnaam','emailadres'

Next, i want to search if $inlognaam is in one of the records on field 'inlognaam', then check if $password matches with 'password' from the very same record.

Thanks!!

Mahkali

Anon

INSERT is the SQL command to insert
UPDATE is the SQL command to update

SELECT * from table where FIELDNAME like 'condition' AND OTHERFIELD = 'othercondition'

Goto Mysql.com and RTM and all will become clear.

mahkali

<?php include "connect.php";
$result == mysql_query("INSERT INTO domain (id,inlognaam,password,voornaam,tussenvoegsel,achternaam,adres,postcode,plaatsnaam,emailadres) VALUES('$id', '$login', '$password', '$vnaam', '$tvoeg', '$anaam', '$adres', '$postcode', '$plaatsnaam', '$emailadres')");
or die ("Error creating record");
?>

something like this one?

mahkali

<?php
function login($login, $password) {
include "connect.php";
$result == mysql_query("SELECT * from domain where inlognaam like '$login' AND password like '$password' ");
IF($result) {
return "true";
} }
?>

is this okay?

Anon

Almost, pretty perfect but == is a boolean test rather than = which is becomes equal to.

Depending on how you code you might like to supress bomb out errors from mysql etc. Using the @ sign in front of functions will mean that sql errors etc will be made "silent" - no more "error on line 44".

Also, for your own debugging use mysql_error() which outputs any sql errors to you.

Other than that, it looks good - cool.

mahkali

Hehe, the mysql_error() function came pretty handy as i noticed the table not to be created yet =)

So, i need a check on the create table query, i think it should be like something this (i removed certain columns to make it easier to start)

<?php
$query = "CREATE TABLE IF NOT EXISTS userlogin (id INT(3) NOT NULL AUTO_INCREMEMT PRIMARY KEY, username VARCHAR(8) NOT NULL, password VARCHAR(8) NOT NULL, auth INT(2) NOT NULL";
if (mysql_db_query($database, $query, $link)) {
print ("YAY!<BR>\n"); }
else {
print ("BOO!!<br>\n"); }
?>

mahkali

nevermind, i figured it out

Thanks

mahkali

I found a way to insert records manually, untill i'll find a way to use mysql scripts i'll use that.

Thanks anyway

Mahkali