Silly msql error.

[Excellent]

Hey guys, just got onto coding something and I get this silly mysql error which I've never even heard of.

Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in /home/blah/public_html/thing/testing.php on line 4

This is my code.

<?php
session_start();
$conn = mysql_connect("localhost", "user", "password");
mysql_select_db("db", "$connect") or die(mysql_error());
?>

Now as you can see line 4 is just selecting my database, any clues? +REP.

Also I've checked my tables to make sure nothing numerical is there, all fine.

Moved by Invent (Forum Moderator) from Design & Development: Please post in the correct forum next time, thanks .

[Independent]

Hey guys, just got onto coding something and I get this silly mysql error which I've never even heard of.

Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in /home/blah/public_html/thing/testing.php on line 4

This is my code.

<?php
session_start();
$conn = mysql_connect("localhost", "user", "password");
mysql_select_db("db", "$connect") or die(mysql_error());
?>

Now as you can see line 4 is just selecting my database, any clues? +REP.

Also I've checked my tables to make sure nothing numerical is there, all fine.

Are you seriously stupid?

$conn = mysql_connect("localhost", "user", "password");
mysql_select_db("db", "$connect") or die(mysql_error());

There's a clue.

[Excellent]

Are you seriously stupid?

$conn = mysql_connect("localhost", "user", "password");
mysql_select_db("db", "$connect") or die(mysql_error());

There's a clue.

Are you seriously stupid? This doesn't even matter.

[Independent]

Are you seriously stupid? This doesn't even matter.

$conn is being called for no reason, and $connect doesn't exist.

:eusa_clap

Own up to your mistake.. I am right, you are wrong.

So by the looks of it, I am better at php than you if you couldn't realize that.

[Source]

//Connect to the mysql database
$conn = mysql_connect("localhost", "user", "password");

//Select DB using the correct connection variable.
mysql_select_db("db", $conn) or die(mysql_error()); 

I'm not sure on need the " around $conn... you don't even really need to define which connection to select the database if you only have that 1.

[Independent]

//Connect to the mysql database
$conn = mysql_connect("localhost", "user", "password");

//Select DB using the correct connection variable.
mysql_select_db("db", $conn) or die(mysql_error()); 

There you go "Lucas" you needed a guide to connect to a database, flipping hell.. YOUR PROJECT IS GOING TO BE MASSIVE, MORE MASSIVE THAN MYSPACE OR BEBO OR ANY OTHER POPULAR WEBSITE! WOAH, LOVE IT MAN.

[Source]

Independant. Leave off, everyone makes silly mistakes every now and then - because they think the problem is deeper than it actually lyes.

So leave it, and grow up a little bit.

[Independent]

Independant. Leave off, everyone makes silly mistakes every now and then - because they think the problem is deeper than it actually lyes.

So leave it, and grow up a little bit.

Lol, "Lucas" seems to notice my mistakes and do the exact same.

[Excellent]

$conn is being called for no reason, and $connect doesn't exist.

:eusa_clap

Own up to your mistake.. I am right, you are wrong.

So by the looks of it, I am better at php than you if you couldn't realize that.

Okay listen now, $conn is my function name. $connect is being used to connect to the database. Since when do $conn and $connect even come to comprehend the same word? Also why do you keep calling me "lucas" congratulations kiddy, you know my name? Oh btw stop thinking you're so brilliant because I fixed it already - nothing you said was suffice.

"OH OH U CANNOT CODE INDEPENDENT LOL U IZ CRAP U FAIL" :rolleyes:

@Matt: Originally I didn't wrap quotes around it but it doesn't really matter, don't get no syntax error.

[Source]

Okay listen now, $conn is my function name. $connect is being used to connect to the database. Since when do $conn and $connect even come to comprehend the same word? Also why do you keep calling me "lucas" congratulations kiddy, you know my name? Oh btw stop thinking you're so brilliant because I fixed it already - nothing you said was suffice.

Listen calm down mate. He was replying on the code that he COULD see from what you posted. How are we meant to know about any functions etc... if you havn't listed or explained it. Don't be so narrow minded.