my_sql_fetch problem

leverkusen · Post by **leverkusen** » Sun Nov 18, 2012 10:19 pm

I did user profile registration system but when i want to go to profile.php or profile.php?uid=3 i get
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in public_html/core/inc/user.inc.php on line 33
That user does not exist.
Now i dont know, is it a problem with a profile.php code, user,inc.php code or maybe hosting?
Profile.php code
[syntax=php]<?php

include('core/init.inc.php');

$user_info = fetch_user_info($_get['uid']);

?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-type" content="text/html; charset=utf-8" />
<title>Global Betting</title>
</head>
<body>
<div>
<?php

if ($user_info === false){
echo 'That user does not exist.';
}else{

?>
<h1><?php echo $user_info['website'] ?> <?php echo $user_info['titles']; ?></h1>
<p>Username: <?php echo $user_info['username']; ?></p>
<p>Grad: <?php echo $user_info['grad']; ?></p>
<p>Drzava: <?php echo $user_info['drzava']; ?></p>
<p>Fan of: <?php echo $user_info['fan']; ?></p>
<p>Website: <?php echo $user_info['website']; ?></p>
<p>Titles: <?php echo $user_info['titles']; ?></p>
<p></p>
<?php
}
?>
</div>
</body>
</html>
[/syntax]

User.inc.php code
[syntax=php]<?php

function fetch_users (){
$result = mysql_query('SELECT `userID` AS `id`, `username` AS `username` FROM `users`');

$users = array();

while (($row = mysql_fetch_assoc($result)) != false){
$users[] = $row;
}

return $users;
}

function fetch_user_info($uid){
$uid = (int)$uid;

$sql = "SELECT
`username` AS `username`,
`grad` AS `grad`,
`drzava` AS `drzava',
`fan` AS `fan`,
`Website` AS `Website`,
`Titles` AS `Titles`
FROM users
WHERE `userID` = '$uid'";

$result = mysql_query($sql);

return mysql_fetch_assoc($result);
}

function set_profile_info($grad, $drzava, $fan, $website, $titles){
$grad = mysql_real_escape_string(htmlentities($grad));
$drzava = mysql_real_escape_string(htmlentities($drzava));
$fan = mysql_real_escape_string(htmlentities($fan));
$website = mysql_real_escape_string(htmlentities($website));
$titles = mysql_real_escape_string(htmlentities($titles));
$uid = $_SESSION['uid'];

$sql = "UPDATE users SET
grad='$grad'
drzava='$drzava'
fan='$fan'
website='$website'
titles='$titles'
WHERE UserID = '$uid'";

mysql_query($sql);
}

?>[/syntax]

ExtremeGaming · Post by **ExtremeGaming** » Mon Nov 19, 2012 1:28 pm

There is most likely a problem with your query. Add [syntax=php]echo mysql_error();[/syntax]

leverkusen · Post by **leverkusen** » Mon Nov 19, 2012 9:37 pm

hmm reply on this post again plz i didnt understand in which of these two scripts to add (i guesss user.inc.php) and what to add?Echo only or $succeed too?

leverkusen · Post by **leverkusen** » Mon Nov 19, 2012 9:39 pm

ohh yea i get echo 'That user does not exist' but exists mhm

Post by **jacek** » Tue Nov 20, 2012 12:21 am

leverkusen wrote:ohh yea i get echo 'That user does not exist' but exists mhm

That is a result of the failing query so don't worry about that for now.

If you add the echo mysql_error() after the query that is failing it will hopefully tell you a bit more about what is wrong, so you want to add it after the mysql_query() line.

leverkusen · Post by **leverkusen** » Tue Nov 20, 2012 11:43 am

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'fan` AS `fan`, `Website` AS `Website`, ' at line 4
grad and drzava dont have this problem, i have all of these in phpmyadmin Users table

ExtremeGaming · Post by **ExtremeGaming** » Tue Nov 20, 2012 12:57 pm

[syntax=php]`drzava` AS `drzava',[/syntax]

You have an apostrophe after drzava instead of a backtick

leverkusen · Post by **leverkusen** » Sat Nov 24, 2012 12:58 am

That helped alot, the only problem now is that i get registered user in user_list, but when i want to visit his profile i just get echo 'That user does not exist'.
but he is registered :S
should i post register script?

ExtremeGaming · Post by **ExtremeGaming** » Sat Nov 24, 2012 4:00 am

Has uid been set in the url? Profile.php?uid=1234

leverkusen · Post by **leverkusen** » Sat Nov 24, 2012 9:48 pm

yea i click on user profile page and it is mysite.com/profile.php?uid=4

Post by **jacek** » Sun Nov 25, 2012 1:44 am

leverkusen wrote:yea i click on user profile page and it is mysite.com/profile.php?uid=4

On this line

[syntax=php]$user_info = fetch_user_info($_get['uid']);[/syntax]
$_get should be $_GET. If you had E_NOTICE level errors on it should have told you about this

leverkusen · Post by **leverkusen** » Sun Nov 25, 2012 2:41 am

Haha incredible!Tnx alot that was the main problem now it works ! 8-)

Post by **jacek** » Mon Nov 26, 2012 6:25 pm

leverkusen wrote:Haha incredible!Tnx alot that was the main problem now it works !

No problem

Glad you got it sorted.

BetterPHP

my_sql_fetch problem

my_sql_fetch problem

Re: my_sql_fetch problem

Re: my_sql_fetch problem

Re: my_sql_fetch problem

Re: my_sql_fetch problem

Re: my_sql_fetch problem

Re: my_sql_fetch problem

Re: my_sql_fetch problem

Re: my_sql_fetch problem

Re: my_sql_fetch problem

Re: my_sql_fetch problem

Re: my_sql_fetch problem

Re: my_sql_fetch problem