PHP - Query Output To Table Help

Ok, I know this is a really simple one, but I haven't done any coding for a couple of month and i'm a bit rusty.

I'm trying to add a field from a MySQL query to a Google calendar add button link so I can create a dynamic 'add to calendar' button from my gig list.

So on the gig list page that echo's all the dates from the database, I want to add the venue name to the 'text' section of the google URL -

Code: [Select]
<a href=\"http://www.google.com/calendar/event?action=TEMPLATE&text=VENUE HERE&dates=20060101T000000Z/20060101T000000Z&details=gig%20text&location=gig%20town&trp=false&sprop=www.the-guards.co.uk&sprop=name:The%20Guards\" target=\"_blank\"><img src=\"http://www.google.com/calendar/images/ext/gc_button6.gif\" border=0></a>
if I echo the field like so -

Code: [Select]
echo"{$row['gl_venue']}";
I get the correct result - I just can remember how to embed the php within the html, everything i've tried has failed so far.

Once i've got this sorted i can go ahead and add the date, location fields etc.

Hi, I need a quick tip. I want this script to produce an output of "Table created" if it succesfully creates a table.

<?php
$con = mysql_connect("localhost","****","****");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

// Create table
mysql_select_db("my_db", $con);
$sql = "CREATE TABLE People
(
FirstName varchar(15),
LastName varchar(15),
Age int
)";

// Execute query
mysql_query($sql,$con);

mysql_close($con);
?> 

I tried to do it on my own, but I guess I'm still completely new to php 
I tried:
<?php
$con = mysql_connect("localhost","****","****");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

// Create table
if (mysql_select_db("my_db", $con))
  {
  echo "Table created";
  }
else
  {
  echo "Error creating Table: " . mysql_error();
  }
$sql = "CREATE TABLE People
(
FirstName varchar(15),
LastName varchar(15),
Age int
)"


// Execute query
mysql_query($sql,$con);

mysql_close($con);
?> 

It gave me an error with the last two lines
mysql_query($sql,$con);

mysql_close($con);

 I removed them and it really did give the output "Table created" yet it didn't create the table in the database. I'm having a feeling that I need to add an "if" statement, something of the sort.

if (sql(CREATE TABLE Persons))

But I'm also getting the feeling something there is wrong, I still haven't tried it. 

Help?

Hi,

Stuck again with the Joomla/K2 coding.  Trying to output this field in a 2 column table but failing badly.  Any help or ideas would be greatly appreciated.

     <?php if($this->item->params->get('catItemExtraFields') && count($this->item->extra_fields)): ?>
     <!-- Item extra fields -->
     <div class="catItemExtraFields">
        <h4><?php echo JText::_('K2_ADDITIONAL_INFO'); ?></h4>
        <ul>
         <?php foreach ($this->item->extra_fields as $key=>$extraField): ?>
         <?php if($extraField->value): ?>
         <li class="<?php echo ($key%2) ? "odd" : "even"; ?> type<?php echo ucfirst($extraField->type); ?> group<?php echo $extraField->group; ?>">
            
            
               <?php if ($extraField->name =='Closing date') : ?>

                    <span class="catItemExtraFieldsLabel"><?php echo $extraField->name; ?></span>
                      <span class="catItemDateCreated"><?php echo JHTML::_('date', $this->item->publish_down ); ?></span>
                    <?php else :?>
                     <span class="catItemExtraFieldsLabel"><?php echo $extraField->name; ?></span>
                    <span class="catItemExtraFieldsValue"><?php echo $extraField->value; ?></span>
       
                    <?php endif; ?>
               
         </li>
         <?php endif; ?>
         <?php endforeach; ?>
         </ul>
       <div class="clr"></div>
     </div>
     <?php endif; ?>
 

I have a function which finds a list of companies associated with a country from a custom taxonomy. It finds their logo and creates an output which is all logos associated with a country, and the logo has a href to link to a company page. The code for this is:

function countryCompanies(){

global $post;

    $echo = f_print(array(
        'data' => 'p2p',
        'type' => 'mainlogo',
        'args' => array(
            'connection_type' => 'client'.$_set['lang_postfix'].'_to_location'.$_set['lang_postfix'].'',
            'post_type' => 'client',
            'connection_id' => $post->ID,
            'alternative' => "",
        ),
));

 

The f_print function finds the logos, and their sizes. So the 'mainlogo' type is a pull down of the thumbnail at 200px size.

 

What I need to do is write CSS and PHP which will display these results in a grid, 4 colums across, and as many down as results from the array. At the moment all I can get is all the results in one column.

What tutorials would I need to write appropriate CSS to create this, and then is it as simple as adding the div prior to the echo of the $echo variable?

Thanks

I'm having some trouble with displaying my white space between words. I have a table that holds records for resumes, and the administrator can access each record and edit them. I have the record displayed in text boxes for editing, but the white space between words is not showing up. Only the first word will show up. I have tried changing the field type in the table to text or blob instead of varchar, and I have tried using the nl2br function when displaying the records, but that isn't working either. What am I doing wrong? Here is my edit page:

Code: [Select]
<?php

$applicant = "SELECT * FROM applicants WHERE id = '$_GET[id]'";
$applicant_res = mysql_query($applicant, $conn) or die(mysql_error());

$display_block = "<h3>Edit Entry</h3>
<p>To edit the entry, change any relevant information below:</p>

<form method=post action=update_U3IP.php><table>";

while ($applicants_list = mysql_fetch_array($applicant_res)){
$id = $applicants_list['id'];
$firstname = $applicants_list['firstname'];
$lastname = $applicants_list['lastname'];
$address = $applicants_list['address'];
$city = $applicants_list['city'];
$state = $applicants_list['state'];
$zip = $applicants_list['zip'];
$phone = $applicants_list['phone'];
$position = nl2br($applicants_list['position']);
$file = $applicants_list['resume'];

$display_block .= "
<table>
<tr>
<td><label for=id><b>ID:</b></label></td>
<td><input name=id type=text size=2 id=id value=$id /></td>
</tr>
<tr>
<td><label for=firstname><b>First Name:</b></label></td>
<td><input name=firstname type=text size=20 id=firstname value=$firstname /></td>
</tr>
<tr>
<td><label for=lastname><b>Last Name:</b></label></td>
<td><input name=lastname type=text size=20 id=lastname value=$lastname /></td>
</tr>
<tr>
<td><label for=address><b>Address:</b></label></td>
<td><input name=address type=text size=20 id=address value=$address /></td>
</tr>
<tr>
<td><label for=city><b>City:</b></label></td>
<td><input name=city type=text size=20 id=city value=$city /></td>
</tr>
<tr>
<td><label for=state><b>State:</b></label></td>
<td><input name=state type=text size=20 id=state value=$state /></td>
</tr>
<tr>
<td><label for=zip><b>Zip:</b></label></td>
<td><input name=zip type=text size=20 id=zip value=$zip /></td>
</tr>
<tr>
<td><label for=phone><b>Phone:</b></label></td>
<td><input name=phone type=text size=20 id=phone value=$phone /></td>
</tr>
<tr>
<td><label for=position><b>Position:</b></label></td>
<td><input name=position type=text size=20 id=position value=$position /></td>
</tr>
<tr>
 <td><b>Uploaded Resume:</b></td>
 <td><input type=text name=file id=file value=$file /></td>
 </tr>
 <tr>
 <td colspan=2>&nbsp;</td>
 </tr>
 <tr>
 <td colspan=2 align=center>
 <input type=hidden name=hidden_id id=hidden_id value=$id />
<input type=submit value=Submit />
<a href=admin_U3IP.php><input type=button name=back id=back value=Back /></a></td>
</tr>";

}

$display_block .= "</table></form>";

?>

<!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>KulaE_WDP4451_U3IP</title>
</head>
<body>
<?php echo $display_block; ?>
</body>
</html>

Hi guys I am new here

I have had a search around and can't really find out how to do this. Its quite difficult for me to explain and I am really new to PHP / mySQL - just starting out really. I hope to learn from doing small projects like this and seeing how it gets done.

So I have a mySQL DB with two different tables - one is called "notesnew" the other is called "users".

I have modified a common tutorial on how to make a "to do list" for what I am doing here.

Basically users can login and post messages on this list as them self. Each user's post appears as a list item, showing their username, the time they posted the message and the message content. The message content, time and owner of the message is stored in the "notesnew" table.

The list of user's, their passwords and their "avatar/profile" image URL location is stored in the "users" table.

Now I am having trouble getting each user's avatar image from being output next to each of their posts. The part that is confusing me is being able to match up the username's post with their content that is display - because I am posting the user's name along with their post, based on the logged in "session name" as their username. So basically, all the content being listed is being displayed from the "notesnew" table. I need to somehow figure out what each user's profile image is based on what is stored against their entry in the "users" table.

Here is the code I have so far. It is not working properly - it displays all content etc, but displays the avatar / image of the last user that has registered. Can anyone help me out here with some code that works, or pointers to try follow? I know the $finduserprofile part is incorrect in the way it goes through all user's and finds their profileimg, and that the image displayed next to each post is therefore incorrect (as it displays the last member to have registered's avatar, but its just that I don't know how else to do what I am trying to do.

Code: [Select]
<?php
//Connect to the database
$connection = mysql_connect('localhost', 'zzzz' , 'zzzzzzz');
$selection = mysql_select_db('zzzzz', $connection);

$username = $_COOKIE['ID_my_site'];

//Was the form submitted?
if($_POST['submit']){

//Map the content that was sent by the form a variable. Not necessary but it keeps things tidy.
$content = $_POST['content'];

//Insert the content into database
$ins = mysql_query("INSERT INTO `notesnew` (content, owner, dp_time) VALUES ('$content', '$username', NOW())");

//Redirect the user back to the members or index page
header("Location:index.php");
}

/*Doesn't matter if the form has been posted or not, show the latest posts*/

//Find all the notes in the database and order them in a descending order (latest post first).
$find = mysql_query("SELECT * FROM `notesnew` ORDER BY id DESC");
$finduserprofile = mysql_query("SELECT * FROM `users` ORDER BY id DESC");

//Setup the un-ordered list
echo '<ul>';

while($row = mysql_fetch_array($finduserprofile))
{
$imagelocation = $row['profileimg'];
//Continue looping through all of them
while($row = mysql_fetch_array($find))
        {

$owner = $row['owner'];
//For each one, echo a list item giving a link to the delete page with it's id.
echo '<li>' . '<img src ="' . $imagelocation . '">' . $row['owner'] . ' said at ' . $row['dp_time'] . ': ' . $row['content'] . ' <a id="' . $row['id'] . '" href="delete.php?id=' . $row['id'] . '"><img src="delete.png" alt="Delete?" /></a></li>';

}
}

//End the un-ordered list
echo '</ul>';

?>

Hello All,

Iam completely new (3days old) to sql, php, html, so could do with a little help.
Ok so I just found out about this wonderfull world and thought i would give it a try and I like it.

But as I have no real idea of what Iam doing Iam finding it abit tricky to change some of the code I found at.
http://www.phpfreaks.com/tutorial/simple-sql-search
By the way thanks for this.
So far I have setup a wamp server and got it all working fine and tweeked the above details in the url.
This works great (well chuffed).
But I could do with changing two things for now.

1). I could do with beeing able to search multiple things in the one text box for example.
If I inputed "hello world" or "hel wor" it would search through the 19,000 lines in my database and find all instances of "hello" and "world" or "hel" "wor" in the same line's, it dosent matter what column they are in and output those lines. The code has the option to search all feilds "matchall" but not multiple words or parts of words.(hope that made sense I dont know all the terminology)
It could be like using wild cards I suppose??.
Is this possible or would I need multiple search boxes and if so how would I do that?

2). I would like the results to be returned in a table with headings for each column.

If any one can help this would be great and thanks in advance for checking the long post out.

Nick.

Sorry if this is out there already but not to sure what I need to search for!??!?!?


Ill include what Iam using so far.



<?php
$dbHost = 'localhost'; // localhost will be used in most cases
// set these to your mysql database username and password.
$dbUser = 'root';
$dbPass = '';
$dbDatabase = 'Stk_search'; // the database you put the table into.
$con = mysql_connect($dbHost, $dbUser, $dbPass) or trigger_error("Failed to connect to MySQL Server. Error: " . mysql_error());

mysql_select_db($dbDatabase) or trigger_error("Failed to connect to database {$dbDatabase}. Error: " . mysql_error());

// Set up our error check and result check array
$error = array();
$results = array();

// First check if a form was submitted.
// Since this is a search we will use $_GET
if (isset($_GET['search'])) {
   $searchTerms = trim($_GET['search']);
   $searchTerms = strip_tags($searchTerms); // remove any html/javascript.

    if (strlen($searchTerms) < 3) {
        $error[] = "Search terms must be longer than 3 characters.";
    }else {
          $searchTermDB = mysql_real_escape_string($searchTerms); // prevent sql injection.
    }
             
     // If there are no errors, lets get the search going.
     if (count($error) < 1) {
     $searchSQL = "SELECT id, Stock_Code, SV_Part_Number, SV_Description, SV_Search_Key FROM stkdb1 WHERE ";
     
     // grab the search types.
     $types = array();
     $types[] = isset($_GET['Stock_Code'])?"`Stock_Code` LIKE '%{$searchTermDB}%'":'';
     $types[] = isset($_GET['SV_Part_Number'])?"`SV_Part_Number` LIKE '%{$searchTermDB}%'":'';
     $types[] = isset($_GET['SV_Description'])?"`SV_Description` LIKE '%{$searchTermDB}%'":'';
     $types[] = isset($_GET['SV_Search_Key'])?"`SV_Search_Key` LIKE '%{$searchTermDB}%'":'';
     
     $types = array_filter($types, "removeEmpty"); // removes any item that was empty (not checked)
     
     if (count($types) < 1)
      $types[] = "`Stock_Code` LIKE '%{$searchTermDB}%'"; // use the body as a default search if none are checked
     
      $andOr = isset($_GET['matchall'])?'AND':'OR';
      $searchSQL .= implode(" {$andOr} ", $types) . " ORDER BY `Stock_Code`"; // order by title.
     
      $searchResult = mysql_query($searchSQL) or trigger_error("There was an error.<br/>" . mysql_error() . "<br />SQL Was: {$searchSQL}");
     
       if (mysql_num_rows($searchResult) < 1) {
            $error[] = "The search term provided {$searchTerms} yielded no results.";
        }else {
        $results = array(); // the result array                                                 
        $i = 1;
        while ($row = mysql_fetch_assoc($searchResult)) {
          $results[] = "{$i}: {$row['Stock_Code']}<br />{$row['SV_Part_Number']}<br />{$row['SV_Description']}<br />{$row['SV_Search_Key']}<br /><br />";
          $i++;
          }
          }
          }
          }

 
function removeEmpty($var) {
  return (!empty($var));
  }
           
?>
<html>
   <title>My Simple Search Form</title>
    <style type="text/css">
    #error {
    color: red;
   }
   </style>
    <body>
      <?php echo (count($error) > 0)?"The following had errors:<br /><span id=\"error\">" . implode("<br />", $error) . "</span><br /><br />":""; ?>
      <form method="GET" action="<?php echo $_SERVER['PHP_SELF'];?>" name="searchForm">
            Search For: <input type="text" name="search" value="<?php echo isset($searchTerms)?htmlspecialchars($searchTerms):''; ?>" /><br />
            Search In:<br />
            Stock_Code: <input type="checkbox" name="Stock_Code" value="on" <?php echo isset($_GET['Stock_Code'])?"checked":''; ?> /> |
            SV_Part_Number: <input type="checkbox" name="SV_Part_Number" value="on" <?php echo isset($_GET['SV_Part_Number'])?"checked":''; ?> /> |
            SV_Description: <input type="checkbox" name="SV_Description" value="on" <?php echo isset($_GET['SV_Description'])?"checked":''; ?> /> |
            SV_Search_Key: <input type="checkbox" name="SV_Search_Key" value="on" <?php echo isset($_GET['SV_Search_Key'])?"checked":''; ?> /><br />
              Match All Selected Fields? <input type="checkbox" name="matchall" value="on" <?php echo isset($_GET['matchall'])?"checked":''; ?><br /><br />
            <input type="submit" name="submit" value="Search!" />
          </form>
          <?php echo (count($results) > 0)?"Your search term: {$searchTerms} returned:<br /><br />" . implode("", $results):""; ?>

         </body>
        </html> 

In this output table, I would like to be able to click on any number in the ama row, add .html to that value and then execute the link.

Example: If the ama number in row 3 is 890543, add .html to the number = 890543.html, then click on it to link to that web page.


<?php // Connect to database =========================================

include("connect_db.php");
$table1='passwords';
$table2='airplanes';

// send query ===================================================

$result = mysql_query("SELECT * FROM $table2") or die(mysql_error());  

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

echo "<table border='10' cellpadding='3' cellspacing='2'>";
echo "<p>View All Airplanes</p>";

echo "<tr> <th>ID</th> <th>AMA #</th> <th>Model Name</th> <th>Model MFG</th><th>Wingspan</th><th>Engine</th><th>Decibels</th></tr>";

// keeps getting the next row until there are no more to get ================

while($row = mysql_fetch_array( $result )) {

// Print out the contents of each row into a table ==========================

echo "<tr><td>";

echo $row['id'];

echo "</td><td>"; 

echo $row['ama']; // Append .html to this number

echo "</td><td>"; 

echo $row['model_name'];

echo "</td><td>"; 

echo $row['model_mfg'];

echo "</td><td>"; 

echo $row['wingspan'];

echo "</td><td>"; 

echo $row['engine'];

echo "</td><td>"; 

echo $row['decibels'];

echo "</td></tr>"; 
} 

echo "</table>";

?>

if I'm outputting from mysql with this:

Code: [Select]
// Connects to your Database
 mysql_connect("localhost", "root", "") or die(mysql_error()) ;
 mysql_select_db("test") or die(mysql_error()) ;
 
 //Retrieves data from MySQL
 $data = mysql_query("SELECT * FROM tickets") or die(mysql_error());

//Puts it into an array
while($info = mysql_fetch_array( $data )) {
//Outputs the image and other data


 Echo "<b>asset number:</b> ".$info['AssetNumber'] . "<br> ";
 Echo "<b>subject:</b> ".$info['subject'] . " <br>";
 Echo "<b>notes:</b> ".$info['Notes'] . " <hr>"; }
can I base the record it outputs somehow on this:

Code: [Select]

$value="";
$value = ProcessLargeText(GetData($data,"Asset Number", ""),"","",MODE_VIEW);
if($mainTableOwnerID=="Asset Number")
$ownerIdValue=$value;
$xt->assign("Asset_Number_value",$value);
if(!$pageObject->isAppearOnTabs("Asset Number"))
$xt->assign("Asset_Number_fieldblock",true);
else
$xt->assign("Asset_Number_tabfieldblock",true);

It's kind of like a job history so its getting records of job history from one table while the second piece of code is getting the asset details from a main table

Hi guys, is there anyway to process this $result from a mysql query inside PHP so that the data below will be formatted to a pivot-like table? The number of rows and columns of the output 'table' will be indefinite. Thanks so much!

Data:
ID   Row   Col   Name
1   1   A   A1
2   2   A   A2
3   3   A   A3
4   1   B   B1
5   2   B   B2
6   3   B   B3
7   1   C   C1
8   2   C   C2
9   3   C   C3


Results:
A1(1)   A2(2)   A3(3)
B1(4)   B2(5)   B3(6)
C1(7)   C2(   C3(9)

Well I have a script that executes a scan on a system set to run infinitely, and I need it to echo out a message each time it loops through, but I don't want it to echo out the message with the next loop message below it, and the next one below that etc... I've tried using the flush(); function and been messing around with that with no luck. For security reasons I don't want to release any of the processing code, but here is the basic construction of the script:

<?PHP
***PROCESSING AND SCAN CODE***
***PROCESSING AND SCAN CODE***
***PROCESSING AND SCAN CODE***
***PROCESSING AND SCAN CODE***
$RepeatIt = -1;
for($g=1; $g!=$RepeatIt+1; $g++)
{
***PROCESSING AND SCAN CODE***
***PROCESSING AND SCAN CODE***
***PROCESSING AND SCAN CODE***
***PROCESSING AND SCAN CODE***

$ScanMessage = ":.:.: SCANNING THE HITLIST FOR MOBSTER: ".$MobName." (SCAN #$g) :.:.:"."<br/><br/>";
echo $ScanMessage;

***PROCESSING AND SCAN CODE***
***PROCESSING AND SCAN CODE***
***PROCESSING AND SCAN CODE***
***PROCESSING AND SCAN CODE***
}
?>

At the moment it's returning:

:.:.: SCANNING THE HITLIST FOR MOBSTER: DEUS EX DESTROYER (SCAN #1) :.:.:

:.:.: SCANNING THE HITLIST FOR MOBSTER: DEUS EX DESTROYER (SCAN #2) :.:.:

:.:.: SCANNING THE HITLIST FOR MOBSTER: DEUS EX DESTROYER (SCAN #3) :.:.:

:.:.: SCANNING THE HITLIST FOR MOBSTER: DEUS EX DESTROYER (SCAN #4) :.:.:

So what I want it to do is just delete the scanning message and replace it with the next scan message so while running this script you would see just the number increment on the same line.

Any suggestions?

Thanks.

Ok so standard query can be written as:

SELECT * FROM my_table WHERE specific_field = 'some_term'
Is there some query that I can search for 'some_term' in all the fields at once in my_table without defining them in the query? 

SELECT * FROM my_table WHERE any_field = 'some_term'

Hi,

I dont know if many of you have heard of bitcoins? its just a virtual currency with real value...

I have got the daemon running for it, and have connected it to PHP.

The code i am using to return all transactions is:

Code: (php) [Select]
print_r($bitcoin->listtransactions("")); echo "\n";


This will return:

Quote

Array
(
    => Array
        (
            [account] =>
            [address] => 1ALtJaqGiShyGMVNRNn77E67PuBKc9FLyo
            [category] => receive
            [amount] => 0.001
            [confirmations] => 13
            [txid] => 0f36872c60da25b29ff3a8efa91d931e26fe1a4354da280f3 d69234c8b521c8c
            [time] => 1314115260
        )

    [1] => Array
        (
            [account] =>
            [category] => move
            [time] => 1314115550
            [amount] => -0.001
            [otheraccount] => 4
            [comment] =>
        )

)



How could i output this info into a table instead of the above?

Thanks

Hi guys I need your help,

I am trying already for days to sort it out but does not work.
My file "pback.php" displays the mysql table "sp_users". I want to add the columns "school_name" and "school_address" from another table "sp_schools" (same database) at the right end of the displayed table in "pback.php" (after the column update)
I tried with leftjoin but it does not work.
Please help me. I am getting really frustrated.
Thank you...

Code: [Select]
<?php
$host="xxx"; // Host name
$username="xxx"; // Mysql username
$password="xxx"; // Mysql password
$db_name="xxxx"; // Database name
$tbl_name="sp_users"; // Table name

// Connect to server and select database.
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");

$sql="SELECT * FROM $tbl_name ORDER BY user_id";
$result=mysql_query($sql);
?>
<style type="text/css">
<!--
.style2 {font-weight: bold}
.style3 {
font-family: Arial, Helvetica, sans-serif;
color: #000000;
}
.style10 {font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; color: #000000; }
-->
</style>

<title>User overview</title><table width="486" border="0" align="left" cellpadding="0" cellspacing="1" bgcolor="#996600">
<tr>
<td width="427">
 
    <div align="left">
      <table width="486" border="1" cellspacing="0" cellpadding="3">
        <tr>
          <td colspan="4"><div align="center" class="style1 style3"><strong>SchoolPorta.com Users </strong></div></td>
        </tr>
        <tr>
          <td width="26" align="center"><span class="style2">id</span></td>
          <td width="70" align="center"><span class="style2">Name</span></td>
          <td width="114" align="center"><span class="style2">Lastname</span></td>
          <td width="146" align="center"><span class="style2">Email</span></td>
          <td width="88" align="center"><span class="style2">Update</span></td>
        </tr>
        <?php
while($rows=mysql_fetch_array($result)){
?>
        <tr>
          <td><span class="style10"><? echo $rows['user_id']; ?></span></td>
          <td><span class="style10"><? echo $rows['user_first_name']; ?></span></td>
          <td><span class="style10"><? echo $rows['user_surname']; ?></span></td>
          <td><span class="style10"><a href="mailto:<?php echo $rows['user_login']; ?>"><?php echo $rows['user_login']; ?></a></span></td>
          <td align="center"><a href="update.php?id=<? echo $rows['user_id']; ?>" class="style10">update</a></td>
        </tr>
        <?php
}
?>
      </table>
    </div></td>
</tr>
</table>

<div align="left">
  <p>&nbsp;  </p>
  <p>&nbsp;</p>
  <p>&nbsp;</p>
  <p>
    <?php
mysql_close();
?>
  </p>
</div>

Hi, I have a fantasy football website, and on a user account page I want to display fixtures that are coming up that include teams that the current user has chosen. My test_teams table stores all the team names and their teamid. The test_selections table is where each users team selections are stored, it has two columns, userid and teamid. The test_fixtures table has two columns, hometeam and awayteam, these two cloumns hold the teamid of the teams that are playing.

The code below correctly displays the fixtures that contain any of the current users team selections. However, it is only displaying the teamid of the teams that are playing as they have not been matched to the test_teams table to get the team name. Does anybody now how I can do this? I believe it can be done using a left join but so far I just keep getting errors when i try to write the code. Any help would be very much appreciated.

Code: [Select]
<table width="380" border="0">
<?php
$query = "SELECT test_fixtures.competition, test_fixtures.date, test_fixtures.hometeam, test_fixtures.awayteam FROM test_fixtures, test_selections WHERE test_selections.userid = '{$_SESSION['userid']}' AND (test_selections.teamid = test_fixtures.hometeam OR test_selections.teamid = test_fixtures.awayteam)";
        $result = mysql_query($query) or die(mysql_error());
        
        while($row = mysql_fetch_assoc($result))
{
?>
<tr>
<td width="85" class="fixtures_date"><?php echo $row['date']; ?></td>
<td width="30" class="fixtures_comp"><?php echo $row['competition']; ?></td>
<td width="135" class="fixtures_home_teams"><?php echo $row['hometeam']; ?></td>
<td width="25" class="fixtures_center">v</td>
<td width="135" class="fixtures_away_teams"><?php echo $row['awayteam']; ?></td>
</tr>
<?php
}
?>
</table>