PHP - Concat Table Name To Column Name

I have a table and one column has links that point to index.php?id= but I want it to display the info of that row of my database. On the index.php page i have this code Code: [Select]
<?php
include "dbaptsConfig.php";

// test id, you need to replace this with whatever id you want the result from
$id = "1";

// what you want to ask the db
$query = "SELECT * FROM `apartments` WHERE `id` = ".$id;

// actually asking the db
$res = mysql_query($query, $ms);

// recieving the answer from the db (you can only use this line if there is always only one result, otherwise will give error)
$result = mysql_fetch_assoc($res);

// if you uncomment the next line it prints out the whole result as an array (prints out the image as weird characters)
// print_r($result);

// print out specific information (not the whole array)
   echo "id: ".$result['id']."<br />";
echo "username: ".$result['username']."<br />";
   echo "type: ".$result['type']."<br />";
   echo "title: ".$result['title']."<br />";
   echo "description: ".$result['description']."<br />";  
echo "county: ".$result['county']."<br />";
   echo "town: ".$result['town']."<br />";
   echo "phone: ".$result['phone']."<br />";
   echo "rooms: ".$result['rooms']."<br />";
   echo "bath: ".$result['bath']."<br />";
   echo "squa  ".$result['square']."<br />";
echo "rent: ".$result['rent']."<br />";
echo "time: ".$result['time']."<br />";

?>I know there is something wrong with this cause I always get the same info no matter which apartment I click. Do I use the $_GET function and how do I implement this?

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; ?>
 

Hello, 
I think this question is a bit of both php and mysql related. I hope I can get some help here. Especially with the mysql part. 

 

I have a table like this:

CREATE TABLE days (
    id INT AUTO_INCREMENT,
      daya INT,
      dayb INT,
    PRIMARY KEY (id)
);


INSERT INTO days VALUES
    (70, 19, 18),
    (69, 20, 17),
    (68, 24, 25),
    (67, 19, 18),   
    (66, 19, 17),    
    (65, 17, 16);

and mysql query and php snippet is this:

 $sql = "SELECT
    d1.id AS id1,
    d2.id AS id2,
    IF((d1.daya-d2.daya)=1,1,0) +
    IF((d1.daya-d2.dayb)=1,1,0) +
    IF((d1.dayb-d2.daya)=1,1,0) +
    IF((d1.dayb-d2.dayb)=1,1,0)   AS tcount
FROM days AS d1 , days AS d2
WHERE d1.id IS NOT NULL AND d2.id IS NOT NULL AND d1.id > d2.id";

  $result = $conn->query($sql);
  if ($result->num_rows > 0) {

   while($row = $result->fetch_assoc()) 
   {
        echo "<tr><td>" . $row["id1"] . "</td><td>". $row["id2"] . "</td><td>" . $row["tcount"]. 
                        "</td></tr>";   
             
    }
echo "</table>";

which gives me a table like this:

Id1  Id2   Count
50    49    1
50    48    0
49    48    0
50    47    1
49    47    1
48    47    0
50    46    1
49    46    1
48    46    0
47    46    1
50    45    1
49    45    1
48    45    0
47    45    1
46    45    1

I need to convert the table into this form: id1 goes down the first column, and id2 is in the first row.  How can i do this, please? can you give me some help? thank you!

id2    49    48    47    46    45
id1                    
50     1      0     1     1     1
49            0     1     1     1
48                  0     0     0
47                        1     1
46                              1
45                    

 

I have a mysql table named songs with 3 columns, id, artist,title.

Most of the songs in the artist column are correct, ex:

artist
------------------
John Denver
Loretta Lynn
Shania Twain
Luke Bryan

But some of the songs in the artist column are reveresed with a comma, ex:

artist
-----------------
Dever, John
Lynn. Loretta
Twain, Shania
Bryan, Luke

Is there an easy php code snippet or mysql statement that i can use to reverse the order of first name and last name and remove the comma in the last example so the artst columd matches the first example?

I hope this makes sense, thanks, Dale.

Hi,
I'm quite new to this and I'm trying to get this to line up in a table with 3 columns (unlimited rows)
I have searched and tried but I'm not having any luck.

Can any one help?
Thank you

Code: [Select]
<?php 
echo '<div class="resultados_sub_cat">';

foreach($this->subcats as $key => $subcat) {

$subcat->link = JRoute::_('index.php?option=classcliff&view=list&catid='.$subcat->id."&Itemid=".$this->Itemid);
if ($key != 0)
echo ' - ';
echo '<a href="'.$subcat->link.'">'.$subcat->name.'</a>';

} 
?>

I'm wondering how to do this with javascript for a table that i have made in php and html.

I want to hide the row for the table based on the value inside my first column for each row of the table.

Like if column 1 has "apple" inside it, then the row would not be shown.
I'm pretty sure this can be done in javascript but i'm not a coding guy, so any help would be appreciated!

My table.php file that has the table i want to do this for:
Code: [Select]
<script language="javascript">

imageX1='plus';
imageX2='plus';
imageX3='plus';

function toggleDisplay(e){
imgX="imagePM"+e;
tableX="table"+e;
imageX="imageX"+e;
tableLink="tableHref"+e;
imageXval=eval("imageX"+e);
element = document.getElementById(tableX).style;
 if (element.display=='none') {element.display='block';}
 else {element.display='none';}
 if (imageXval=='plus') {document.getElementById(imgX).src='http://www.pvpstreams.com/icons/wowicon.png';eval("imageX"+e+"='minus';");document.getElementById(tableLink).title='Hide WoW';}
 else {document.getElementById(imgX).src='http://www.pvpstreams.com/icons/wowicon.png';eval("imageX"+e+"='plus';");document.getElementById(tableLink).title='Show WoW';}
}
</script>

<?php
$username="user";
$password="password";
$tmp="database";

mysql_connect(localhost,$username,$password);
@mysql_select_db($tmp) or die( "Unable to select database");
$query="SELECT * FROM users";
$result=mysql_query($query);

$num=mysql_numrows($result);

mysql_close();
?>
<table class="sortable" id="wow" border="1" cellpadding="0" cellspacing="0" style="margin-left:auto;margin-right:auto;text-align:left">
<tr>
<th><font face="Arial, Helvetica, sans-serif">Game</font></th>
<th><font face="Arial, Helvetica, sans-serif">Character</font></th>
<th><font face="Arial, Helvetica, sans-serif">Rating</font></th>
<th><font face="Arial, Helvetica, sans-serif"><img src="http://www.pvpstreams.com/table-images/xfirelogo.png">&nbsp;Status</font></th>
<th><font face="Arial, Helvetica, sans-serif"><img src="http://www.pvpstreams.com/table-images/xfirelogo.png">&nbsp;Link</font></th>
<th><font face="Arial, Helvetica, sans-serif">Realm</font></th>
<th><font face="Arial, Helvetica, sans-serif"><img src="http://www.pvpstreams.com/table-images/livestreamlogo.png">&nbsp;Status</font></th>
<th><font face="Arial, Helvetica, sans-serif"><img src="http://www.pvpstreams.com/table-images/livestreamlogo.png">&nbsp;Link</font></th>
<th><font face="Arial, Helvetica, sans-serif">Team&nbsp;Setup</font></th>
</tr>

<?php
$i=0;
while ($i < $num) {

$f1=mysql_result($result,$i,"wowcharacter");
$f2=mysql_result($result,$i,"username");
$f3=mysql_result($result,$i,"livestream");
$f4=mysql_result($result,$i,"wowserver");

$f5=mysql_result($result,$i,"wowplayer1");
$f6=mysql_result($result,$i,"wowplayer2");
$f9=mysql_result($result,$i,"wowplayer3");

$f7=mysql_result($result,$i,"wowrealm");
$f8=mysql_result($result,$i,"xfire");
$f10=mysql_result($result,$i,"xfirecheck");
$f11=mysql_result($result,$i,"wowrating");
?>

<tr>
<td><font face="Arial, Helvetica, sans-serif"><?php echo "<center><img src=http://www.pvpstreams.com/table-images/wowtable.png>"; ?></center></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo "<a class=blue href=http://$f4.battle.net/wow/en/character/$f7/$f1/simple>$f1</a>"; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f11; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo "$f10"; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo "<a class=blue href=http://www.pvpstreams.com/xfire.php?user=$f2>$f8</a>"; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f7; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php include("livestreamcheck.php"); ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo "<a class=blue href=http://www.pvpstreams.com/livestream.php?user=$f2>$f3</a>"; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo "<img src=http://www.pvpstreams.com/wclassicons/$f5.png><img src=http://www.pvpstreams.com/wclassicons/$f6.png><img src=http://www.pvpstreams.com/wclassicons/$f9.png>" ?></font></td>
</tr>


<?php
$i++;
}
?>
</table>

I am trying to set the column widths in my HTML 5 script, but what ever I do the widths stay the same?   I found that the <col width=""> tag does not work in HTML 5.   So I tried  <th style="width:130px">Week #</th> and this did not work.   I have also created a special table div style #table1.   Nothing changes when I make these changes!   Here is the table part of my script:
 

<div id="table1">
	<table width="250%" cellspacing="1" border="1" BGCOLOR="white"> 
	

<tr>
<th style="width:130px">Week #</th>
    <th style="width:80px">18</th>
	<th style="width:80px">19</th>
	<th style="width:80px">20</th>
	<th style="width:80px">21</th>
	<th style="width:80px">22</th>
	<th style="width:80px">23</th>
	<th style="width:80px">24</th>
	<th style="width:80px">25</th>
	<th style="width:80px">26</th>	
</tr>
	<tr>
	<td>Visits</td>
	<td>300</td><td>346</td><td>266</td><td>216</td><td>339</td><td>288</td><td>231</td><td>213</td><td></td></tr>	
	<tr>
	<td>From</td>
	<td>28/04/2014</td><td>05/05/2014</td><td>12/05/2014</td><td>19/05/2014</td><td>26/05/2014</td><td>02/06/2014</td><td>09/06/2014</td><td>16/06/2014</td><td>23/06/2014</td>
	</tr>
	<tr>
	<td>To</td>
	<td>04/05/2014</td><td>11/05/2014</td><td>18/05/2014</td><td>25/05/2014</td><td>01/06/2014</td><td>08/06/2014</td><td>15/06/2014</td><td>22/06/2014</td><td>29/06/2014</td>
	</tr>
	<tr>
	<td>USA</td><td>161</td><td>158</td><td>148</td><td>79</td><td>132</td><td>105</td><td>81</td><td>70</td><td></td>
etc.........
</table>	
		</div>

here is my style.css script:

/*
Design by Free CSS Templates
http://www.freecsstemplates.org
Released for free under a Creative Commons Attribution 2.5 License
*/

body {
	margin: 0;
	padding: 0;
	background: #F1F1F1 url(images/img01.gif) repeat-x left top;
	font-family: Arial, Helvetica, sans-serif;
	font-size: 12px;
	color: black;
}
quote {
font-size:medium;
 }

h1, h2, h3 {
	margin: 0;
	padding: 0;
	font-weight: normal;
	color: #023848;
 }


h1 {
	font-size: 4em;
    
}

h2 {
	font-size: 2.4em;
}

h3 {
	font-size: 1.6em;
}

p, ul, ol {
	margin-top: 0;
	line-height: 180%;
}

ul, ol {
font-size:large;
}
ul.a {
list-style-type:circle;
}
ul.b {
list-style-type:square;
}
ol.c {
list-style-type:upper-roman;
}
ol.d {
list-style-type:lower-alpha;
}

a {
	text-decoration: none;
	color: #4486C7;
}
p {
font-size:large;
 }

a:hover {
}

#wrapper {
	width: 980px;
	margin: 0 auto;
	padding: 0;
}

/* Header */

#header {
	width: 980px;
	height: 280px;
	margin: 0 auto;
	padding: 0px;
	background: url(images/head!.png) no-repeat left top;
}

/* Logo */

#logo {
	float: right;
	margin: 0;
	padding: 0;
	
}

#logo h1, #logo p {
	margin: 0;
	padding: 10px;
   
}

#logo h1 {
	float: left;
	padding-top: 223px;
	letter-spacing: -1px;
	text-align: right;
	text-transform: capitalize;
	font-size: 3.8em;
    color: purple;
}

#logo p {
	float: left;
	margin: 0;
	padding: 250px 0 0 10px;
	font: normal 20px Arial, Helvetica, sans-serif;
	font-style: italic;
	 color: purple;
} 

#logo a {
	border: none;
	background: none;
	text-decoration: none;
	 color: black;
}

/* Search */

#search {
	float: right;
	width: 280px;
	height: 60px;
	padding: 20px 0px 0px 0px;
	background: #E2E2E2;
	border-bottom: 4px solid #FFFFFF;
}

#search form {
	height: 41px;
	margin: 0;
	padding: 10px 0 0 20px;
}

#search fieldset {
	margin: 0;
	padding: 0;
	border: none;
}

#search-text {
	width: 170px;
	padding: 6px 5px 2px 5px;
	border: 1px solid #DEDEDE;
	background: #FFFFFF;
	text-transform: lowercase;
	font: normal 11px Arial, Helvetica, sans-serif;
	color: #5D781D;
}

#search-submit {
	width: 50px;
	height: 22px;
	border: none;
	background: #B9B9B9;
	color: #000000;
}

/* Menu */

#menu {
	width: 980px;
	height: 90px;
	margin: 0 auto;
	padding: 0;
}

#menu ul {
	margin: 0;
	padding: 50px 0px 0px 0px;
	list-style: none;
	line-height: normal;
}

#menu li {
	float: left;
}

#menu a {
	display: block;
	width: 100px;
	height: 30px;
	margin-right: 1px;
	padding: 9px 0px 0px 0px;
	background: url(images/img02.gif) no-repeat left top;
	text-decoration: none;
	text-align: center;
	font-family: Arial, Helvetica, sans-serif;
	font-size: 13px;
	font-weight: bold;
	color: #FFFFFF;
	border: none;
}

#menu a:hover, #menu .current_page_item a {
	text-decoration: none;
}

#menu .current_page_item a {
	padding-left: 0;
}

/* Page */

#page {
	width: 940px;
	margin: 0 auto;
	padding: 0px 0px 0px 40px;
	background: url(images/img03.gif) repeat-y left top;
}

#page-bgtop {
	padding: 20px 0px;
}

#page-bgbtm {
}

/* Content */

#content {
	float: left;
	width: 580px;
	padding: 30px 0px 0px 0px;
}

.post {
	background: url(images/img07.gif) no-repeat left 50px;
	margin-bottom: 15px;
}

.post-bgtop {
}

.post-bgbtm {
}

.post .title {
	height: 38px;
	margin-bottom: 10px;
	padding: 12px 0 0 0px;
	letter-spacing: -.5px;
	color: #000000;
}

.post .title a {
	color: #023848;
	border: none;
}

.post .meta {
	margin-bottom: 30px;
	padding: 5px 0px 15px 0px;
	text-align: left;
	font-family: Arial, Helvetica, sans-serif;
	font-size: 13px;
	font-weight: bold;
}

.post .meta .date {
	float: left;
}

.post .meta .posted {
	float: right;
}

.post .meta a {
}

.post .entry {
	background: url(images/img08.gif) no-repeat left top;
	padding: 0px 0px 20px 0px;
	padding-bottom: 20px;
	text-align: justify;
}

.links {
	padding-top: 20px;
	font-size: 12px;
	font-weight: bold;
}

/* Sidebar */

#sidebar {
	float: right;
	width: 280px;
	margin: 0px;
	padding: 0px 20px 0px 0px;
	color: lightgray;
}

#sidebar ul {
	margin: 0;
	padding: 0;
	
}

#sidebar li {
	margin: 0;
	padding: 0;
}

#sidebar li ul {
	margin: 0px 0px;
	padding-bottom: 30px;
}

#sidebar li li {
	line-height: 35px;
	border-bottom: 1px dashed #D1D1D1;
	margin: 0px 30px;
	border-left: none;
}

#sidebar li li span {
	display: block;
	margin-top: -20px;
	padding: 0;
	font-size: 11px;
	font-style: italic;
}

#sidebar h2 {
	height: 38px;
	padding-left: 30px;
	letter-spacing: -.5px;
	font-size: 1.8em;
}

#sidebar p {
	margin: 0 0px;
	padding: 0px 30px 20px 30px;
	text-align: justify;
}

#sidebar a {
	border: none;
}

#sidebar a:hover {
	text-decoration: underline;
	color: #8A8A8A;
}

/* Calendar */

#calendar {
}

#calendar_wrap {
	padding: 20px;
}

#calendar table {
	width: 100%;
}

#calendar tbody td {
	text-align: center;
}

#calendar #next {
	text-align: right;
}
#dtable {

font-size:small;
color:black;

 }
#dtable>h1 {
background: #F1F1F1;
 } 
#table {
font-size:small;
color:black;
text-align:center;
width:200px;
  }
#table1 {
font-size:small;
color:black;
text-align:center;
width:200px;
border: 1px solid black;
table-layout: fixed;
  }
th, td {
border: 1px solid black;
overflow:hidden;
width: 100px;
 }   
/* Footer */

#footer {
	height: 50px;
	margin: 0 auto;
	padding: 0px 0 15px 0;
	background: #ECECEC;
	border-top: 1px solid #DEDEDE;
	font-family: Arial, Helvetica, sans-serif;
}

#footer p {
	margin: 0;
	padding-top: 20px;
	line-height: normal;
	font-size: 9px;
	text-transform: uppercase;
	text-align: center;
	color: #A0A0A0;
}

#footer a {
	color: #8A8A8A;
}

I am completely baffled as to why the widths of the columns does not change when I try to fix the widths.  They are all the same size?   Please enlighten me where I am going wrong?

Hello Guys.   I am having a trouble viewing a specific column content both in phpMyAdmin and console.It only shows a partial info about the contents inside that column.   I have attached a screenshot of this to give you a demonstration inside that link:   http://i59.tinypic.com/2n6ymqf.jpg   as you can see , the user picked hamburger ,steak and ground beef (and some more), but it seems that it stops showing it right in the middle of the word. Is there any limit for characters in this case?   What would be possible to figure that out please?   Thanks in advance..
Edited by osherdo, 17 December 2014 - 09:11 PM.

Hi everyone, I'm having real problems trying to retrieve database records in a 3 column layout, I got there eventually with a huge amount of help.

Unfortunately the code will only display records that are divisable by by three; for example for a database table that has 45 records there is no problem, as all records can be displayed in a 3 column layout. However if the table contains 47 records it won't display the 2 odd records.  My php skills are limited so I need all the help I can get.

I'm a bit desperate to sort this out for a project I'm doing, any help would be greatly appreciated - here is the php code:


$total = count($records);
  $nocol = 3;
  $norows = $total / $nocol;

for ($i=1; $i <= $norows; $i++) {
    $cell = 0;
    echo "<tr>";
    for($col=1; $col <= $nocol; $col++) {
       echo "<td>";
       if
       ($col == 1) {
       $cell += $i;
       echo '<strong class="navtext">'.$records[$cell - 1]['ret_name'].'</strong><br />';
       echo $records[$cell - 1]['ret_add1'].'<br />';
       echo $records[$cell - 1]['ret_add2'].'<br />';
       echo $records[$cell - 1]['ret_town'].'<br />';
       echo $records[$cell - 1]['ret_county'].'<br />';
       echo $records[$cell - 1]['ret_pcode'].'<br />';
       echo $records[$cell - 1]['ret_phone'].'<br />';
       echo $records[$cell - 1]['ret_email'].'<br />';
       echo $records[$cell - 1]['ret_web'].'<br />';
       } else {
        $cell += $norows;
       echo '<strong class="navtext">'.$records[$cell - 1]['ret_name'].'</strong><br />';
       echo $records[$cell - 1]['ret_add1'].'<br />';
       echo $records[$cell - 1]['ret_add2'].'<br />';
       echo $records[$cell - 1]['ret_town'].'<br />';
       echo $records[$cell - 1]['ret_county'].'<br />';
       echo $records[$cell - 1]['ret_pcode'].'<br />';
       echo $records[$cell - 1]['ret_phone'].'<br />';
       echo $records[$cell - 1]['ret_email'].'<br />';
       echo $records[$cell - 1]['ret_web'].'<br />';
       
       }
       echo"</td>";
    }
      echo"</tr>";
} 


I'm also trying to paginate the results, is this actually possible when using a three column layout?  I look forward to any suggestions.

Hi guys I hope I am in the right place on this forum, if not I apologise.

A have been working with CS-Cart and had so much trouble trying to update product combinations so I searched for help on the data feeds I am using and found that there was a script that would update my products for os-commerce, this has worked out even worse.

All I really need is for a script to update one column called amount in a Mysql table by referring to the product_code column, Eg If product_code NS324 is= to 5
ad 5 to the amount column.

This sounds simple but I think it might be complex.

Here is the Table

Generated b\: phpM\Admin 3.4.9 / M\SQL 5.5.20-log
SQL quer\: SELECT * FROM `cscart_product_options_inventor\` LIMIT 0, 30 ;
Rows: 30


Column1-----------Column2---------------Column3--------------Column4----------Column5-------Column6-------Column7
product_id-----product_code---------combination_hash-----combination-------amount----------temp-----------position
--29813--------------NS3455----------- --1447985068-----------738_3059-----------0-----------------N-------------------0

So if I can update the amount column using the product_code would solve all of my problems.

So this is what I need to do, I need to add an amount to the amount column related to the product_code NS3455 or update amount or even replace amount it don't matter.

Due to the nature of the feeds I receive I cannot use product_id or combination_hash or combination.

Please help me do this. Lets see who is the clever one.

Thanks for you time

I have been trying to work out how to get my results into a 3 column layout using css and not using tables in any way.

I found the code for tables:

echo '<table>'; 

$counter = 0; 
$cells_per_row = 3; 
while($row=mysql_fetch_array($result)) 
{ 
    $counter++; 
    if(($counter % $cells_per_row) == 1)  { echo '<tr>'; } 
    echo '<td>' . (whatever you echo from your $row array) . '</td>'; 
    if(($counter %  $cells_per_row) == 0) { echo '</tr>'; } 
} 
// just in case we haven't closed the last row 
// this would happen if our result set isn't divisible by $cells_per_row 
if(($counter % $cells_per_row) != 0) { echo '</tr>'; } 

echo '</table>'; 


How Can I adapt this or how should I use divs here?
I am fine with the css code, just need to work out how to get the 3 column layout correct in the loop.

while($row = mysql_fetch_row($query)) {

echo "<tr>";

echo '<td>' . $row[0] . '</td>';

echo '<td>' . $row[1] . '</td>';

echo '<td>' . $row[2] . '</td>';

echo '<td>' . $row[3] . '</td>';

echo '<td>' . $row[4] . '</td>';

echo "</tr>\n";
}
Currently I have this code. I would like to make it print certain text, let's say... 'car', if the value of table's column 'automobiles' is equal to 0. Otherwise - print the real value.
I've tried if statement and $one = $two... But that apparently didn't worked.

Thanks.

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=313840.0

I have a table of restaurant menu items called menu_items.  This table has a float row(3,2) called price.  I have a query that looks like this:

$query = mysql_query("SELECT * FROM menu_items WHERE restaurant = '".$restaurantid."'");

How would I find the average of the price row from that query?  Basically I want to find the average item price for a restaurants menu.

Hey guys, I'm a little confused to how I can do this.   I am basically wanting to give my first column a 'NOT NULL AUTO_INCREMENT' and give each row it's own 'id'. The issue I am having is that the script I am using truncates the whole SQL table with a CSV file that is cron'd daily to update data.   I am currently using this script:

<?php


$databasehost = "localhost";
$databasename = "";
$databasetable = "";
$databaseusername="";
$databasepassword = "";
$fieldseparator = ",";
$lineseparator = "\n";
$enclosedbyquote = '"';
$csvfile = "db-core/feed/csv/csv.csv";

if(!file_exists($csvfile)) {
die("File not found. Make sure you specified the correct path.");
}

try {
$pdo = new PDO("mysql:host=$databasehost;dbname=$databasename",
$databaseusername, $databasepassword,
array(
PDO::MYSQL_ATTR_LOCAL_INFILE => true,
PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION
)
);
} catch (PDOException $e) {
die("database connection failed: ".$e->getMessage());
}

$pdo->exec("TRUNCATE TABLE `$databasetable`");

$affectedRows = $pdo->exec("
LOAD DATA LOCAL INFILE ".$pdo->quote($csvfile)." REPLACE INTO TABLE `$databasetable`
FIELDS OPTIONALLY ENCLOSED BY ".$pdo->quote($enclosedbyquote)."
TERMINATED BY ".$pdo->quote($fieldseparator)." 
LINES TERMINATED BY ".$pdo->quote($lineseparator)." 
IGNORE 1 LINES");

echo "Loaded a total of $affectedRows records from this csv file.\n";

?>

Is it possible to amend this script to ignore my first column and truncate all of the data in the table apart from the first column?   I could then give all of the rows in the first column their own ID's any idea how I could do this?   I am still very nooby so please go easy on me