Help - Search - Members - Calendar
Full Version: Database Code Issues
Zymic Webmaster Forums > Zymic Free Web Hosting > Databases & MySQL
danielwtn
using assorted guides on the internet, i managed to peice together a php code for opening a database, writing values to it, and closing it; but for some reason it doesn't work. i wanted to know whether or not it was my code or my database, and if it is the code how do i fix it?

Here is my code:

<?php
$fname=$_POST[fname];
$lname=$_POST[lname];
$uname=$_POST[uname];
$pname=$_POST[pname];
$ename=$_POST[ename];
$member=mysql_connect(localhost,ncpi_danielwtn,danny21);
mysql_query(members,$member);
$register=insert into members (firstname,lastname,username,password,email) values ($fname,$lname,$uname,$pname,$ename);
mysql_query(members,$register);
mysql_close($member);
?>
Ed
Try after your query:
CODE
echo mysql_error();


Also, you really should be sanitizing the values being inserted by using http://www.php.net/mysql-real-escape-string
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2009 Invision Power Services, Inc.