PHP Problem

ID:278404
 
Jan 26 2011, 11:15 am
Well, i'm new with PHP.

<?
$varfile = @require("Variables.php");
if(!varfile) {
    print "Variables.php file not found";
}
@mysql_connect($server,$username,$password) or die("Unable to connect to MySQL Server ('mysql_error())");
@mysql_select_db($savingdatabase) or die("Unable to find database");
$selectcharacter = "SELECT * FROM 'SavedCharacters' WHERE `key` = '$key'";
$getquery = mysql_query($query);
$querynumrows = mysql_num_rows($getquery);
$number = 0;
while($number < $querynumrows) {
    $data = mysql_result($getquery,$number,"data");
    $number++;
}
@mysql_close();
?>


I'm getting: Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/a7409624/public_html/Load.php on line 10
Jan 26 2011, 12:33 pm
Ocean King wrote:
> $selectcharacter = "SELECT * FROM 'SavedCharacters' WHERE `key` = '$key'";
> $getquery = mysql_query($query);
>


Your query is not $query, it's $selectcharacter.
Jan 26 2011, 12:40 pm
In response to Kuraudo
I'm still getting it. o.O
Jan 26 2011, 12:46 pm
In response to Ocean King
Be 100% sure you didn't typo anything in your SQL command (silly things as caps in tabelnames and whatnot)

EDIT:
I just noticed you've typed
`key`

instead of
'key'

in your SQL string.
Jan 26 2011, 12:53 pm (Edited on Jan 26 2011, 12:59 pm)
In response to Emasym
Edit: Fixed. :P

I was doing in $selectcharacter '$savingtable' instead of `$savingtable`
<?
@require("Variables.php");
@mysql_connect($server,$username,$password) or die("Couldn't connect to MySQL Server");
@mysql_select_db($savingdatabase) or die("Couldn't connect to database");
$selectcharacter = "SELECT * FROM `$savingtable` WHERE 'key' = '$key'";
$getquery = mysql_query($selectcharacter);
$querynumrows = mysql_num_rows($getquery);

if($querynumrows > 0) {
mysql_query("UPDATE `$savingtable` SET `data` = '$data' WHERE `key` = '$key'");
print "Character Successfully Updated";
}else{
mysql_query("INSERT INTO `$savingtable` (`data`,`key`) VALUES ('$data','$key')") or die("Error while inserting your data to database");
print "Character Successfully Added to Database";
}
@mysql_close();
?>


Thanks you all. ^-^
Jan 26 2011, 1:00 pm
In response to Ocean King
I see a lot of ` and I'm not quite sure whether that's accepted.

Just Replace All (copy/paste these:)
` with '

But you're saying your table is called 'savedcharacters' and your SQL string is looking for 'SavedCharacters'. It's case sensitive.
Jan 26 2011, 1:01 pm
In response to Emasym
Yes, i've missed to update that.
Jan 26 2011, 1:08 pm (Edited on Jan 26 2011, 1:15 pm)
In response to Ocean King
 
mysql_query("INSERT INTO `$savingtable` (`data`,`key`) VALUES ('$data','$key')") or die("Error while inserting your data to database");


Works fine, but... When i look on Database. There's nothing on it. I've tryed adding it though Chrome and DM. Both of these didn't work.

var/SaveData = world.Export("[WebSite]/Save.php?data=[list2params(Replace)]&key=[src.key]")
Jan 26 2011, 3:00 pm
In response to Ocean King
I recommend testing out PHP first on an actual website an learning through that first. That way you learn pure PHP/MySQL, and then can convert that information to DM use later.
Jan 26 2011, 6:52 pm
In response to Emasym
Emasym wrote:
(silly things as caps in tabelnames and whatnot)

MySQL is not case sensitive.
Jan 26 2011, 6:59 pm
In response to Loduwijk
Loduwijk wrote:
MySQL is not case sensitive.

Afaik, only SQL keywords are case insensitive themselves.

Names of tables, columns etc, have a case sensitivity which is database dependent - you should probably assume that they are case sensitive unless you know otherwise.

I took a 2 year .NET course, and all our SQL queries where case sensitive there (not the commands, the table/column names). Made me rage a couple of times (huge text string, 1 case error, ungh)
Jan 27 2011, 12:51 am
In response to CauTi0N
CauTi0N wrote:
I recommend testing out PHP first on an actual website an learning through that first. That way you learn pure PHP/MySQL, and then can convert that information to DM use later.

Well, if you mean testing it on website, i did it. But it was saving nothing on fields.

<?
@require("Variables.php");
@mysql_connect($server,$username,$password) or die("Couldn't connect to MySQL Server");
@mysql_select_db($savingdatabase) or die("Couldn't connect to database");
$savedkeyquery = "SELECT * FROM `$savingtable` WHERE `key`='$key'";
$querysavedkey = mysql_query($savedkeyquery);
$numrowssavedkey = mysql_num_rows($querysavedkey);
if($numrowssavedkey > 0) {
    mysql_query("UPDATE `$savingtable` SET `data`='$data' WHERE `key`='$key' LIMIT 1") or die ("Error While inserting your updated data to MySQL Database");
    print "Character Successfully Saved on Database";
}else{
    mysql_query("INSERT INTO `$savingtable` (`key`,`data`) VALUES ('$key','$data')") or die ("Error While inserting your data to MySQL Database");
    print "Character Succesfully Created & Saved";
}
@mysql_close();
?>


I rewrote the code. But still the same, no errors nothing. I've tryed using browser to add it manually.
Jan 27 2011, 11:52 am
In response to Emasym
I just did a test.

Obviously keywords are not case sensitive; we all know that.

Column names are NOT case sensitive.

Table names ARE case sensitive.
mysql> use toner_inventory;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> select * from PrInTeR where iD=1;
ERROR 1146 (42S02): Table 'toner_inventory.PrInTeR' doesn't exist
mysql> select * from printer where iD=1;
+----+----------------+-------------------+----------+
| id | name           | printerModel      | location |
+----+----------------+-------------------+----------+
|  1 | AdmissionsDesk | HP DeskJet 895Cse | F106     |
+----+----------------+-------------------+----------+
1 row in set (0.01 sec)

mysql> select * from printer where Id=1;
+----+----------------+-------------------+----------+
| id | name           | printerModel      | location |
+----+----------------+-------------------+----------+
|  1 | AdmissionsDesk | HP DeskJet 895Cse | F106     |
+----+----------------+-------------------+----------+
1 row in set (0.00 sec)

mysql> select PrInTeRmOdEl from printer where Id=1;
+-------------------+
| PrInTeRmOdEl      |
+-------------------+
| HP DeskJet 895Cse |
+-------------------+
1 row in set (0.00 sec)
Jan 27 2011, 12:34 pm
In response to Loduwijk
Interesting, good to know, thanks for testing that out Loduwijk :)