[RESOLVED] Just Getting Started - REALLY

[j_w_Bruce]

I spent most of all night browsing posts and I learned quite a bit. But not enough to really put it all together... Here's a little background about me. I am a vb programmer (hope you all allow those types around here..). I have gotten myself volunteered somehow to build a whole big ol php/mysql environment.

I've decided to start with a register page that allows a user to create a username, password, and the date that they did that. I got it working (with help from your existing posts last night). But now I need to add features. I would like to check their username against the table and prevent them from registering if the username is already in the table.

This example is so simple, and I could do it with my debugger tied behind my back in VB, but I don't yet understand enough about the php script to get anywhere. Just getting this working will teach me alot about php syntax and where to start.

I'm hoping that my scnerio is so simple that some of you will take pity and feel like parting with an easy example to steer me in the right direction.

To keep everything simple, this table has no key fields, just username and password field. There is also no joins.

Thanks in advance. I hope before too long I can return the favor.
JB

[rincewind456]

This may help

<?php

$existUser ="SELECT username FROM users WHERE username = '".
mysql_real_escape_string($_POST['username'])."'";

$result = mysql_query($existUser) or die(mysql_error());
$num_rows = mysql_num_rows($result);
if ($num_rows >0) {
	print "That User Name Has Been Taken";

}
?>

[j_w_Bruce]

Thanks, between what you got here and the manual. I'm over this hurdle.

It won't be long until I have another question

JB