Are you sure this is the correct file? This is full
of syntax errors, you should be getting parse errors.
A few tips:
a) Don't post to multiple lists. This is a PHP issue,
not MySQL. Hopefully this will end the mysql list
thread.
b) Don't use mysql_db_query() as it is deprecated. See:
http://www.php.net/mysql_db_query
Use mysql_select_db() and mysql_query() instead.
c) Be 100% this is right file, or if this (what you gave
us) is the exact code in that file. I doubt it is.
d) If an error is on line 12, tell us what line #11-13 are.
e) While developing, put error_reporting(E_ALL); on top
of your script.
f) Don't fully rely on syntax highlighting of your text
editor as it will never be perfect.
To narrow down the error, try this format:
<?php
if (!$conn = mysql_connect($host, $username, $password)) {
print "Could not connect: " . mysql_error();
exit;
}
if (!mysql_select_db($dbname)) {
print "Could not select DB " . mysql_error();
exit;
}
$sql = "Your SQL goes here";
if (!$result = mysql_query($sql)) {
print "Could not run query ($sql) : " . mysql_error();
exit;
}
print "Thank you for submitting the data, we got it";
?>
Basically, we are checking if these functions return
false. If they do, an error will be sent and the
script will exit. Instead of using exit each time,
you may want to implement your own db error management
so if a db error occurs you load a static page or
your webmaster email or whatever. But the above should
narrow down your error and is a good start.
The original reason you got this error is, I assume, that
you treated $link_glob as a simple string. Other replies
discussed this a bit. Lastly:
print $foo; // sexy
print "$foo"; // not as sexy but will work (eww)
print '$foo'; // literally prints a string $foo and
// not the value of $foo. bad.
Read/study this tutorial on using strings:
http://www.zend.com/zend/tut/using-strings.php
Good luck, you'll get the hang of it soon :)
Regards,
Philip Olson
On Mon, 3 Jun 2002, Jule Slootbeek wrote:
> Jule Slootbeek wrote:
> > G r e g L a w r i e wrote:
> >
> >> It would also appear you are missing a closing ) at the end of the
> >> '$query=...' line. You have two opening backets and only one closing.
> >>
> >> Greg
> >>
> >> -----Original Message-----
> >> From: Bruce Lewis [mailto:[EMAIL PROTECTED]]
> >> Sent: Tuesday, 4 June 2002 7:50
> >> To: [EMAIL PROTECTED]; mysql; php-general
> >> Subject: Re: stupid error, please kick me (and send me a solution)
> >>
> >>
> >> Your missing your closing "}" at the end of the else statement.
> >>
> >>
> >> ----- Original Message -----
> >> From: "Jule Slootbeek" <[EMAIL PROTECTED]>
> >> To: "mysql" <[EMAIL PROTECTED]>; "php-general"
> >> <[EMAIL PROTECTED]>
> >> Sent: Monday, June 03, 2002 5:09 PM
> >> Subject: stupid error, please kick me (and send me a solution)
> >>
> >>
> >>
> >>> Hey guys,
> >>> i'm getting this error with the following sql script using php:
> >>> --error--
> >>> Warning: Supplied argument is not a valid MySQL-Link resource in
> >>> /var/www/phpquiz/register_user.php on line 12
> >>> --error--
> >>>
> >>> --script--
> >>> $link_glob = "mysql_connect('$host_glob', '$un_glob', '$pw_glob')";
> >>> $query = "INSERT INTO user values('0', '$fname', '$lname', '$email',
> >>> '$username', PASSWORD('$password')";
> >>> $result = mysql_db_query('$db_glob', '$query', $link_glob');
> >>> if (!$result) {
> >>> echo "<font size=+1>Your Information could not be entered into the
> >>
> >>
> >> database,
> >>
> >>> Please contact the <a
> >>> href=mailto:$webmaster>webmaster</a>.</font><br><br>" . mysql_errno() .
> >>> ": " . mysql_error() . "<br><br>";
> >>> } else {
> >>> echo "<font size=+1>Your Information has successfully been entered into
> >>
> >>
> >> the
> >>
> >>> database!</font><br>";
> >>>
> >>> --
> >>> Jule Slootbeek
> >>> [EMAIL PROTECTED]
> >>>
> >>> http://blindtheory.cjb.net
> >>>
> >>>
> >>>
> >>> ---------------------------------------------------------------------
> >>> Before posting, please check:
> >>> http://www.mysql.com/manual.php (the manual)
> >>> http://lists.mysql.com/ (the list archive)
> >>>
> >>> To request this thread, e-mail <[EMAIL PROTECTED]>
> >>> To unsubscribe, e-mail
> >>
> >>
> >> <[EMAIL PROTECTED]>
> >>
> >>> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> >>>
> >>>
> >>
> >>
> >>
> >>
> >> ---------------------------------------------------------------------
> >> Before posting, please check:
> >> http://www.mysql.com/manual.php (the manual)
> >> http://lists.mysql.com/ (the list archive)
> >>
> >> To request this thread, e-mail <[EMAIL PROTECTED]>
> >> To unsubscribe, e-mail
> >> <[EMAIL PROTECTED]>
> >> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> >>
> >
> > $query = "INSERT INTO user values('0', '$fname', '$lname', '$email',
> > '$username', PASSWORD('$password')";
> >
> > that should be all closed shouldn't it?
> > my text editor colors code, and it doesn't show any mistakes..
> > thanks though
> > Jule
> >
> well it didn't fix it, but still thanks,
>
> Jule
>
>
>
> --
> Jule Slootbeek
> [EMAIL PROTECTED]
>
> http://blindtheory.cjb.net
>
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
