Shoutbox

pfft, MySql is evil, satins preferred language.

anyway.

code:

---

$database = 'rcbb';
$table = 'post';
$usernametable= 'users';
$query="SELECT * FROM `$usernametable` WHERE `username` = '$Username' ";

---

^^ this code doesnt work.

quote:

---

Originally posted by PHP Error


Warning: mysql_result(): supplied argument is not a valid MySQL result resource in c:\program files\easyphp1-7\www\create.php on line 23

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in c:\program files\easyphp1-7\www\create.php on line 24

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in c:\program files\easyphp1-7\www\create.php on line 25

---

but...

code:

---

$query="SELECT * FROM `$table` WHERE `id` = '$ThreadID' ";

---

works in a different script, username and password is pre-varibilised.

if you need more information ill post it.

does anyone know why?

*this is going to be hard to write scince my dog is sitting on my keyboard

can u post your code where u connect to the db and select it , send data to it and stuff
because

code:

---

$database = 'rcbb';
$table = 'post';
$usernametable= 'users';
$query="SELECT * FROM `$usernametable` WHERE `username` = '$Username' ";

---

does nothing cept set variables 

blahh get on msn and ill kick the dog off my keyboard and help you more

i know that.

i just use the

code:

---

$result = mysql_query($query);

---

btw i cant come on msn until 8:30pm.

cheers anyway.

posting the full script would help us to help you

=/ have u even connected to your database lol
Using something like

code:

---

$sql = mysql_connect($loc,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");

---

=/ and why cant u come on your on the forums lol or is it the "sharing" thing?

just post all your code lol or pm it to me

quote:

---

Originally posted by -dt-
=/ have u even connected to your database lol
Using something like

code:

---

$sql = mysql_connect($loc,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");

---

=/ and why cant u come on your on the forums lol or is it the "sharing" thing?

just post all your code lol or pm it to me

---

pfft, didnt i say the second one worked?

im not that stupid you know.

btw, im not gonna post whole script, she's my precious.

How about echo mysql_error(); straight after the query?