I am trying to pull information from a database table and display it on a web page the page will display

1. Project Name
2. Status
3. Other

I am using the query below to get the information and number 2 and 3 are working fine but I can't get number 1 to work. I tried multiple different ways and all have failed. The name of the field I am trying to pull is "id" listed in the same table freelancers_bids. The information held for the id will only be displayed if there is a project opened or frozen in which you can see the query below and that is working fine.

How can I amend this so the information in the id field gets displayed also?

 
$tinyres = SQLact("query", "SELECT * FROM freelancers_bids WHERE username='" . $username . "' AND status='open' OR username='" . $username . "' AND status='frozen' ORDER BY date DESC");

You are using * So everything in that table is being pulled. Doesn't appear to be a problem with your MySQL statement.

What I have shown all works fine but when I try to grab the id from the table it isn't working I am not sure what to use to grab the info, as an example I am wondering how to add something like this:

 
FROM freelancers_bids WHERE id='" . $id . "' username='" . $username . "'

But I am not sure how to include the id in there as well because it should only show information when there is an "open" or a "frozen"

The problem isn't with the SQL but with the scripting that is displaying the information.

One thing you might try is having your application output the query (not the result.) Copy and paste it into your SQL monitor/enterprise manager/whatever you use and see what it returns. Then you will have a better idea of what you are doing. Any time I write an SQL query in code and I don't understand the results I'm getting, I always have my program tell me the actual query, and then I paste it into MySQL. After I have it tweaked to extract the data properly, then I put it back into my code.

By the way, don't use select * unless you need EVERY column returned.

I know I am missing something simple if anyone can spot it please let me know.

Here is the complete code that I am using trying to get the out put.

PHP Code:

<table width="100%" border="' . $tableborder . '" cellspacing="' . $tablecellsp . '" cellpadding="' . $tablecellpa . '">
<tr>
<td bgcolor="' . $tablecolorh . '"><small><b><font color=' . $tablecolort . '>Project Name</td>
<td bgcolor="' . $tablecolorh . '"><small><b><font color=' . $tablecolort . '>Status</td>
<td bgcolor="' . $tablecolorh . '"><small><b><font color=' . $tablecolort . '>Other</td>
</tr>';
$tinyres = SQLact("query", "SELECT * FROM freelancers_bids WHERE username='" . $username . "' AND status='open' OR username='" . $username . "' AND status='frozen' ORDER BY id ASC");
$tinyrows = SQLact("num_rows", $tinyres);
if ($tinyrows==0) {
echo '<tr><td bgcolor=' . $tablecolor1 . ' colspan=4><center><small>(Only open & frozen projects are displayed here.)</td></tr>';
} else {
while ($kikrow=SQLact("fetch_array", $tinyres)) {
echo '<tr> <td bgcolor="' . $tablecolor1 . '"><small><a href="' . $siteurl . '/project.php?id=' . $kikrow[id] . '">' . $kikrow[project] . '</a>';
if ($kikrow[special] == "featured") {
echo ' <a href="' . $siteurl . '/featured.php"><img src="' . $siteurl . '/images/featured.gif" alt="Thai Freelancers Featured Project." border=0>';
}
echo '</td> <td bgcolor="' . $tablecolor1 . '"><small>';
if ($kikrow[status] == "open") {
echo '<font color=green><b>' .  $kikrow[status];
} else {
echo '<font color=black><b>' .  $kikrow[status];
}
echo '</td> <td bgcolor="' . $tablecolor1 . '"><small>';
if ($kikrow[chosen] == $username) {
echo 'Bid Won: <a href="' . $siteurl . '/freelancers.php?manage=2&confirm2=' . $kikrow[id] . '">Accept/Deny Offer</a>';
} else {
echo '<a href="' . $siteurl . '/freelancers.php?manage=2&retract=' . $kikrow[id] . '">Retract Your Bid</a>';
}
echo '</td></tr>;
}
} 


I found it I new it was something simple.

It is calling to an empty table with this:

PHP Code:

echo '<tr> <td bgcolor="' . $tablecolor1 . '"><small><a href="' . $siteurl . '/project.php?id=' . $kikrow[id] . '">' . $kikrow[project] . '</a>'; 


Once I changed it to this:

PHP Code:

echo '<tr> <td bgcolor="' . $tablecolor1 . '"><small><a href="' . $siteurl . '/project.php?id=' . $kikrow[id] . '">' . $kikrow[id] . '</a>'; 


The info was out put but for some reason the table for projects is empty when it shouldn't be so now on to look for the problem there.

Good work solving that problem. Let's us know if we can help further.