theguy0000

when i go to a page called "sql_test.php". the file consists of this code:

[PHP]<?php
if( !$userdata['session_logged_in'] )
{
die("Please login to access this page.");
}

if ($user_data['user_level'] != ADMIN) {
die("You must be an admin to access this page.");
}
else {
// Connecting, selecting database
$link = mysql_connect('host', 'username', 'password')
die('Could not connect: ' . mysql_error());
echo 'Connected successfully';
mysql_select_db('my_database') or die('Could not select database');

// Performing SQL query
$query = "CREATE TABLE sqltest ('' TYPE=default) ALTER TABLE sqltest ADD rowtest TINYINT(1) DEFAULT '1' NOT NULL SELCT * FROM sqltest";
$result = mysql_query($query) or die('Query failed: ' . mysql_error());

// Printing results in HTML
echo "<table>\n";
while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
echo "\t<tr>\n";
foreach ($line as $col_value) {
echo "\t\t<td>$col_value\n";
}
echo "\t</tr>\n";
}
echo "</table>\n";

// Free resultset
mysql_free_result($result);

// Closing connection
mysql_close($link);
}
?>[/PHP]

except, of course, the host, username, and password are the real ones.

the error says

DaWei

Incomplete setting up and blocking of conditional constructs, missing semicolon.

__________________
Abstraction doesn't make it impossible to write bad code; it makes it possible to write superior code.
Contributor's Corner: Grumpy on C++ Exceptions DaWei on Pointers

theguy0000

aww darnit im soo stupid. i just gave you all the info you need to connect to my sql database T_T

please edit that out of your post.

thanks for the help.

DaWei

We don't edit it out of our post, you edit it out of YOUR post or get a moderator to do it. Yeah, lotsa people do that, you gotta catch it .

__________________
Abstraction doesn't make it impossible to write bad code; it makes it possible to write superior code.
Contributor's Corner: Grumpy on C++ Exceptions DaWei on Pointers

theguy0000

lol yeah ill be more careful about that

sykkn

check the following line ...


I think you probably meant ...


or better yet ....

DaWei,

He has edited his user information from his post. Would you do the same to yours?

__________________
[ [ SykkN alloc ] initWithThePowerTo: destroyYouAll ];
/* Don't make me use it! */

skuinders

I think he meant edit your post because you quoted the sensitive information that he posted.
EDIT: sykkn pointed this out.

I saw this when it was first posted and I was going to see if he used that same password for this site and, if so, I was going to log on as him and answer his question, but I got distracted.

__________________
"A stupid man's report of what a clever man says can never be accurate, because he unconciously translates what he hears into something he can understand."
- B. Russell

http://web.bryant.edu/~srk2

DaWei

Oh, lol, the quote....I will get it . Nope, edit time expired, mod will have to do it.....

__________________
Abstraction doesn't make it impossible to write bad code; it makes it possible to write superior code.
Contributor's Corner: Grumpy on C++ Exceptions DaWei on Pointers

sykkn

DaWei, I got it. Thx.

__________________
[ [ SykkN alloc ] initWithThePowerTo: destroyYouAll ];
/* Don't make me use it! */

theguy0000

it tells me there is an unexpecter "or" or something like that.

ill try that.

this is the exact code from the php manual, except [php]if( !$userdata['session_logged_in'] )
{
die("Please login to access this page.");
}

if ($user_data['user_level'] != ADMIN) {
die("You must be an admin to access this page.");
}
else {[/php] and i dont think that would effect how the code works, would it?

edit: now i get an error: maybe im giving it the wrong username/password?