A couple of things...
> $conxn = mysql_connect('localhost','root','redtail.7') or fail("Could
> not connect: ".mysql_error());
Create a script inc.mysqlconnect.php that connects and selects and
require_once() it on all of your files that need to connect to the
database. This will save overhead because each script will not require
a new connection, and also if you ever have to migrate the script it
will save you pain (i.e. you won't need to update the host, username,
and password for all lines in all scripts. Oh, btw, I hope that isn't
your real password and you really aren't connecting as root. Both are
major security no nos.
> $chk = "Select id, fname from contact_info where email =" . $email;
You need to quote the email. So perhaps the following would be more
appropriate:
$chk = "SELECT id, fname FROM contact_info WHERE email = \"{$email}\"";
> ('$fname','$lname','$tel','$address','$city','$state','$zipcode','$country',
> '$email')";
I believe there is some problems using 's and not "s. Try using "s
above.
> I keep getting "supplied argument is not a valid MySQL result resource" for
> the lines using mysql_fetch_array and mysql_num_fields - I've looked up the
If you fetch an array on a failure you don't have a resource to get.
mysql_query() returns an array. See the correction of $email above and
e-mail above if there is some problems.
HTH,
-Dan
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
