PHP - (basic) Searching Database For Entry

Hello, I've tried to get a dynamic table from an external page, and searching for entries in it, so i used a dynamic XLS file using php excel reader. I only exported the file, but i couldn't search for data. Can i get some help please ?

i'm trying to get the username of the last person to enter something into a database table,and display it an html table. the problem is, the query is failing, and i get the error
"Table 'forum.posts' doesn't exist". if in the error message "forum" means the name of the database, and "posts" the name of the table, there is something wrong, as they both exist.

the code i'm using is below

$list = "SELECT * FROM section_main ORDER BY section_title";
$result = mysql_query($list) or die ("Query failed");
$numofrows = mysql_num_rows($result);
for($j = 0; $j < $numofrows; $j++) { 
    $row = mysql_fetch_array($result);  
    echo "<tr><th>". $row['section_title']."</th></tr>";

$query2 = "SELECT * FROM section_sub WHERE section_id = '".$row['section_id']."' ORDER BY section_sub_title";
$result2 = mysql_query($query2) or die("Select Error :" . mysql_error()); 
$numofrows2 = mysql_num_rows($result2);
for($i = 0; $i<$numofrows2; $i++){
$row2 = mysql_fetch_array($result2);
echo "<tr><td><a href='display_forum.php?id={$row2[section_sub_id]}'>".stripslashes($row2[section_sub_title])."</a></td><td>"; 

$new = mysql_query("Select * FROM posts WHERE section_sub_id = '".$row2['section_sub_id'] . " ' ") or die ("Select Error :" . mysql_error()); //this is where the error message is from
$lastpost = mysql_fetch_assoc($new);
echo $lastpost['username']; 

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


i've checked that the names of the tables and fields in the queries are correct, but i cant think of anything else that might be wrong.

any help would be great.

i'm working on a project that stores records of architecture and architects.

What i have to do is create a way for users to search the records in a simple way.

The user can search by Building name, Architect, Location, Date it was built, Building type and architecture style.

Currently i can only search properly by building name, date, type and style. If i add architect to the search query the records screw up when i try to search for the other fields individually..so for example if i add the architect to the query and try to only search by building name the results get screwed up and it displays more results that don't have nothing in comon rather than just display one result which would be the building name

Like i said this only happens if i add the "architect" to the query


Since the architect, location, date, type and style are stored in different tables i search for them first and get the id. Once i've grabbed the ID for those fields i do the actual search to get the buildings that match those records by ID

In the actual query i use the OR statement to search all 5 fields regardless if the user left them empty. So if th user only searches for a building name it the query will basically search for the buildingID OR the rest of the fields as well.

I hope someone here can help me figure out why when i add the architect field to the query the results get screwed up.

I have the code displayed below:

<?php

if(isset($_POST['search'])){

$building  = mysql_real_escape_string($_POST['building']);

$architect = stringForUrl($_POST['architect']);

$date = mysql_real_escape_string($_POST['date']);

$style = mysql_real_escape_string($_POST['style']);

$type = mysql_real_escape_string($_POST['type']);

$find_building = mysql_query("SELECT * FROM points WHERE name LIKE '$building'") or die(mysql_error());

$tmp_building = mysql_fetch_assoc($find_building);

$buildingID = $tmp_building['id'];

$find_architect = mysql_query("SELECT * FROM architects WHERE full_name LIKE '$architect'") or die(mysql_error());

$tmp_architect = mysql_fetch_assoc($find_architect);

$architectID = $tmp_architect['id'];

$find_style = mysql_query("SELECT * FROM styles WHERE name LIKE '$style'") or die(mysql_error());

$tmp_style = mysql_fetch_assoc($find_style);

$styleID = $tmp_style['id'];

$find_type = mysql_query("SELECT * FROM types WHERE name LIKE '$type'") or die(mysql_error());

$tmp_type = mysql_fetch_assoc($find_type);

$typeID = $tmp_type['id'];

}

?>
<?php

if(isset($_POST['search'])){

$session_arch_id = $_SESSION['architect_id'];
//query that does the actual search 
$get_search_points = mysql_query("SELECT * FROM points WHERE id='$buildingID' OR style_id='$styleID' OR type_id='$typeID'  OR architect_id='$architectID' OR date='$date' ORDER BY name") or die(mysql_error());

$num_search_points = mysql_num_rows($get_search_points);

print($get_search_points);

?>
                            <h3>Architecure on the map</h3>
                            <span id="num_buildings">Showing <?php echo $num_search_points; ?> buildings</span>
                            <table width="605" cellspacing="0" cellpadding="5" border="0" id="wam_results-tbl">
                            

<tr class="search_headings">
                                

<td width="156">Building Name</td>
                                    <td width="114">Architect</td>
                                    <td width="45">Date</td>
                                    <td width="144">Building Type</td>
                                    <td width="96">Style</td>
                                </tr>
                                <?php

while($points = mysql_fetch_assoc($get_search_points)){

$point_type_id = $points['type_id'];

$point_style_id = $points['style_id'];

$point_architect_id = $points['architect_id'];

$point_firm_id = $points['firm_id'];

?>
                                <tr>
                                

<td><?php echo $points['name']; ?></td>
                                    <td>
                                    <?php

if(!empty($point_architect_id)){

$get_architect = mysql_query("SELECT * FROM architects WHERE id='$point_architect_id'") or die(mysql_error());

$architect = mysql_fetch_assoc($get_architect);

echo ''.$architect['first_name'].' '.$architect['last_name'].'';

}elseif(empty($point_architect_id)){

$get_firm = mysql_query("SELECT * FROM firms WHERE id='$point_firm_id'") or die(mysql_error());

$firm = mysql_fetch_assoc($get_firm);

echo $firm['name'];

}

?>
                                    </td>
                                    <td><?php echo $points['date']; ?></td>
                                    <td>
                                    <?php

$get_types = mysql_query("SELECT * FROM types WHERE id='$point_type_id'") or die(mysql_error());

$type = mysql_fetch_assoc($get_types);

echo $type['name'];

?>
                                    </td>
                                    <td>
                                    <?php

$get_styles = mysql_query("SELECT * FROM styles WHERE id='$point_style_id'") or die(mysql_error());

$style = mysql_fetch_assoc($get_styles);

echo $style['name'];

?>
                                    </td>
                                </tr>
                                <?php

}

?>
                            </table>
                            <?php

}

?>

so ik you cna get a search box to search items or text in a database, but what i want to know is how to manually insert text and images into it example

image (imagine its an image) text name - text price

how would i do this?

I'm working on an old cms I built a few years ago and for some reason my Delete page isn't working.  It has to be something simple I'm overlooking.  The database connection is made just above this code and is pulling the thumb and title listed by id.  When I push delete I'm getting the cmd=delete&id=2 passed on so something is up with my last if statement (I think).  Here is the code:

if(!isset($cmd)) 
{
   //display all the news
   $result = mysql_query("select * from verizon order by id"); 
   

   
   //run the while loop that grabs all the news scripts
   while($r=mysql_fetch_array($result)) 
   { 
      //grab the title and the ID of the enws
      $title=$r["title"];//take out the title
      $id=$r["id"];//take out the id
      $thumb=$r["thumb"];
      
      echo "<div id='delete'>
            <table>
<tr>
  <td width='350px'><strong>$title</strong></td><td><a href='verizondelete.php?cmd=delete&id=$id'>  Delete</a></td>
</tr>
<td colspan='2' align='center'><img src='../upload/verizon/$thumb'></td>
    </table>
         
          </div><br />";
    }
}

if($cmd=="delete")
{
    $sql = "DELETE FROM verizon WHERE id='$id'";
    $result = mysql_query($sql);
    echo "<h1 style='text-align:center;'>deleted!</h1>";
} 

}
?>