PHP - Simple Php, Mysql

I have a site where I built two tables that house user information and their story information. The site is kind of like a blog in that people can post their own own stories about their relationships. Basically the story table has all the stories information like id, title, body etc and the posting persons id. The second table has the users info such as id first name, last name, etc. I have a story.php which is dynamic in that it grabs information based on the url so if there is story 2 the link would be story.php?sid=2. So what happens is the information is pulled based on that sid and in turn the posting users id is pulled via a while loop where i create variables for every column in the table. What I want is to be able to run basically two while loops on inside the other in order to get information based on the initial while loop column uid (users id). I don't know if this is clear but this is what I've build:

Code: [Select]
function story() {

// connection information
include 'includes/connection.php';

$sid = "23";

// mysql connection
mysql_connect("$host", "$user", "$pass") or die(mysql_error());
mysql_select_db("$dbname") or die(mysql_error());

// grabs all story information
$squery = ("SELECT * FROM $stable WHERE sid = '$sid'");
$sresult = mysql_query($squery) or die(mysql_error());
$fullstory = '';

while($srow = mysql_fetch_array($sresult)){

// grab variables for the story
$ssid = $srow['sid']; // stories id
$title = $srow['title'];
$body = $srow['body'];
$keywords = $srow['keywords'];
$suid = $srow['uid']; // the posting users id
$sdate = $srow['date'];
$accusedfname = $srow['accusedfname'];
$accusedlname = $srow['accusedlname'];
$location = $srow['location'];
$accusedfacebook = $srow['accusedfacebook'];
$accusedmyspace = $srow['accusedmyspace'];
$accusedimage = $srow['accusedimage'];

// mysql connection
mysql_connect("$host", "$user", "$pass") or die(mysql_error());
mysql_select_db("$dbname") or die(mysql_error());

// grabs all information on the posting user
$uquery = ("SELECT * FROM $utable WHERE uid = '$suid'");
$uresult = mysql_query($uquery) or die(mysql_error());

// grabs the posting users information
while($urow = mysql_fetch_array($uresult)){
$uid = $urow['uid'];
$fname = $urow['fname'];
$lname = $urow['lname'];
$image = $urow['image'];

$fullstory .= '
<div id="story-wrap">
<div class="story-image">
<p>
The Accused: '.$accusedfname.' '.$accusedlname.'<br/>
<a target="_blank" href="'.$accusedimage.'"><img src="'.$accusedimage.'" alt="'.$accusedfname.' '.$accusedlname.'" title="'.$accusedfname.' '.$accusedlname.'" /></a>
</p>
<p>
The Accuser: <a href="user-profile.php?uid='.$uid.'">'.$fname.' '.$lname.'</a><br/>
<a target="_blank" href="'.$image.'"><img src="'.$image.'" alt="'.$fname.' '.$lname.'" title="'.$fname.' '.$lname.'" /></a>
</p>
</div>

<div class="story-copy">
<h3><a href="user-profile.php?uid='.$uid.'">'.$fname.' '.$lname.'</a> wrote: '.$title.'</h3>
<p>'.$body.'</p>
<p>Posted on: '.$sdate.'<br/>
The accused"s <a href="'.$accusedfacebook.'">Facebook</a><br/>
The accused"s <a href="'.$accusedmyspace.'">Myspace</a><br/>
The accused"s <a href="'.$location.'">'.$location.'</a>
</div>
</div>
';
}
}
return $fullstory;
}

When I run this I get some errors, I tried tweaking the code ending the loops once the variables had been built then just echoing the information out after but that just wouldn't echo anything out and what I got was a blank screen. If anyone can help it would be greatly appreciated! Thanks

I have a page on my site which displays a picture that I have stored on my server. The loaction of that picture is stored in mysql. All the images are .jpg format.  My question is, if I allow a user to upload 5 pictures instead of just 1,  is there a simple script that would show each picture for about 2-3 seconds, the go to the next? Basically like an auto slideshow.  Each picture has an ID that associates with the name of the category, so I could just call that ID and have the slideshow only show those pictures.  So I'm just wondering about the slideshow script.

Well, basically I am making my log in script. This is my first website with php and MySQL... actually, its my first website I have done that isn't for a school project.

Anywho, the problem I am having is I can't seem to verify the password of the account I am trying to log into.

Here is the code snippet I am having trouble with:

$usr = $_REQUEST['Username'];
$pass = $_REQUEST['Password'];
$pass = md5($pass);
if(mysql_query('SELECT Password FROM Accounts WHERE Username = "' .$usr . '"') == $pass)
{
session_start();
$_SESSION['loggedin'] = yes;
$_SESSION['User'] = $usr;
$_POST['info'] = ("You have successfully logged in " . $usr . ".");
} else { $_POST['info'] = "Username and password do not match.";}


The problem is that it doesn't seem to matter if the username and password are correct, it always prints "Username and password do not match.".

So, here is the table layout of 'Accounts':


Did I type the mysql query wrong?

I have a database called "postvoting", It's basically to store when somebody votes on a particular posts. I store the post_id that the user votes on, the users id that voted on it, and the date.
What I want to do is find the most popular posts in a given time.

So if 4 people voted on the post with the id of 1, and 2 people voted on the post with the id of 2, I want to count the number of rows with post_id='1'

A non working example what I want would look something like:
$count_votes = mysql_query("SELECT * FROM postvoting WHILE post_id=post_id");
print mysql_num_rows($count_votes);
result: 4

or
$count_votes = mysql_query("SELECT * FROM postvoting GROUP BY post_id");
print mysql_num_rows($count_votes);
result: 4

(counting the number of results in a group)

Hope this isn't too confusing. (I've confused myself with this).

Not really sure what to ask because I don't know what the problem is. Maybe just need a fresh set of eyes to find out whats wrong.
I am trying selecting content from a database table but its not working.  I am not getting any errors just a blank screen where the content should be displayed.

html
Code: [Select]
<table>
<tbody>
<tr>
<th>Topic</th>
<th>Name</th>
<th>Date</th>
  </tr>
  <?php include 'server/forum.php'; ?>
</tbody>
</table>

php
Code: [Select]
<?php

require_once('load_data.php');

$con = mysql_connect($db_host, $db_user, $db_pwd);

if (!$con)
{
die('Could not connect to database: ' . mysql_error());
}

$dbcon = mysql_select_db($database);

if (!$dbcon)
{
  die('Could not select database: ' . mysql_error());
}

$sql = "SELECT * FROM $table ORDER BY id";
$result = mysql_query($sql) or die("Error ". mysql_error(). " with query ". $sql);

if (!$result) 
{
die("Query to show fields from table failed:".mysql_error());
}

$row = mysql_fetch_array($result)

while($row)
{
echo '<tr>';    
echo '<td class="forumtd"><b>';
echo '<a href="topic.php?id='.$row['id'].'">'.stripslashes(htmlspecialchars($row['topic'])).'</a>';
echo "</b></td>";
echo '<td class="forumtd"><em>';
echo stripslashes(htmlspecialchars($row['name']));
echo "</em></td>";
echo '<td class="forumtd">';
echo date("l M dS, Y", $row['date']);
echo "</td>";
echo "</tr>";
}

mysql_close($con);

?>