PHP - Dinamically Add Rows/columns To Table Depending On Number Of Results...

Hi, Im not sure whether this is a PHP or MySQL question, but im trying to get a select menu to only display the number of options that are defined in the mysql database.   For example   The code I have that retrieves the $quantity from the database.   Lets say that   $quantity = 3   Now I would like the option menu to only display three options, like this:

<select name="quantity">
<option value="<?php echo $quantity ?>"><?php echo 'Maximum of ' . $quantity . ' available'?></option>
<option value="1">1</option> 
<option value="2">2</option>
<option value="3">3</option>
</select>

but for example, if the $quantity was equal to 10 then I would like the menu to be displayed as such

<select name="quantity">
<option value="<?php echo $quantity ?>"><?php echo 'Maximum of ' . $quantity . ' available'?></option>
<option value="1">1</option> 
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5</option>
<option value="6">6</option>
<option value="7">7</option>
<option value="8">8</option>
<option value="9">9</option>
<option value="10">10</option>
</select>

How is it possible to do this? I am completely at a loss here.   Many Thanks   aquaman

Hi,

having stopped php for a while, i'm a little rusty, can someone help me - instead of the results returning in a row by row format, can i have it so it returns column by column?
so, rather than result 1 being first, then 2 underneath then 3 etc etc, can i have result 2 next to result 1?

heres my code

$result = mysql_query("SELECT * FROM members ORDER BY member_id DESC")   
or die(mysql_error());  

echo "<table border='2'>";
echo "<tr> <th></th> <th></th> <th></th> </tr>";
// keeps getting the next row until there are no more to get
while($row = mysql_fetch_array( $result )) {
// Print out the contents of each row into a table
echo "<tr><td>"; 
echo $row[printf('<img src="%s" height="96" width="128" style="border: 0" />', $row['profile_pic_short'])];
echo "</td><td>"; 
echo "<a href=\"PHP-Login/advert_pages/view_profile_specific.php?seller_name=$row[login]\">". $row['login'] . "</a>";
echo "</td></tr>"; 

} 

echo "</table>";
?>


all help appreciated

thanks

I am fetching a data from database which comes out like this

EmpID   First Name   DoJ   Supervisor
'34698'    'Ian Bobby'    '2011-08-09'    'Daniel Lin'
'34684'    'Sally Dodd'    '2011-08-09'    'James Kirk'
'34871'    'Alan Dandy'    '2011-08-09'    'Pamela Roy'

I want to Transpose it like this
EmpID   '34698'   '34684'   '34871'
First Name    'Ian Bobby'    'Sally Dodd'    'Alan Dandy'
DoJ    '2011-08-09'    '2011-08-09'    '2011-08-09'
Supervisor    'Daniel Lin'    'James Kirk'    'Pamela Roy'

Please help

Hi, I need help to check multiple rows for many columns, so that the script won't re-insert a duplicate entry. For eg:


$isRowExist=mysql_query("SELECT (field1,field2) from table1 WHERE field1='$f1' AND field2='$f2' ");

if(mysql_num_rows($isRowExist)==1)
   print "already in table1!";
else
   //proceed to insert into table table1


*BUT I tried this and it says mysql_num_rows expects resource, and this warning only shows when I have multipel columns I want to compare (it works just fine with one column in the WHERE clause above)

Please help!

Not sure if this is the right forum, but I have a database that I will need to populate with a large number of rows (2000+).

I have written a PHP script that uploads individual entries.

Is it possible to use something like a spreadsheet where I can set out the rows/columns as they will appear in the database, and then upload in one go rather than uploading each row individually?

Thanks for any observations and/or help.

Hello - hope you are all well.   I am creating a website for a family friend who has a shop. See preview of the site in this picture ....  Picture1.jpg   40.32KB   0 downloads   Currently the results are showing in one column. I want to show them in three columns in the format of:   1 2 3 4 5 6  7 8 9 etc   But formatted with the picture and then the title and the border.   The current code i have is....     HEAD   <?php $sql = "SELECT * FROM abs_productcat WHERE catid = $catid ORDER BY catid ASC";
$can = mysql_query($sql);
$catname = mysql_fetch_assoc($can); ?>       BODY    <?php while ($row_pro = mysql_fetch_assoc($rs_proddetails)) { ?><tr>
                            <td><table width="243" border="0" align="left" cellpadding="15" cellspacing="0" class="sectionborders">
                             
                              <tr>
                                <td height="120" align="center"><p><strong><a href="indproducts.php?ProductID=<?php echo $row_pro['ProductID']; ?>"><img src="products/product_<?php echo $row_pro['ProductID']; ?>" alt="<?php echo $row_pro['ProductName']; ?>" height="120" class="sectionborders" border="0" /></a></strong></p>
                                  <p><strong><a href="indproducts.php?ProductID=<?php echo $row_pro['ProductID']; ?>" class="products"><?php echo $row_pro['ProductName']; ?></a></strong></p></td>
                              </tr>
                              </table></td>
                          </tr>
                          <tr>
                            <td>&nbsp;</td>
                          </tr> <?php } ?>       THANK YOU FOR YOUR HELP!!!  

Code: [Select]
<?php 
$result = mysql_query("SELECT * 
FROM FamilyTbl
INNER JOIN PeopleTbl ON (FamilyTbl.Name_ID = PeopleTbl.NameID) 
WHERE FamilyTbl.House_ID = '$address'
ORDER BY NameLast, NameFirst
") OR die(mysql_error());

WHILE ($row = mysql_fetch_array($result) )  { 

   echo $row[NameLast]. ", ". $row[NamePrefix]. " ". $row[NameFirst]. " ". $row[NameMiddle]. $row[NameSuffix]. " "; 
}
?>

OK, some of these queries return A LOT of names.  I'd like to be able to display them in columns in a table like so:
Code: [Select]
Charne, Mr. Michael   Glanger, Mrs. Karin      Kling, Mr. Wayne 
Charne, Mrs. Suzette  Glanger, Mr. Trevor      Lazarow, Mrs. Fiona 
Charney, Mrs. Linda   Jochelson, Mrs. Barbara  Lazarow, Mr. Mark 
Charney, Mr. Norman   Jochelson, Mr. Neil      Norton, Mr. Charles 
Cohen, Mr. Brendan    Karlan, Mr. Dennis       Norton, Mrs. Jodi 
Cohen, Mrs. Joanna    Karlan, Mrs. Helen       Roy, Mr. Michael 
Flekser, Mrs. Jean    Kling, Mrs. Danielle     Roy, Mrs. Nicki 
Frysh, Dr. Howard     Kling, Mrs. Melanie      Tsafrir, Mrs. Lauren 
Frysh, Mrs. Sandra    Kling, Mr. Nevil         Tsafrir, Mr. Thomer 

That way it reads top to bottom THEN left to right.

math-wise, it's simple to set up:
Code: [Select]
$num_results = number_of_$results;
$numcols = 3;
$numrows = trunc($numresults/numcols);
<table>
for row_loop=1 to numrows
<tr>
for col_loop = 1 to numcols
<td>
echo result(col_loop-1)*(numrows)+row_loop
</td>
next col_loop
</tr>
next row_loop
</table>

Anyone want to give this a shot?

Revraz already directed me to http://www.phpfreaks.com/forums/index.php/topic,95426.0.html but that displayed the data from left to right then up to down like so:
Code: [Select]
Charne, Mr. Michael   Charne, Mrs. Suzette  Charney, Mrs. Linda 
Charney, Mr. Norman   Cohen, Mr. Brendan    Cohen, Mrs. Joanna 
Flekser, Mrs. Jean    Frysh, Dr. Howard     Frysh, Mrs. Sandra 
Glanger, Mrs. Karin   Glanger, Mr. Trevor   Jochelson, Mrs. Barbara 
Jochelson, Mr. Neil   Karlan, Mr. Dennis    Karlan, Mrs. Helen 
Kling, Mrs. Danielle  Kling, Mrs. Melanie   Kling, Mr. Nevil 
Kling, Mr. Wayne      Lazarow, Mrs. Fiona   Lazarow, Mr. Mark 
Norton, Mr. Charles   Norton, Mrs. Jodi     Roy, Mr. Michael 
Roy, Mrs. Nicki       Tsafrir, Mrs. Lauren  Tsafrir, Mr. Thomer 

It's a good temp solution, but if anyone is good with for loops, I'd appreciate the help, thanks!

-Dave

Hi

I have a page which returns 2 rows of images max 5 in each.
Code is:

<?php
$query = mysql_query("SELECT COUNT(id) FROM " . $prev . "pics where id=" . $id . "");
list($number_records) = mysql_fetch_row($query);

if ($number_records >= 10 )
{
$number =10; //LIMIT IMAGES TO 10
}
else
{
$number =$number_records;
}

echo "<br />";

echo "Displaying $number of $number_records images";

?>



<div class="thumb-right">


        <dl>
   
            <?php for ($i = 0; $i < 5; $i++): ?>
               <dt>
                 <img src="../pics/<?php echo $images[$i]; ?>" alt="" width="120" height="120" class="border1"  /><br /><br />
               </dt>
            <?php endfor; ?>
        
        </dl>



</div>    


<div class="thumb-left">

<dl>
          
            <?php for ($i = 5; $i < $number; $i++): ?>
            <dt>
                  <img src="../pics/<?php echo $images[$i]; ?>" alt="" width="120" height="120" border="0" class="border1" /><br /><br />
            </dt>
            <?php endfor; ?>
         
        </dl>

</div>

This works fine if there are 10 images to display, but on occasions there may only be 7 for instance. This then puts 5 in the right column and only 2 in the left column which looks ugly.

Can someone suggest a way of calculating the total number of images and then displaying them say 4 in the left column and 3 in the right column for this example?

Thanks for your time

GT

Hi I wanted to know how once I have selected and echoed the rows from mysql table how can I get it to number those rows that echo?
etc

1.   echo $variable
2.   echo $variable
3.   echo $variable
4.   echo $variable
5.   echo $variable

Any help is appreciated

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

Hi,
This has been baffling me for a couple hours now and i cant seem to figure it out.
I have some code which creates an array and gets info from a mysql database and then displays in a list. This works great but after adding more and more rows to my database the list is now becoming quite large and doesnt look great on my site.
Is it possible to split the list into multiple columns of about 25 and if possible once 3 or 4 columns have been created start another column underneath.
To help explain i would be looking at a layout as follows:
Code: [Select]
line 1      line 1      line 1
line 2      line 2      line 2
...      ...      ...
line 25      line 25      line 25

line 1      line 1      line 1
line 2      line 2      line 2
...      ...      ...
line 25      line 25      line 25Im guessing there should be some sort of if statement to check how many items are being displayed and to create a new column if necessary. Is this correct?

Thanks,
Alex

Hey guys was wondering if anyone could modify the code below to have $output = 'yes' if the number of rows equal 10, 20, 30, 40, 50, 60, 70, 80......... etc

$dbhost = '******';
$dbuser = ''******';';
$dbpass = ''******';';

$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('MYSQL N/A - Please Contact Admin');

$dbname = ''******';';
mysql_select_db($dbname);

$query="SELECT * FROM documentaryinfo";
$result=mysql_query($query);

$num=mysql_numrows($result);

mysql_close($conn);
?>

Thanks
--------------------------------------------------------------------------------------------------------
Watch Free Documentaries Online - The Documentary Database
www.free-documentaries-online.com
--------------------------------------------------------------------------------------------------------

I was just wondering when you run a mysql query what the easiest way to find out the number of rows returned.  Just so I can do a number of results found on a search.  Thanks. 

Hi,

I am stuck. I have used dreamweaver to create a master details page with links to the details page successfully, but I would like to display the master details page results in 3 columns rather than the 1 column that dreamweaver defaults. As the site becomes richer the content will increase yielding many results, therfore the content displayed in a single column will require the users to scroll way down the page.

So, as it is now the results display as follows:

Plant1
Plant2
Plant3
Plant4
Plant5
Plant6
Plant7
Plant8
Plant9
etc...

I would like them to display as follows:
Plant1        Plant4        Plant7
Plant2        Plant5        Plant8
Plant3        Plant6        Plant9

Here is my code thus far:
<?php require_once('Connections/connGND.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
  if (PHP_VERSION < 6) {
    $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
  }

  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;   
    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}
}

mysql_select_db($database_connGND, $connGND);
$query_rsBotanicalA = "SELECT * FROM plants WHERE CatIDB = 'A'";
$rsBotanicalA = mysql_query($query_rsBotanicalA, $connGND) or die(mysql_error());
$row_rsBotanicalA = mysql_fetch_assoc($rsBotanicalA);
$totalRows_rsBotanicalA = mysql_num_rows($rsBotanicalA);
?>
<table border="0" align="left">
  <?php do { ?>
    <tr>
      <td align="left"><a href="plantdetails.php?recordID=<?php echo $row_rsBotanicalA['PlantID']; ?>"> <?php echo $row_rsBotanicalA['BotanicalName']; ?>&nbsp; </a></td>
    </tr>
    <?php } while ($row_rsBotanicalA = mysql_fetch_assoc($rsBotanicalA)); ?>
</table>

Could someone help me to write this code, as I have been unsuccessful maintaining the links. I have been able get the results to display in the columsn as I would like, but I haven't been able to figure it out while maintaining the links!

Thanks.

Folks,

Having trouble here. Forgot how you use the COUNT. Not interested in the num_rows due to it being slow compared to COUNT.

I have users table like this:

id|username|sponsor_username

0|barand|requinix

1|phpsane|alison

2|mickey_mouse|requinix

Now, I want to check if a sponsor username exists or not. Such as does the entry "requinix" exists or not in one of the rows in the "sponsor_username" column.

In our example it does twice and so the variable $sponsor_username_count should hold the value "2". Else hold "0".

I get error:

Fatal error: Uncaught mysqli_sql_exception: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '?' at line 1 

 

My code:

	$stmt_1 = mysqli_prepare($conn,"SELECT COUNT(sponsor_username) from users = ?"); 
            mysqli_stmt_bind_param($stmt_1,'s',$sponsor_username_count); 
            mysqli_stmt_execute($stmt_1); 
            
            //Show error if 'users' tbl was not successfully queried". 
            if (!$stmt_1) 
            { 
                echo "ERROR 1: Sorry! Our system is currently experiencing a problem loading this page!"; 
                exit(); 
            } 
            else 
            { 
                mysqli_stmt_bind_result($stmt_1,$sponsor_username_count);     
                mysqli_stmt_fetch($stmt_1); 
                mysqli_stmt_close($stmt_1); 
                
                //Check if Sponsor Username in Url ($_GET) is already registered or not. If not then show "Invalid Url" or Link message. 
                if ($sponsor_username_count < 1) 
                { 
                    echo "<b>Invalid Url or Link!<br> Invalid Sponsor: \"$sponsor_username\"!</b><?php "; 
                    exit(); 
                } 
            }