PHP - Pulling Images From Another Table In To A Php Result

Hi!

I want the image of my site to be clickable so that it shows the next image contained in the result set of the sql query.

Code: [Select]
<?php
require_once('includes/connection.inc.php');
$conn = dbConnect();
$sql = 'SELECT filename FROM images ORDER BY image_id DESC LIMIT 1';
$msg = '';
if(!$sql) { echo "Something went wrong with the query. Please try again."; }
$result = $conn->query($sql) or die(mysqli_error());
if(mysqli_num_rows($result) == 0) {
header('Location: empty_blog.php');
$conn->close();
} else {
$row = $result->fetch_row();
$image = $row[0];
}
?>
<?php include('header.php'); ?>
<div class="content main">
<img id="image" src="images/<?php echo $image; ?>"/>
</div>
<?php include('includes/footer.inc.php'); ?>

All the filenames of the images are contained correctly in the $result variable, all I need to do now is to fetch the next image in the set. How would I go about this? Any help is greatly appreciated!

Hi there,

I have a site that has several different pages which display products from each category on the designated page.

What I am looking to do is create one page that also lists ALL the products.

Right now, in the category specific page it has this is in the code:
Code: [Select]
$data = get_portfolio_industry('Building Products');
$offset = $_GET['offset'];
if($offset == ''){
$offset = 0;
}
function get_industries($rec_id){
$sql = "SELECT * FROM `".TBL_PORTFOLIO_INDUSTRY."` WHERE `portfolio_id` = '$rec_id'";
$data = SelectMultiRecords($sql);
return $data;
}

And this is the from the functions file:
function get_portfolio_industry($industry){
Code: [Select]
$sql = "SELECT * FROM `".TBL_PORTFOLIO."` WHERE id IN (SELECT `portfolio_id` FROM `".TBL_PORTFOLIO_INDUSTRY."` WHERE `industry` = '$industry') ORDER BY `id`";
$data=SelectMultiRecords($sql);
return $data;
}
My hope was I would simple combine the products like this: Code: [Select]
$data = get_portfolio_industry('Building Products,Building Services,General Products');
...but unfortunately it doesn't combine them. Any thoughts? Any help would be much appreciated.

Hi, I have results from a MySQL table column which does an echo into a table cell, but some of the results from the table column is be empty, so is there a way to fill in the blanks with text like "No data"?  

I am getting  the row results from mysql as called, but they appear as a straight line instead of new table row when I echo like:

echo "TABLETABLETABLETABLE";

I am looking for:

echo "TABLE
          TABLE
          TABLE
          TABLE";

Here is my code:
Code: [Select]

$brand = $_POST['brand'];
$city = stripslashes($_POST['city']);
$state = $_POST['state'];
$zip_code = stripslashes($_POST['zip_code']);


if($city !=""){
$query = "SELECT name, bus_type, street, city, state, zip_code, brand, quantity, price1, price2, date FROM `prices` WHERE city ='".$city."' AND state ='".$state."' AND brand = '".$brand."'";
}else{
$query = "SELECT name, bus_type, street, city, state, zip_code, brand, quantity, price1, price2, date FROM `prices` WHERE zip_code ='".$zip_code."'";
}
$result = mysql_query($query);
 
     $count=mysql_num_rows($result);
if($count==0 && $zip_code !=""){?>

    <td width="100%" class="style9">Sorry! There are no results for that city, state and brand.</td>
 
<?
}else{
   while($row = mysql_fetch_array($result, MYSQL_ASSOC)){
?>
  <td width="100%" class="style9"><?php 
  echo "<table width=\"100%\" border=\"1\" cellspacing=\"0\" cellpadding=\"0\">
  <tr>
     <td{$typ_image}</td>
<td><b><a href=\"\" title=\"{$row['street']} {$row['city']}, {$row['state']}. {$row['zip_code']}\" target=\"_blank\">{$row['name']}</a></b><br>Last Updated:{$row['date']}</td>
    <td><b>{$row['brand']} - {$row['quantity']}</b><br>Before Tax:\${$row['price1']} After Tax:\${$row['price2']}</td>
<td{$pago}</td>
  </tr>
</table><BR>";
  ?></td>
<?php
 }
} 
?></table>   
    <p>&nbsp;</p>
    </td>

Hi, Mary Christmas

My result of mysql database is LIMIT 8; now i have to retrieve and show this to two Horizontal columns As each columns 4 result. how to generate this Without tables!! only with DIV or UL/LI list .

Thanks

Hello!

I have this code

Code: [Select]
<?php

include_once('../database_connection.php');


$thiskeyword = addslashes($_REQUEST['keyword']);

$sqlquery = "Select * from nba_info where player_id like '%$thiskeyword' OR fname like '%$thiskeyword' OR lname like '%$thiskeyword' OR team like '%$thiskeyword' OR email like '%$thiskeyword'";


$result = MYSQL_QUERY($sqlquery);
$numberOfRows = MYSQL_NUM_ROWS($result);


?>





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

<body><center><br /><br />
<?php



if($numberOfRows==0)
{

die('You keywords haven\'t much any data from the database');
        
}
else if($numberOfRows>0)
{
echo $numberOfRows. " Results have been found!";
$i = 0;


?>

<table>
<tr>
    <td>player_id</td>
   
    <td>fname</td>
 
    <td>lname</td>

    <td>team</td>

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

while($i<$numberOfRows)
{

$player_id = MYSQL_RESULT($result,$i,"player_id");
$fname = MYSQL_RESULT($result,$i,"fname");
$lname = MYSQL_RESULT($result,$i,"lname");
$team = MYSQL_RESULT($result,$i,"team");
$email = MYSQL_RESULT($result,$i,"email");


?>



<tr>
   
    <td><? echo $player_id; ?></td>
<td><? echo $fname; ?></td>
<td><? echo $lname; ?></td>
<td><? echo $team; ?></td>
<td><? echo $email; ?></td>

    </tr>

<?php

$i++;

}

?>


</table>

<?php } ?>



<ul>
<li><a href="/php/database/ManipulatingDatabase/add_database.php">Add New Player</a></li>
    <li><a href="/php/database/ManipulatingDatabase/edit_form.php">Edit Player</li>
    <li><a href="/php/database/ManipulatingDatabase/delete_form.php">Delete Player</li>
    <li><a href="/php/database/ManipulatingDatabase/search_form.php">Search Player</li>
    <li><a href="/php/database/ManipulatingDatabase/manipulate_database.php">BACK TO MAIN</a></li>
</ul>




</center>
</body>
</html>

I have no problem with the sql statement as  code

Code: [Select]
echo $numberOfRows. " Results have been found!";
is giving me a numbers of rows. The problem is the rows that have been found is not showing up in the html row.


I wonder what the problem is.. anyone?

I´ve reached to

    <?php require_once('Connections/conexxion.php'); ?>
    <?php
    mysql_select_db($database_conexxion, $conexxion);
    $query_consulta = "SELECT venta,compra,taller,regula_mas,regula_menos,movimiento.id_item,sum(compra+regula_mas-venta-taller-regula_menos)  as stock, cilindro, esfera FROM movimiento  join item on item.id_item=movimiento.id_item join rx on rx.id_rx=item.id_rx join cilindro  on cilindro.id_cil=rx.id_cil  join esfera  on esfera.id_esf=rx.id_esf GROUP BY movimiento.id_item ORDER BY esfera desc, cilindro desc";
    $consulta = mysql_query($query_consulta, $conexxion) or die(mysql_error());
    $row_consulta = mysql_fetch_assoc($consulta);
    $totalRows_consulta = mysql_num_rows($consulta);
    ?>
    <!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>test</title>
    </head>
     
    <body>
     
       <?php
    echo "<table align=center>";
     
    $columnes = 10; # Número de columnas (variable)
     
    if (($rows=mysql_num_rows($consulta))==0) {
      echo "<tr><td colspan=$columnes>No hay resultados en la BD.</td></tr> ";
    } else {
      echo "<tr><td colspan=$columnes>$rows Resultados </td></tr>";
    }
     
    for ($i=1; $row = mysql_fetch_row ($consulta); $i++) {
    $resto = ($i % $columnes); # Número de celda del <tr> en que nos encontramos
    if ($resto == 1) {echo "<tr>";} # Si es la primera celda, abrimos <tr>
       echo "<td>$row[1]</td>";
    if ($resto == 0) {echo "</tr>";} # Si es la última celda, cerramos </tr>
    }
    if ($resto <> 0) { # Si el resultado no es múltiple de $columnes acabamos de rellenar los huecos
    $ajust = $columnes - $resto; # Número de huecos necesarios
    for ($j = 0; $j < $ajust; $j++) {echo "<td>&nbsp;</td>";}
    echo "</tr>"; # Cerramos la última línea </tr>
    }
    mysql_close($connexion);
    echo "</table>";
    ?>
     
     
     
    </body>
    </html>
    <?php
    mysql_free_result($consulta);
    ?>

it "works", but results doesn´t start at number 1 but number 2   anyways, The intent of this table is to show the stock of a product, a lens, that has a range of Rx, we use to see this range this way, and show the stock this way would be very productive, but I can´t figure out how to achive it, any sugestion??  
Edited by gralfitox, 16 December 2014 - 06:45 AM.

I am having so much trouble with this. I want to create a html table that looks like this:
Code: [Select]
<table id="datatable">
 <thead>
  <tr>
   <th></th>
   <th>test</th>
   <th>test 2</th>
  </tr>
 </thead>
 <tbody>
  <tr>
   <th>2011-03-17</th><td>1</td><td>0</td>
  </tr>
  <tr>
   <th>2011-03-18</th><td>3</td><td>2</td>
  </tr>
  <tr>
   <th>2011-03-19</th><td>1</td><td>0</td>
  </tr>
 </tbody>
</table>

out of this mysql result:
opens | name | date
1 | test | 2011-03-17
3 | test | 2011-03-18
2 | test 2 | 2011-03-18
1 | test 2 | 2011-03-19

Here is my mysql code:
Code: [Select]
SELECT count( o.campaign_id ) AS opens, c.name, date(o.created_at) as date FROM opens o LEFT JOIN campaigns c ON c.id = o.campaign_id WHERE (o.created_at between '2011-03-17 00:00:00' and '2011-03-19 23:59:59') GROUP BY date,c.name
I also attached a sql dump of my database.

Hi There,

I have an SQL query that returns 10 rows, which I want to echo over 2 columns and 5 rows, however, I want rows 1-5 on the left hand column and rows 6-10 on the right hand side.

Is there an easy way to do this? Normally I would do a fetch_array but, that would place the rows in order of, left, right, left, right - if that makes sense?

Table is a standard table with 2 columns and 5 rows.

Thanks
Matt

I am retrieving a rowfrom a table and when I post the row variable it doesnt read it.
___
$query = "SELECT * FROM $tbl_name";
   
$result = mysql_query($query) or die(mysql_error());

while($row = mysql_fetch_array($result)){
   echo $row['name'];
   echo "<br />";

$postinfo = 'p_doctor_name=' . $row .'&p_name_type=A&p_search_type=BEGINS';
__
This outputs p_entity_name=&p_name_type=A&p_search_type=BEGINS
Note that it is missing $row

Do I need to put it in an array?

Hi all,

I have a number of tables within a mysql database and I'm stuck on how to pull information from one based on the results being displayed by another.

The site shows items for sale where by all the product information is held in tablea, when an individual item is being displayed I need to be able to pull a manufacturer profile from tableb based on the manufacturer name stored in tablea column profile. The manufacturer name is already being called into the page by existing code as the site has always shown the manufacturer name, I just can't work out out to pull the new profile information in as well from the new table.

Any help appreciated

Iain

OK, Here is the code

$sql = "SELECT
TrialListing.listingID AS Trial, TrialClass.classID AS Class, place.place_name AS Place,
CONCAT_WS(
' ',
pedigree.pretitle,
pedigree.`Name`) AS Hound,
CONCAT_WS(
' ',
ped2.pretitle,
ped2. NAME
)AS Sire,
CONCAT_WS(
' ',
ped3.pretitle,
ped3. NAME
)AS Dam,
pedigree.Breeder,
pedigree.`Owner`,
CASE
WHEN placement.place_id < 5 THEN
TRUNCATE(TrialClass.number_of_entrants / placement.place_id,2)
WHEN placement.place_id  = 5 THEN
''
ELSE
0
END

AS Score
FROM
TrialListing
Left Join TrialClass ON TrialListing.listingID = TrialClass.listingID

JOIN placement ON placement.event_id = TrialClass.trialClassID
JOIN pedigree ON pedigree.PedigreeId = placement.hound_id
LEFT OUTER JOIN pedigree AS ped2 ON pedigree.SireId = ped2.PedigreeId
LEFT OUTER JOIN pedigree AS ped3 ON pedigree.DamId = ped3.PedigreeId
LEFT JOIN place ON place.place_id = placement.place_id

WHERE
TrialListing.listingID = 11
ORDER BY Class, FIELD(place.place_id, '1', '2', '3', '4', '0')


";      // Database Query  

$result = mysql_query("$sql");  // Database Query result

$num_rows = mysql_num_rows($result);





// Starts the table
echo "<table class=\"clubList\">\n
<tr>
<th>trialID</th>
<th>ClassID</th>
<th>Place</th>
<th>Hound</th>
<th>Sire</th>
<th>Dam</th>
<th>Score</th>

</tr>";

// Create the contents of the table.
for( $i = 0; $i < $row = mysql_fetch_array($result); $i++){




echo "<tr>\n"
        ."<td>".$row["Trial"]."</td>\n" 
        ."<td>".$row["Class"]."</td>\n" 
        ."<td>".$row["Place"]."</td>\n"  
        ."<td>".$row["Hound"]."</td>\n"  
        ."<td>".$row["Sire"]."</td>\n"                
        ."<td>".$row["Dam"]."</td>\n"
        ."<td>".$row["Score"]."</td>\n"  
        ."</tr>";}



echo "</TABLE>";


Here is the output, I added the TrialID & ClassID for informational purposes, they do not need to be displayed in the live table.

trialID ClassID Place Hound Sire Dam Score 11 1 1st Eaton Brook Tug Hill Tatonka Eaton Brook Hickety Hawk Eaton Brook Gunner's Beulah 43.00 11 1 2nd FC North Bend Igloo FC DFJ Murphy White IFC Brad-Ju's Bella Donna 21.50 11 1 3rd FC North Bend Igloo FC DFJ Murphy White IFC Brad-Ju's Bella Donna 14.33 11 1 4th Rail Road Spike VI Elwell's Mike Elwell's Hannah 10.75 11 1 NBQ FC Fish Creek Spike Fish Creek Bull II Fish Creek Susie [H849395] 11 2 1st Enman Hill Sweet Poppy FTCH Straight Arrow Lucky of Coos 32.00 11 2 2nd Fishflakes Penny At Harehaven FTCH Jill's Fair-Isle Spud FTCH Millbridge Brownie 16.00 11 2 3rd Line Elm Flakers IFC Flakers Rex IFC Line Elm Ginger 10.66 11 2 4th FTCH Fareast Mookie FTCH Mellowrun Sly FTCH Cape Breton Maude 8.00 11 2 NBQ FTCH Mellowrun Sly Mellowrun Skylighter FTCH Mellowrun Becka 11 3 1st Bojangle V Lee Otworth Half Acre's Cocoa Candy 23.00 11 3 2nd Gay Doll Gay Roll II Gay Idol 11.50 11 3 3rd Bruce's Blue Lady FC Kilsock's Blue Creek Bart Bishopville's Zippy 7.66 11 3 4th FC Pearson Creek Barbin FC Pearson Creek Barbarian FC B-Line Stubby 5.75 11 3 NBQ Sims Creek Cricket Ronnie Joe Sims Creek Tiny 11 4 1st FTCH Fareast Mookie FTCH Mellowrun Sly FTCH Cape Breton Maude 26.00 11 4 2nd FTCH Mellowrun Sly Mellowrun Skylighter FTCH Mellowrun Becka 13.00 11 4 3rd Fishflakes Penny At Harehaven FTCH Jill's Fair-Isle Spud FTCH Millbridge Brownie 8.66 11 4 4th Enman Hill Sweet Poppy FTCH Straight Arrow Lucky of Coos 6.50 11 4 NBQ Line Elm Flakers IFC Flakers Rex IFC Line Elm Ginger
Below is what I would like to generate. How do I word or nest the proper PHP code/loops to accomplish this?

ClassID

Place Hound Sire Dam Score 1st Eaton Brook Tug Hill Tatonka Eaton Brook Hickety Hawk Eaton Brook Gunner's Beulah 43.00 2nd FC North Bend Igloo FC DFJ Murphy White IFC Brad-Ju's Bella Donna 21.50 3rd FC North Bend Igloo FC DFJ Murphy White IFC Brad-Ju's Bella Donna 14.33 4th Rail Road Spike VI Elwell's Mike Elwell's Hannah 10.75 NBQ FC Fish Creek Spike Fish Creek Bull II Fish Creek Susie [H849395]

ClassID

Place Hound Sire Dam Score 1st Enman Hill Sweet Poppy FTCH Straight Arrow Lucky of Coos 32.00 2nd Fishflakes Penny At Harehaven FTCH Jill's Fair-Isle Spud FTCH Millbridge Brownie 16.00 3rd Line Elm Flakers IFC Flakers Rex IFC Line Elm Ginger 10.66 4th FTCH Fareast Mookie FTCH Mellowrun Sly FTCH Cape Breton Maude 8.00 NBQ FTCH Mellowrun Sly Mellowrun Skylighter FTCH Mellowrun Becka

ClassID

Place Hound Sire Dam Score 1st Bojangle V Lee Otworth Half Acre's Cocoa Candy 23.00 2nd Gay Doll Gay Roll II Gay Idol 11.50 3rd Bruce's Blue Lady FC Kilsock's Blue Creek Bart Bishopville's Zippy 7.66 4th FC Pearson Creek Barbin FC Pearson Creek Barbarian FC B-Line Stubby 5.75 NBQ Sims Creek Cricket Ronnie Joe Sims Creek Tiny

ClassID

Place Hound Sire Dam Score 1st FTCH Fareast Mookie FTCH Mellowrun Sly FTCH Cape Breton Maude 26.00 2nd FTCH Mellowrun Sly Mellowrun Skylighter FTCH Mellowrun Becka 13.00 3rd Fishflakes Penny At Harehaven FTCH Jill's Fair-Isle Spud FTCH Millbridge Brownie 8.66 4th Enman Hill Sweet Poppy FTCH Straight Arrow Lucky of Coos 6.50 NBQ Line Elm Flakers IFC Flakers Rex IFC Line Elm Ginger

I am really lost here with this date issue of mine. The below code is the last part of a query:
Code: [Select]
$defendercheck_3 = $row_checkifattacked3['atdate'];
$defendercheck1_3 = strtotime("$defendercheck_3");
$defendercheck2_3 = date("D", $defendercheck1_3);
The query does not return any results as expected, but when echoing the various steps I get following:

echo "$defendercheck3"; = nothing (as expected)

echo "$defendercheck1_3"; = nothing (as expected)

echo "$defendercheck2_3"; =  result! (NOT expected)

why does it return anything on "date("D", $defendercheck1_3)" when "$defendercheck1_3" is blank?

Hello Guys,

I need help on this problem.

output:

display images for the values that exist in the table:

input:

the values in a table's column where they're in the format of "0,0" and the image corresponding to it is named 0,0.png

this is my attempt $q is retrieving "0,0" however in order for me to retrieve its image i need to add ".png" to it in order to find it in the directory that the image is located. It tried without ".png" and it also doesn't work.

$q = 'SELECT ID FROM table'; 
   $dirname = "directory/";
   $images = glob($dirname.$q.".png");
   foreach($images as $image) {
    echo '<img src="'.$image.'" /><br />';