2 replies to this topic

[Hooch]

Hi there.
I have managed to set my table up from a .php page.
The webpage needs an Admin level user to log in.
So I want to be able to insert into the `users` a user with level 5 access.
Here is my working table install

<?php
include "../includes/db.php";

$query = 'DROP TABLE `users`';
$result = mysql_query($query);
echo "Table Deleted!";

$query = 'CREATE TABLE `users` (
id int(11) NOT NULL auto_increment,
username varchar(32) NOT NULL UNIQUE,
password varchar(32) NOT NULL,
firstname varchar(32) NOT NULL,
lastname varchar(32) NOT NULL,
status varchar(32) NOT NULL,
email varchar(32) NOT NULL UNIQUE,
medium varchar(32) NOT NULL,
studio varchar(32) default NULL,
tours varchar(32) default NULL,
website varchar(32) default NULL,
address varchar(32) NOT NULL,
city varchar(32) NOT NULL,
province varchar(32) NOT NULL,
zip varchar(7) NOT NULL,
phone varchar(13) default NULL,
bio text NOT NULL,
bio2 text NOT NULL,
online varchar(12),
level int(1) default 1,
PRIMARY KEY (`id`))
ENGINE=MYISAM';

$result = mysql_query($query);
echo "Table Created!";
?>

Here's what I need included in the above code.

INSERT INTO `users` VALUES (1, 'Admin', '1a1dc91c907325c69271ddf0c944bc72', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 5)

I'm having alot of errors trying to figure this out.

Thank you for your kind help again people.

Hooch

[Matthew.]

Try this

<?php
include "../includes/db.php";

$query = 'DROP TABLE `users`';
$result = @mysql_query($query) or die(mysql_error());
echo "Table Deleted!";

$query = 'CREATE TABLE `users` (
id int(11) NOT NULL auto_increment,
username varchar(32) NOT NULL UNIQUE,
password varchar(32) NOT NULL,
firstname varchar(32) NOT NULL,
lastname varchar(32) NOT NULL,
status varchar(32) NOT NULL,
email varchar(32) NOT NULL UNIQUE,
medium varchar(32) NOT NULL,
studio varchar(32) default NULL,
tours varchar(32) default NULL,
website varchar(32) default NULL,
address varchar(32) NOT NULL,
city varchar(32) NOT NULL,
province varchar(32) NOT NULL,
zip varchar(7) NOT NULL,
phone varchar(13) default NULL,
bio text NOT NULL,
bio2 text NOT NULL,
online varchar(12),
level int(1) default 1,
PRIMARY KEY (`id`))
ENGINE=MYISAM';

$result = @mysql_query($query) or die(mysql_error());
echo "Table Created!";

@mysql_query("INSERT INTO `users` 
			  VALUES (1, 'Admin', '1a1dc91c907325c69271ddf0c944bc72', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 5)") or die(mysql_error());
echo '<br />User added!';
?>

Check out the error reporting i added which will sort out any sql related errors you may encounter. (you should add this to EVERY query as a rule)

[Hooch]

ChaChing!!!


Muchos Gracias!!

And thank you for the error reporting.
I'm obviously learning here.
Have a great day/night
Hooch