[RESOLVED] Creating an Online Survey Part 2 problem.

CousinJack

I was working my way through the Creating an Online Survey Part 2 tutorial found here: http://www.phpbuilder.com/columns/patterson20051109.php3, and run into this error:

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /Applications/xampp/htdocs/survey/process2.php on line 122
Error!
There was an error processing your request. mySQL returned the following:

0

Line 122 is:

$rslt = mysql_query($dbc, $sql);

Like the directions said, I did change mysqli to mysql because not using mysqli.

Not sure what's wrong, I didn't write the code and I'm pretty new to this.

Also, the links to the full source for all examples on page 2 are broken.

Thanks in advance.

🙂

bradgrafelman

Are you positive you changed all references of mysqli to mysql? Can you show us the bit of code before that line?

Also, any reason why you didn't want to use the MySQLi library?

CousinJack

bradgrafelman;10878918 wrote:
Are you positive you changed all references of mysqli to mysql? Can you show us the bit of code before that line?

Also, any reason why you didn't want to use the MySQLi library?

I changed all mysqli to mysql, then I changed it back to mysqli and it worked. I guess I am using mysqli :rolleyes:

But.... there's another problem. The male and female does not increment. They just stay at 0. I did not change to code at all from the original except the database connection id, password, etc..

Nevermind, I figured it out. The male and female were capitalized in the values for the form file. Also, the
$lots = ($__k[$_POST['knowledge']] == '2')?'1':'0';
line is differ from the SQL table, it should be $a_lot.

🙂

bradgrafelman

Don't forget to mark this thread resolved (if it is).

CousinJack

bradgrafelman;10878928 wrote:
Don't forget to mark this thread resolved (if it is).

It's resolved on my end.

The author may want to make those changes so that others don't get bogged down with debugging it. Also, re-link the resources would be good.

🙂