IF ($error = Fixable) { echo "reply!"}

[Choseal]

Dear forum, (=P)

I've got a little problem with one of my scripts:

Line number On/Off | Expand/Contract | Select all

1.             $result = mysql_query("SELECT * FROM achievement ORDER BY achnr ASC");
2.            
3.             $charqry = mysql_query('SELECT * FROM characters WHERE char_name = "'.$_SESSION['charname'].'"');
4.             $return = mysql_fetch_array($charqry);
5.            
6.             while($row = mysql_fetch_array($result))
7.                 {                        
8.                     if($row['conditie'])
9.                        etc.etc.

The if function is not working, it will always run the script, even if the condition is FALSE.

I was debugging this script and turns out if($row['conditie']) returns the right piece of information, but it adds a \ at the start, so for example it will return:

if(\$return['level'] >= 100)

I guess that's why it's not working? -if so, how do I solve it?

[xPrend]

Did you add pieces of PHP in mysql? If yes, give it up make it PHP sided i tried alot of things to do that but no succes make a function script search PHP Function and you will see whate i meant it's even easier then the mysql way.

Whate if you have to get something out of the character table? Like quests or something, how would you do that with mysql that easy, it will be corupted alot of times.

Edit: http://www.w3schools.com/PHP/php_functions.asp

[lmame]

Dear forum, (=P)

I've got a little problem with one of my scripts:

Line number On/Off | Expand/Contract | Select all

1.             $result = mysql_query("SELECT * FROM achievement ORDER BY achnr ASC");
2.            
3.             $charqry = mysql_query('SELECT * FROM characters WHERE char_name = "'.$_SESSION['charname'].'"');
4.             $return = mysql_fetch_array($charqry);
5.            
6.             while($row = mysql_fetch_array($result))
7.                 {                        
8.                     if($row['conditie'])
9.                        etc.etc.

The if function is not working, it will always run the script, even if the condition is FALSE.

I was debugging this script and turns out if($row['conditie']) returns the right piece of information, but it adds a \ at the start, so for example it will return:

if(\$return['level'] >= 100)

I guess that's why it's not working? -if so, how do I solve it?

Do this:
echo("<pre>");
print_r($return);
echo("</pre>");

It should display all values from $return, and show the result of this here.

Do the same for $row (just the first one).

[Choseal]

Although I apreciate everone's help, a friend helped me fix it by doing this:

Line number On/Off | Expand/Contract | Select all

1. $sql = "SELECT * FROM characters WHERE char_name = '$charname' and {$row['conditie']}";
2. $sqlresult = mysql_query($sql);

and then make another while in the while function:

Line number On/Off | Expand/Contract | Select all

1. while($acharray = mysql_fetch_array($sqlresult))

But thanks either way! =3

[Choseal]

One more question, my brain is falling apart:
I am using the explode() function at the moment, and it's working as it should.

But I want to make a function that will check if the $explode result contains $boolres['id'] if you know what I mean, so something like this: (This example will, obviously, not work)

Line number On/Off | Expand/Contract | Select all

1. if($explode contains $boolres['id'])
2. {
3.   echo ("It contains the ID!");
4. }
5. else
6. {
7.   echo ("It does not contain the ID!");
8. }

Ofcourse $explode contains an array, so how would one go around doing something like this?

Edit:
The main problem is, I got it to work a couple of times, the only problem was, it wouldn't actually compair the id with the results from destroy(), so if it's supposed to check for ID 11 in Destroy(), it will say "It does not contain the ID!" -at first, then I refresh the page, then it says "It does contain the ID!". (Because if it doesn't have the ID it adds it to the data cell)

Then I go to my database, and change 11 to 12, and refresh the page, but then it will still say "It contains the ID!", which means it just checks if there is sómething in the data cell, even if it does not match the ID.

I tried using:

Line number On/Off | Expand/Contract | Select all

1. if(!array_key_exists($boolres['id'], $explode))

-But I guess that doesn't work. =P

[Choseal]

Fixed, forgot to use the implode function to put it back in the data cell as a whole.

[Rifke]

To be honest why don't you use a JOIN in your query or a Subquery?

I don't know how your achievement table is set up, but if your achievement table is something in the order of

achvnr, charid, date [table to store a users achievements (achievement)]

achvnr, achvname, achvdesc, acvhsomthing [table to store all achievements (achievement_list) ]

than you can link the achievements to a users easly for example

Line number On/Off | Expand/Contract | Select all

1.  
2. SELECT c.char_name,
3.        ac.date AS 'Achievement Earned',
4.        a.achvname
5. FROM characters AS c
6. INNER JOIN achievement AS ac ON (  ac.charid = c.charid )
7. INNER JOIN achievement_list AS a ON ( a.achvnr = ac.achvnr )
8. WHERE
9.     c.char_name = 'MyCharName'
10.