PHP - 2 Tables Wont Display

I have a table that needs to display data and its formatting should allow a scroll bar after a bit of length. In this case, the below code seems to allow it to continue well past the footer of the page... Did I miss something obvious?

                    <div class="col-md-12">
                        <div class="card card-plain">
                            <div class="header">
                                <h4 class="title">Current Vendors</h4>
                                <p class="category">Vendors listed as active within VendorBase.</p>
                            </div>

							<?php
							$con=mysqli_connect("localhost","root","test","vendors");
							// Check connection
							if (mysqli_connect_errno())
							{
							echo "Failed to connect to MySQL: " . mysqli_connect_error();
							}

							$result = mysqli_query($con,"SELECT * FROM vendor_data");

							echo "                  <div class='content table-responsive table-full-width'>
															<table class='table table-hover'>
																<thead>
																	<th>Name</th>
																	<th>Type</th>
																	<th>Company</th>
																	<th>Email</th>
																	<th>SOC2 Report</th>
																	<th>Status</th>
																	


																</thead>
																<tbody>";
																
																while($row = mysqli_fetch_array($result))
																{
																echo "<tr>";
																echo "<td>" . $row['name'] . "</td>";
																echo "<td>" . $row['type'] . "</td>";
																echo "<td>" . $row['company'] . "</td>";
																echo "<td>" . $row['email'] . "</td>";
																echo "<td>" . $row['soc'] . "</td>";
																echo "<td>" . $row['status'] . "</td>";							
																echo "</tr>";
																}
															
														echo "</table>";
											    echo "</div>";
																mysqli_close($con);
							?>
                                </table>

                            </div>
                        </div>
                    </div>

 

Hey,

Im having a problem where it wont show the members name only TBA, i was wondering if anyone could spot whats wrong

Code - http://pastebin.com/8mEGcTqd
page - http://tw.tghq.org/rosters/hto_roster_blistig.php

Hi all,

I need some help with my code as I've a trouble with sending the emails with images attachments. I'm using Pear Mail library to send the emails so when I send the emails with attachments to gmail, I am unable to see the attached images in my gmail inbox as there is no images show on the bottom of the subject unless when I open on my email so I can see the images attachments. And I am unable to see the images on yahoo when i sent the emails, so I sent a test email on my webmail with the images as attachments and I can see the images on gmail and yahoo with no problem. I think there is a problem with my PHP script that need to be resolve. 

Here is where I am getting the problem with:
       

//attachments
        if (is_array($email_attachments)) {
            foreach ($email_attachments as $attachments) {
                $filename = str_replace('uploads/', '', $attachments);
                $attachment = '';
                $file_path = '';
                $type = '';

                if (strpos($filename, '.png') !== false) {
                    $type .= 'image/png';
                }
    
                // ADD attachment(s)
                $attachment1 .= "--$boundary1\r\n";
                $attachment1 .= "Content-Type: $type; name=\"$filename\"\r\n";
                $attachment1 .= "Content-Transfer-Encoding: base64\r\n";
                $attachment1 .= "Content-Disposition: attachment; filename=\"$filename\"\r\n";
                $attachment1 .= "\r\n\r\n";
                $attachment1 .= $attachment;
                $attachment1 .= "\r\n\r\n";

                $body .= $attachment1;
                $mime->addAttachment($file_path, $type);
            }
        }

 

 

Here is the full code:

<?php

require_once('Mail.php');
require_once('Mail/mime.php');
require_once('Mail/IMAPv2.php');

ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL);

//Connect to the database
include('config.php');

// Connect to the server:
$username = 'myusername';
$password = 'mypassword';
$smtp_hostname = "smtp.mydomain.com";
$port = "587";
$attached_files = array();
$inline_images = array();
global $inline_images;

if (isset($_POST['send_to']))
{
    $from = "Mark <name@mydomain.com>";
    $to_email = $_POST['send_to'];
    $subject = $_POST['email_subject'];
    $message ='<div dir="ltr">' . $_POST['email_body'] . '</div>';
    $email_attachments = $_POST['email_attachment'];
    $total_emails = count($to_email);
    $email_number = $_POST['email_number'];
    $sent_message = $message;
    $attachment1 = '';
    $inline_id = 0.1;
    $success = '';
    $base64 = [];
    $src = [];

    //Check if the images is base64
    if (strpos($message, 'data:image/') !== false)
    {
        // read all image tags into an array
        preg_match_all('/<img.*?src="data:image\/.*;.*,(.*)".*?>/i', $message, $match, PREG_PATTERN_ORDER);
        $base64 = array_pop($match);

        if (is_array($src)) 
        {
            foreach($base64 as $images)
            {
                $type = end(explode('/', (explode(';', $images))[0]));
                $filename = md5(time().uniqid()). '.' . $type;
                $base64_string = str_replace('data:image/png;base64,', '', $images);
                $base64_string = str_replace(' ', '+', $base64_string);
                $decoded = base64_decode($base64_string);
                $fp = fopen("uploads/". $filename, "w+");
                fwrite($fp, $decoded);
                fclose($fp);
            }
        }
    }

    //check if the inline images is in the array
    if (strpos($message, '<img src=') !== false)
    {
        // read all image tags into an array
        preg_match_all('@src="([^"]+)"@' , $message, $match);
        $src = array_pop($match);

        if (is_array($src)) 
        {
            foreach ($src as $key => $value)
            {
                $parsed = parse_url($src[$key]);
                $filename = basename($parsed['path']);
                $content = file_get_contents($src[$key]);

                if (!file_exists($filename))
                {
                    $fp = fopen("uploads/". $filename, "w+");
                    fwrite($fp, $content);
                    fclose($fp);
                }
            }
        }
    }
    $boundary1 = '###'.md5(microtime()).'###';
    $boundary2 = '###'.md5(microtime().rand(99,999)).'###';


    foreach ($to_email as $to)
    {
        $name = '';
        $email = '';


        if (strpos($to, ' <') !== false) {
            $name_str = explode(' <', $to);
            $email_str = explode(' <', $to);
            $name = $name_str[0];
            $email = str_replace('>', '', $email_str);
            $email = $email[1];
        }
        $messageID = sprintf("<%s.%s@%s>",
            base_convert(microtime(), 10, 36),
            base_convert(bin2hex(openssl_random_pseudo_bytes(8)), 16, 36),
            'mydomain.com');
        $message_id = getMessageid(isset($message_id));
        $now = new DateTime();
        $email_id = $now->getTimestamp();
        $sent_date = date('Y-m-d H:i:s');
        $sent_mailbox1 = $link->prepare("SELECT * FROM sent WHERE message_id = ?");
        $sent_mailbox1->execute([$message_id]);
        $emailID = '';
        
        if (!$name == '' && !$email == '') {
            if ($name == $email) {
                $to = $email;
            }
        }


        if ($sent_mailbox1->rowCount() == 0)
        {
            $sent_mailbox1 = $link->prepare("INSERT INTO sent (from_email, to_email, message_id) VALUES (?,?,?)");
    
            if ($sent_mailbox1->execute([$from, $to, $message_id]))
            {
                $emailID = $link->lastInsertId();
            }
        }


        //check if the images is base64
        if (is_array($base64)) 
        {
            $sent_message .= 'http://mydomain.com/u/?id='.$email_id.'&attid='.$inline_id.'&msgid='.$message_id.'&view=attachment&display=view';
            $inline_id += 0.1;
        }
        else if (!$base64 == '') {
            $sent_message .= 'http://mydomain.com/u/?id='.$email_id.'&attid='.$inline_id.'&msgid='.$message_id.'&view=attachment&display=view';
            $inline_id += 0.1;
        }


        //check if the inline images is in the array
        if (is_array($src)) 
        {
            $sent_message .= 'http://mydomain.com/u/?id='.$email_id.'&attid='.$inline_id.'&msgid='.$message_id.'&view=attachment&display=view';
            $inline_id += 0.1; 
        }
        else if (!$src == '') {
            $sent_message .= 'http://mydomain.com/u/?id='.$email_id.'&attid='.$inline_id.'&msgid='.$message_id.'&view=attachment&display=view';
            $inline_id += 0.1;
        }
        $message .= '<img src="http://mydomain.com/track/Images/signature.gif?id='.$emailID.'&etc='.time(). '" ' . 'style="width:0;max-height:0;overflow:hidden" alt="">';


        $headers = array ('From' => $from, 
            'To' => $to, 
            'Subject' => $subject,
            'Reply-To' => $from,
            //'Content-Type'  => 'Content-Type: text/plain; charset="UTF-8"',
            'Content-Type'  => 'Content-Type: multipart/mixed; boundary="=_d909e7abc497193ad3b6636530382391"',
            'MIME-Version' => '1.0',
            'Received' => 'from mail.mydomain.com',
            'Date'  => date("r"),
            'Message-ID' => '<'.sha1(microtime(true)).'@mydomain.com>');


        $crlf = "\r\n";
        $mime = new Mail_mime(array('eol' => $crlf));
        //$mime = new Mail_mime("\r\n");
        $html = $message;
        $text = strip_tags($html);
        $body = $html;

        $mime->setTXTBody($text);
        $mime->setHTMLBody($html);

        //check if the img tags have url called display=view
        if (strpos($message, 'display=view') !== false) {
            $pattern = '@src="([^"]+)"@';
            $message = preg_replace_callback($pattern,"setImageLinks", $message);
    
            foreach ($inline_images as $inline_image) {
                $file_path =  $inline_image;
                $typeInt = imagetype($file_path);
    
                //code goes here to find the imagetype case
                switch ($typeInt) {
                    case IMG_GIF:
                        $imageType = 'image/gif';
                        break;
                    case IMG_JPG:
                        $imageType = 'image/jpg';
                        break;
                    case IMG_JPEG:
                        $imageType = 'image/jpeg';
                        break;
                    case IMG_PNG:
                        $imageType = 'image/png';
                        break;
                    case IMG_WBMP:
                        $imageType = 'image/wbmp';
                        break;
                    case IMG_XPM:
                        $imageType = 'image/xpm';
                        break;
                    default: 
                        $imageType = 'unknown';
                }
                $mime->addHTMLImage($file_path, $imageType);
            }
        }


        //attachments
        if (is_array($email_attachments)) {
            foreach ($email_attachments as $attachments) {
                $filename = str_replace('uploads/', '', $attachments);
                $attachment = '';
                $file_path = '';
                $type = '';

                if (strpos($filename, '.png') !== false) {
                    $type .= 'image/png';
                }
    
                // ADD attachment(s)
                $attachment1 .= "--$boundary1\r\n";
                $attachment1 .= "Content-Type: $type; name=\"$filename\"\r\n";
                $attachment1 .= "Content-Transfer-Encoding: base64\r\n";
                $attachment1 .= "Content-Disposition: attachment; filename=\"$filename\"\r\n";
                $attachment1 .= "\r\n\r\n";
                $attachment1 .= $attachment;
                $attachment1 .= "\r\n\r\n";

                $body .= $attachment1;
                $mime->addAttachment($file_path, $type);
            }
        }

        // always call these methods in this order
        $mime_params = array(
            'text_encoding' => '7bit',
            'text_charset'  => '"UTF-8"',
            'html_charset'  => '"UTF-8"',
            'head_charset'  => '"UTF-8"'
        );
        //$body = $mime->get(array('text_encoding' => '8bit','html_encoding' => '8bit'));
        $body = $mime->get($mime_params);
        $headers = $mime->headers($headers);

        $smtp_params = array ('host' => $smtp_hostname,
            'port' => $port,
            'auth' => true, // Note 1
            'username' => $username,
            'password' => $password);

        $smtp = Mail::factory('smtp', $smtp_params);
        $mail = $smtp->send($to, $headers, $body);
        

        if (PEAR::isError($mail)) 
        {
            echo("<p>" . $mail->getMessage() . "</p>");
        }
        else 
        {
            echo("<p>Email has been sent!</p>");
            $response = array("success"=>$success);
            echo json_encode($response);
        }
    }
}

 

Do you know why the images wont show up on yahoo and gmail when I send the images as attachment?

I have checked on the image path and i have put the correct image path so it should work fine.

If you can be able to test it for me to find out why the images wont display and if you fix the issue, please let me know what change I need to make so I will try it out.

 

Any advice would be much appreciated.

Thanks in advance.

Edited June 5, 2020 by mark107

This is the query which should likes salestrack productid with printers productid, but even though there are data no result is showing and I really dont know why. Please help


Code: [Select]
SELECT salestrack.orderid AS orderid, salestrack.salesman AS salesman, printers.rrp AS price, salestrack.name AS name, salestrack.phone AS phone, salestrack.email AS email, printers.name AS printername, salestrack.orderdate AS orderdate, salestrack.status AS
STATUS
FROM printers, salestrack
WHERE salestrack.productid = printers.productid
AND salestrack.status = 'OPEN'
ORDER BY salestrack.orderdate

I have been playing around with this. Thought I had it nailed, and then found that It was fubar when I started to add more entries to the database. I basically want to display 2 tables from my database on the page. One is called "players" the other is called "editlog".

The output with my current script came out as this:


and here is the dreaded code:
<html>
<body>

<u><h3>Performance Point Monitor (PPM): Knights of Shadow WoW Officers.</h3></u>
<?php
include('/home/a3269923/public_html/ppm/admin/config.php');
include('/home/a3269923/public_html/ppm/admin/dbopen.php');
$query="SELECT * FROM players";
$result=mysql_query($query);
$num=mysql_numrows($result);
?>
<table border="1" style="position:absolute;width:500;height:10;left:0;top:70">
<tr>
<th><font face="Arial, Helvetica, sans-serif">PLAYER</font></th>
<th><font face="Arial, Helvetica, sans-serif">POINTS</font></th>
<th><font face="Arial, Helvetica, sans-serif">DATE</font></th>
</tr>
<?php
$i=0;
while ($i < $num) {
$f2=mysql_result($result,$i,"PLAYER_NAME");
$f3=mysql_result($result,$i,"ND_POINTS");
$f4=mysql_result($result,$i,"DATE ADDED");
?>
<tr>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f2; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f3; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f4; ?></font></td>
</tr>
</table>

<?php
$i++;
}
?>
<?php
include('/home/a3269923/public_html/ppm/admin/config.php');
include('/home/a3269923/public_html/ppm/admin/dbopen.php');

//USER LOG
$query="SELECT * FROM editlog";
$result=mysql_query($query);
$num=mysql_numrows($result);
?>
<table border="1" style="position:absolute;width:600;height:10;left:510;top:70">
<tr>
<th><font face="Arial, Helvetica, sans-serif">USER</font></th>
<th><font face="Arial, Helvetica, sans-serif">TYPE</font></th>
<th><font face="Arial, Helvetica, sans-serif">POINTS</font></th>
<th><font face="Arial, Helvetica, sans-serif">NOTES</font></th>
<th><font face="Arial, Helvetica, sans-serif">DATE</font></th>
</tr>

<?php
$i=0;
while ($i < $num) {
$f1=mysql_result($result,$i,"USER");
$f2=mysql_result($result,$i,"TYPE");
$f3=mysql_result($result,$i,"POINTS");
$f4=mysql_result($result,$i,"NOTE");
$f5=mysql_result($result,$i,"TIMESTAMP");
?>
<tr>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f1; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f2; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f3; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f4; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f5; ?></font></td>
</tr>
</table>

<?php
$i++;
}
?>


What am I doing wrong? Halp!

Hello,   I am trying to display the data from two tables with proper format. But Its not happening   Here is my 1st table - orders   2.PNG   10.12KB   0 downloads   and my 2nd table - order_line_items    1.PNG   14.92KB   0 downloads   I want to display like this     3.PNG   4.03KB   0 downloads   Here is my code

$query = $mysqli->query("SELECT orders.order_id, orders.company_id, orders.order_for, order_line_items.order_id, order_line_items.item, order_line_items.unit,SUM(order_line_items.unit_cost * order_line_items.quantity) AS 'Total', order_line_items.tax from orders INNER JOIN order_line_items ON orders.order_id = order_line_items.order_id where orders.order_quote = 'Order' GROUP BY order_line_items.id"); ?>

<table id="dt_hScroll" class="table table-striped">
						<thead><tr>
						<th>Order ID</th>
						<th>Company</th>
						<th>Contact Person</th>
						<th>Products</th>
                        <th>Total</th>
                        
                        
						
</tr>

</thead>
<tbody> <?php

while($row = $query->fetch_array())
{
?>
<tr>
<td><?php echo $row['order_id']; ?></td>
<td><?php echo $row['company_id']; ?></td>
<td><?php echo $row['contact_person'] ?></td>
<td><?php echo $row['item']; ?></td>
<td><?php echo $row['Total']; ?> %</td>

</tr>
<?php

}	

But here order ID, Company ID, Contact Person are also repeating thrice with item in order_line_items table   Please suggest me how to do this

I am working on a project where I want a select form to display information from a MySQL table. The select values will be different sports (basketball,baseball,hockey,football) and the display will be various players from those sports. I have set up so far two tables in MySQL. One is called 'sports' and contains two columns. Once called 'category_id' and that is the primary key and auto increments. The other column is 'sports' and contains the various sports I mentioned. For my select menu I created the following code.


<?php
#connect to MySQL
$conn = @mysql_connect( "localhost","uname","pw")
or die( "You did not successfully connect to the DB!" );

#select the specified database
$rs = @mysql_SELECT_DB ("test", $conn )
or die ( "Error connecting to the database test!");
?>

<html>
<head>Display MySQL</head>
<body>
<form name="form2" id="form2"action="" >
<select name="categoryID">
<?php
$sql = "SELECT category_id, sport FROM sports ".
"ORDER BY sport";

$rs = mysql_query($sql);

while($row = mysql_fetch_array($rs))
{
  echo "<option value=\"".$row['category_id']."\">".$row['sport']."</option>\n  ";
}
?>
</select>

</form>
</body>
</html>




this works great. I also created another table called 'players' which contains the fields 'player_id' which is the primary key and auto increments, category_id' which is the foreign key for the sports table, sport, first_name, last_name.

The code I am using the query and display the desired result is as follows


<html>
<head>
<title>Get MySQL Data</title>
</head>
<body>
<?php
#connect to MySQL
$conn = @mysql_connect( "localhost","uname","pw")
or die( "Err:Db" );

#select the specified database
$rs = @mysql_SELECT_DB ("test", $conn )
or die ( "Err:Db");

#create the query
$sql ="SELECT *
FROM sports
INNER JOIN players ON sports.category_id = players.category_id
WHERE players.sport = 'Basketball'";

#execute the query
$rs = mysql_query($sql,$conn);

#write the data
while( $row = mysql_fetch_array( $rs) )
{
echo ("<table border='1'><tr><td>");
echo ("Caetegory ID:  " . $row["category_id"] );
echo ("</td>");
echo ("<td>");
echo ( "Sport: " .$row["sport"]);
echo ("</td>");
echo ("<td>");
echo ( "first_name: " .$row["first_name"]);
echo ("</td>");
echo ("<td>");
echo ( "last_name: " .$row["last_name"]);
echo ("</td>");
echo ("</tr></table>");
}
?>
</body>
</html>





this also works fine. All I need to do is tie the two together so that when a particular sport is selected, the query will display below in a table. I know I need to change my WHERE clause to a variable. This is what I need help with.

thanks

Heres what i got...

function printLB1 (){
$result = mysql_query("SELECT * FROM leaderboards ORDER BY CollegeFootballPoints DESC");
while ($row = mysql_fetch_object($result)) {
    $leaderboard[] =  $row->Username;
$leaderboardPoints[] = $row->CollegeFootballPoints;
}
$num = mysql_num_rows($reault);

//I know from here to ...................  needs to be in a var or echo or something.

  <tr>
    <td>1.</td> //This will auto increment too like i++ but i cna do that myself!
    <td>echo $leaderboard;</td>
    <td>echo $leaderboardPoints;</td>
  </tr>

//Here.........................................................

}

I need to pull a table row per user. But i want to somehow do it once in a function and then ill echo the function into a table after the php stuff is done.

Like i want to pull every a table row per user in the function. then display the function below that way i don't have to write a whole extra query and table row per person.

If you understand please help if not please let me know where i can explain more.

Thanks

i need help trying to get this delete feature to work its not deleting from the database (by the way i took out my database names and passwords at the top of the file)

is it possible someone could help me, ive been working on this for like a week and cant figure out the problem. thanks! you can email me at spr_spng@yahoo.com


picture 2.png is showing what it looks like




Code: [Select]
<?php
$host="localhost"; // Host name
$username="username"; // Mysql username
$password="password"; // Mysql password
$db_name="database_name"; // Database name
$tbl_name="table_name"; // Table name

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

$sql="SELECT * FROM $tbl_name";
$result=mysql_query($sql);

$count=mysql_num_rows($result);


?>
<style>
/*table affects look of the whole table look */
table {
margin-left: auto;
margin-right: auto;
border: 1px solid #330000;
border-collapse:collapse;
width:70%;

border-width: 5px 5px 5px 5px;
border-spacing: 1px;
border-style: outset outset outset outset;
border-color: #330000 #330000 #330000 #330000;
border-collapse: separate;
background-color: #330000;


#800517

f535aa

#330000 school color
#9A0000 school color2
#991B1E school color3
#CCCC99 school color4
#9A0000

}
/*th is table header */
th {
text-align: left;
height: 2.5em;
background-color: #330000;
color: #FC0;
font-size:1.5em;
}
/*td is table data or the cells below the header*/
td {
text-align: left;
height:1.0em;
font-size:1.0em;
vertical-align:bottom;
padding:10px;

border-width: 5px 5px 5px 5px;
padding: 8px 8px 8px 8px;
border-style: outset outset outset outset;
border-color: #9A0000 #9A0000 #9A0000 #9A0000;
background-color: #CCCC99;
-moz-border-radius: 0px 0px 0px 0px;

}
</style>
<table width="400" border="0" cellspacing="1" cellpadding="0">
<tr>
<td><form name="form1" method="post" action="">
<table width="400" border="0" cellpadding="3" cellspacing="1" bgcolor="#CCCCCC">
<tr>
<td bgcolor="#FFFFFF">&nbsp;</td>
<td colspan="4" bgcolor="#FFFFFF"><strong>Pick Which Rows you want to delete, Then press delete.</strong> </td>
</tr>
<tr>
<td align="center" bgcolor="#FFFFFF"><strong>Id</strong></td>
<td align="center" bgcolor="#FFFFFF"><strong>Name</strong></td>
<td align="center" bgcolor="#FFFFFF"><strong>Lastname</strong></td>
<td align="center" bgcolor="#FFFFFF"><strong>Email</strong></td>
<td align="center" bgcolor="#FFFFFF">delete</td></tr>
<?php
while($rows=mysql_fetch_array($result)){
?>
<tr>
<td bgcolor="#FFFFFF"><? echo $rows['id']; ?></td>
<td bgcolor="#FFFFFF"><? echo $rows['name']; ?></td>
<td bgcolor="#FFFFFF"><? echo $rows['lastname']; ?></td>
<td bgcolor="#FFFFFF"><? echo $rows['email']; ?></td>
<td align="center" bgcolor="#FFFFFF"><input name="checkbox[]" type="checkbox" id="checkbox[]" value="<? echo $rows['id']; ?>"></td>
</tr>
<?php
}
?>
<tr>
<td colspan="5" align="center" bgcolor="#FFFFFF"><input name="delete" type="submit" id="delete" value="Delete"></td>
</tr>
<?
// Check if delete button active, start this // edited
if($delete){
for($i=0;$i<$count;$i++){
$del_id = $checkbox[$i];
$sql = "DELETE FROM $tbl_name WHERE id='$del_id'";
$result = mysql_query($sql);
}

// if successful redirect to delete_multiple.php
if($result){
echo "<meta http-equiv=\"refresh\" content=\"0;URL=delete_multiple.php\">";
}
}
mysql_close();
?>
</table>
</form>
</td>
</tr>
</table>

This portion is kind of stumping me. Basically, I have a two tables in this DB: users and users_access_level (Separated for DB normalization)

users: id / username / password / realname / access_level
users_access_level: access_level / access_name

What I'm trying to do, is echo the data onto an HTML table that displays users.username in one table data and then uses the users.access_level to find users_access_level.access_name and echo into the following table data, I would prefer not to use multiple queries if possible or nested queries.

Example row for users: 1234 / tmac / password / tmac / 99
Example row for users_access_level: 99 / Admin

Using the examples above, I would want the output to appear as such:

Username: Access Name: Tmac Admin
I am not 100% sure where to start with this, but I pick up quickly, I just need a nudge in the right direction.

The code I attempted to create just shows my lack of knowledge of joining tables, but I'll post it if you want to see that I did at least make an effort to code this myself.

Thanks for reading!

Im doing a search system and Im having some problems. I need to search in two tables (news and pages), I already had sucess doing my search system for just one table, but for two tables its not easy to do. I already use a select statment with two tables using UNION because I want to show number of search results, that is number of returned rows of my first sql statment. But now I need to do a select statment that allows me to acess all fields of my news table and all fields of my pages table. I need to acess in my news table this fields: id, title, content, link, date, nViews I need to acess in my pages table this fields: id, title, content, link Im trying to do this also with UNION, but in this case Im not having any row returning. Do you see what I have wrong in my code?   <?php
//first I get my $search keyword
$search = $url[1];

$pdo = connecting();
//then I want to show number of returned rows for keyword searched
$readALL = $pdo->prepare("SELECT title,content FROM news WHERE title LIKE ? OR content LIKE ?
UNION SELECT title,content FROM pages WHERE title LIKE ? OR content like ?");
$readALL->bindValue(1,"%$search%", PDO::PARAM_STR);
$readALL->bindValue(2,"%$search%", PDO::PARAM_STR);
$readALL->bindValue(3,"%$search%", PDO::PARAM_STR);
$readALL->bindValue(4,"%$search%", PDO::PARAM_STR);
$readALL->execute();
//I show number of returned rows
echo '<p>Your search keyword returned <strong>'.$readALL->rowCount().'</strong> results!</p>';
//If dont return any rows I show a error message
if($readALL->rowCount() <=0){
echo 'Sorry but we didnt found any result for your keyword search.';
}
else{
//If return rows I want to show, if it is a page result I want to show title and link that I have in my page table
//if it is a news result I want to show title and link that I have in my news table and also date of news
echo '<ul class="searchlist">';
$readALL2 = $pdo->prepare("SELECT * FROM news WHERE status = ? AND title LIKE ? OR content LIKE ? LIMIT 0,4
UNION SELECT * FROM pages where title LIKE ? OR content LIKE ? LIMIT 0,4");
$readALL2->bindValue(1, '1');
$readALL2->bindValue(2, "%$search%", PDO::PARAM_STR);
$readALL2->bindValue(3, "%$search%", PDO::PARAM_STR);
$readALL2->bindValue(4, "%$search%", PDO::PARAM_STR);
$readALL2->execute();

while ($result = $readALL2->fetch(PDO::FETCH_ASSOC)){
echo '<li>';
echo '<img src="'.BASE.'/uploads/news/'.$result['thumb'].'"/>';
echo '<a href="'.BASE.'/news/'.$result['id_news'].'">'.$result['title'].'</a>';
//if it is a news result I also want to show date on my list
//echo '<span id="date">'.$result['date'].'</span>';
echo '</li>';
}
echo ' </ul>';
//but how can I do my select statement to have access to my news table fields and my page table fields??
}
?>

I am trying to write some data from multiple SQL tables to a page. In the first table is a list of places. I then have more tables that are named after the different places. For example, say my first place in the list is called Place1. I have a table named Place1 with data that corresponds to place1. The data contained in the table named Place1 is a list of things to do in this place. It has 21 columns and each one is something to do in the morning, afternoon, and at night for each day of the week in the place Place1. What I am trying to do is display a sort of weekly calendar as a table on a webpage that lists all of the places in one column and then lists seven days of the week as 7 more columns. Then in each data cell I would want to list the things to do in the morning, afternoon and at night for the certain day of the week and for the place. The problem is that I am creating a CMS to allow other users with no coding knowledge to update events for other places, so I have to display data that could have been altered.

The only solution I know of is to do a while loop that gets all of the place names and while there are still place names, write the place names to the page and set a variable equal to the place name. Inside the while loop I would create another while loop that each time the first while loop is executed uses the variable set in the first while loop to know which table to reference and then make a call to that table pulling out the 21 columns and writing them to the page. Each time the outer while loop executes, it would (hopefully) write the place name, and then set the variable as the current place name so that the inner while loop uses the variable to write the rest of the information about that place.

I don't know if that would even work and if it did, I know it cannot be the best way to do this. I am pretty stuck here and don't really have a good solution so if anyone proposes a solution that is radically different to anything I have done, I am open to everything. Thank you!

Why isn't this working?


elseif($db_password==md5($password))

For some reason i cannot for the life of me find, from the below code, <? echo $price ?> is returning nothing, could someone please take a look at this and explain to me where I'm going wrong, Would appreciate it tonnes, Thanks Freddy.

Code: [Select]
<?php
//get item information
$AttributeID = mysql_real_escape_string($_GET['AttributeID']);
$sql = "SELECT * FROM attributes as a WHERE a.id = $AttributeID";
$query = mysql_query($sql) or die(mysql_error());
$attribute = mysql_fetch_array($query);
$price = $attribute['SkillPoints'];
//check for attribute
$sql = "SELECT * FROM player_attributes WHERE player_id = $playerID AND attribute_id = $AttributeID";
$query = mysql_query($sql) or die(mysql_error());
$att = mysql_fetch_array($query);
$quan = $att['quantity'];
if ($quan == 0){
$quan = 0;
}else{
$quan = ($quan);
}
if($quan == 0) {
$price = ($price);
}else{
}
if ($quan >='1'){
$price = ($quan + $price);
}
?>

hi guys hope some1 can help. 

im creating a system that will allow stock to be added to a database and modifed.  However on the add section, nothing adds it only inputs a new id row in the database and the other fields are blank.   Can anyone have a look for me
This sections is the form handler once the user has input a stockname and stock qty


Code: [Select]
<?php
session_start();


?>

<!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>stock</title>
</head>

<body>
<?php
$stockname = &$_POST['stockname'];
$stockqty = &$_POST['stockqty'];


$connect = mysql_connect("localhost","root", "") or die ("Couldn't Connect!");
mysql_select_db("stock", $connect) or die("Couldn't find db"); // select database

$query = mysql_query("SELECT * FROM stocks WHERE stockname=$stockname, stockqty=$stockqty");
$numrows = mysql_num_rows($query);


if ($numrows!=0)
{
echo("Item already exists!  Try Updating the items instead!");
}
else
{
$queryreg = mysql_query("INSERT INTO `stock` . `stocks` (`id`, `stockname`, `stockqty`) VALUES (NULL,'$stockname','$stockqty')");

echo("stock added!");
}


?>
<center><table>
<tr>
    <td>
       
        Stock_id
        </td>
        <td>
       
        Stock_name
        </td>
        <td>
       
        Stock_Qty
        </td>
    </tr>
</table></center>
</body>
</html>

Thanks


Lance