DaniWeb Forum Index > Web Development > PHP

Why won't work?

Please support our PHP advertiser: 50% Off 6 Months Web Hosting from 1&1. The World's #1 Host!

•

Join Date: Oct 2009

Posts: 57

Reputation: web3 is an unknown quantity at this point

Solved Threads: 0

web3

Offline

Junior Poster in Training

Why won't work?

Oct 23rd, 2009

When i put in this code WHERE to='$username' won't work?

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
<?php
$connect = mysql_connect ("localhost","root","") or die (mysql_error());
mysql_select_db ("login4") or die (mysql_error());
session_start();
$_SESSION['username'];
$username = $_SESSION['username'];
$query = mysql_query("SELECT * FROM pm ORDER BY id DESC");
$message = '' ;
while ($row = mysql_fetch_array($query)){
$id = $row['id'];
$to = $row['to'];
$from = $row['from'];
$title = $row['title'];
$date = $row['date'];
$message .= "<tr><td><a href='viewpm.php?&id=".$id."'>".$title."</a><br /></td><td>".$date."<br /></td></tr>";
}
?>
<table width="100%">
<tr><td>Title</td><td>Date</td></tr>
<?php
print $message;
?>
<?php
$connect = mysql_connect ("localhost","root","") or die (mysql_error());
mysql_select_db ("login4") or die (mysql_error());
session_start();
$_SESSION['username'];
$username = $_SESSION['username'];
$query = mysql_query("SELECT * FROM pm ORDER BY id DESC");
$message = '' ;
while ($row = mysql_fetch_array($query)){
$id = $row['id'];
$to = $row['to'];
$from = $row['from'];
$title = $row['title'];
$date = $row['date'];
$message .= "<tr><td><a href='viewpm.php?&id=".$id."'>".$title."</a><br /></td><td>".$date."<br /></td></tr>";
}
?>
<table width="100%">
<tr><td>Title</td><td>Date</td></tr>
<?php
print $message;
?>

•

Join Date: Jun 2007

Posts: 309

Reputation: macneato is an unknown quantity at this point

Solved Threads: 38

macneato

Offline

Posting Whiz

Oct 23rd, 2009

Are you able to print the array?

If this reply solved your problem, please add to my reputation and don't forget to mark this thread as solved.
------------------------------------------------------------

•

Join Date: Sep 2009

Posts: 607

Reputation: network18 is an unknown quantity at this point

Solved Threads: 70

network18

Offline

Practically a Master Poster

Oct 23rd, 2009

It should be this way, thats why -

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
<?php
$connect = mysql_connect ("localhost","root","") or die (mysql_error());
mysql_select_db ("login4") or die (mysql_error());
session_start();
$_SESSION['username'];
$username = $_SESSION['username'];
$query = mysql_query("SELECT * FROM pm where to='".$username."' ORDER BY id DESC");
$message = '' ;
while ($row = mysql_fetch_array($query)){
$id = $row['id'];
$to = $row['to'];
$from = $row['from'];
$title = $row['title'];
$date = $row['date'];
$message .= "<tr><td><a href='viewpm.php?&id=".$id."'>".$title."</a><br /></td><td>".$date."<br /></td></tr>";
}
?>
<table width="100%">
<tr><td>Title</td><td>Date</td></tr>
<?php
print $message;
?>
<?php
$connect = mysql_connect ("localhost","root","") or die (mysql_error());
mysql_select_db ("login4") or die (mysql_error());
session_start();
$_SESSION['username'];
$username = $_SESSION['username'];
$query = mysql_query("SELECT * FROM pm where to='".$username."' ORDER BY id DESC");
$message = '' ;
while ($row = mysql_fetch_array($query)){
$id = $row['id'];
$to = $row['to'];
$from = $row['from'];
$title = $row['title'];
$date = $row['date'];
$message .= "<tr><td><a href='viewpm.php?&id=".$id."'>".$title."</a><br /></td><td>".$date."<br /></td></tr>";
}
?>
<table width="100%">
<tr><td>Title</td><td>Date</td></tr>
<?php
print $message;
?>

provided your column name is 'to' in the pm table