Alex1646 Posted April 24, 2011 Share Posted April 24, 2011 I am trying to take a variable from a database. But it keeps equaling nothing. Ive tried using mysql_error() and sI get nothing. I also keep tryed mysql_num_rows() and I get 3(just what Id exspect). Here is the code. <?php if($userb) { $q1 = " SELECT sub FROM login_info WHERE user='$user_log' LIMIT 1 "; $s1 = mysql_query($q1); $scribe = mysql_fetch_assoc($s1); $sub = explode('![sep]!' ,$scribe['sub']); foreach($sub as $key => $name) { $q2 = " SELECT * FROM subscribe WHERE user = '$name' "; echo 'Llama'; $s2 = mysql_query($q2); $num1 = mysql_num_rows($s2); echo '<h3>' .$name .' Posted ' .$num1 .' Storie(s)! </h3>'; while($stor = mysql_fetch_assoc($s2)); { $story = $stor['stor']; $sid = $stor['sid']; $q3 = " SELECT * FROM story_info WHERE id = $sid "; echo $q3 .'<br />'; $s3 = mysql_query($q3) or die(mysql_error()); $rows = mysql_fetch_assoc($s3); $viewsdb = $rows['views']; $titledb = $rows['title']; $userdb = $rows['user']; $catdb = $rows['cat']; $ratdb = $rows['rating']; $id_db = $rows['story_id']; $sumdb = shorten($rows['sum']); echo "<h3><a href='?p=page&id=$id_db'> $titledb </a> </h3>"; echo "<div id='fun_info'>"; echo "$sumdb <br />"; echo "By <a href='?p=profile&user=$userdb'> $userdb </a> <br /> "; echo "$viewsdb Views | Rated: $ratdb | Catagory: <a href='?p=cat_view&gen=$catdb'> $catdb </a> </div>"; } } } else { login('?p=sub'); } Quote Link to comment Share on other sites More sharing options...
sunfighter Posted April 25, 2011 Share Posted April 25, 2011 Alex you didn't tell us what number your looking for. But the only query that has the mysql_error() with it is the $s3 query. If you don't get an error then the query is running ok. And from the looks of it, it is ok. but I see this in the code that follows: $sumdb = shorten($rows['sum']); shorten() is not a php function and If $sumdb is the number in question I would suspect that. echo $rows['sum'] to see what you have. Quote Link to comment 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.