MstrGmrDLP Posted April 6, 2014 Share Posted April 6, 2014 So my code <? $reqcount = mysql_query("SELECT * FROM friend_reqs WHERE user_to={$_SESSION['user']['user_id']} AND user_from!={$_SESSION['user']['user_id']}"); $reqs = sizeof($reqcount);?> I have 3 requests for the user and it only shows 1. What is the problem? Quote Link to comment https://forums.phpfreaks.com/topic/287570-php-query-not-working-properly/ Share on other sites More sharing options...
DavidAM Posted April 7, 2014 Share Posted April 7, 2014 mysql_query returns a resource, NOT the query results. You need to fetch the data. Other comments: 1) The mysql library is deprecated, use mysqli (mysqli) 2) Don't use short tags "<?", use full tags: "<?php" 3) Use SELECT COUNT(*) if you want a count, don't return all of the data if you don't need it Quote Link to comment https://forums.phpfreaks.com/topic/287570-php-query-not-working-properly/#findComment-1475179 Share on other sites More sharing options...
Solution MstrGmrDLP Posted April 10, 2014 Author Solution Share Posted April 10, 2014 I had already fixed this by the time you posted that. Thanks for trying to help. Sorry for wasting your time. Quote Link to comment https://forums.phpfreaks.com/topic/287570-php-query-not-working-properly/#findComment-1475619 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.