PHP - Anyone Can Help With This Simple Yet Frustrating Question

I'm teaching myself php and mysql -- and my coding is a little rough.   But what i'm trying to do is display information from a mysql table in another table on a website.  I can do this just fine simply displaying the table, but i want a little something different.  I am only displaying one column of the table, instead of displaying it all in one column, i want to display the information in 5 columns.  for example.....  the table from mysql has names scott, john, james, mary, simon.  with the code I have i can make it display like this:
                                                                                         scott scott scott scott scott
                                                                                         john john john john john
                                                                                         james james james james james
                                                                                         mary mary mary mary mary
                                                                                         simon simon simon simon simon
i want it to diplay like this:
                                                                                          scott john james mary simon
                                                                                          new names will continue down

here is my code:

<?php

require ("connectigb.php");


$result = mysql_query ("SELECT pledgeName FROM pledgewall");

$fields_num = mysql_num_fields($result);


echo "<center> <h1>TSA It Gets Better Pledge Wall</h1>";
echo "<table border='1' align='center' style='width:960px;'><tr>";


while($row = mysql_fetch_row($result))
{
    echo "<tr>";

    // $row is array... foreach( .. ) puts every element
    // of $row to $cell variable
    foreach($row as $cell)
      if ($cell != "") {
for ($j=0; $j<5; $j++) {
        echo "<td>$cell</td>";
   }
   }

    echo "</tr>\n";

}
mysql_free_result($result);
echo "</table></center>";
?>

any ideas on what i can do here, i'm sure this is a simply fix.  i just haven't come across it yet.  thanks for the help in advance.

Hi guys, this function below is for card validation, however anycard i enter i get the invalid card number, this is not connected to any gateways, this is just an Luhn card validation demonstration.

can you tell me please why i get that?

<?php
  if ($_POST['pay'])
    {

$cardNo = addslashes(strip_tags($_POST['cardNo']));









function luhnCheck($cardNo) {
    $cardNo = str_replace(" ", "", trim($cardNo));
    if(!is_numeric($cardNo) or strlen($cardNo)>19) return false;
    $skip = $newNum = $total = 0;
    for($i=0;$i<=(strlen($cardNo)-1);$i++) {
        if($skip ==0) {
            $tmpNum = ($cardNo[$i]*2);
            $total += (strlen($tmpNum)==2 ? (substr($tmpNum, 0, 1)+substr($tmpNum, 1)) : $tmpNum);
            $skip = 1;
        }else{
            $total += $cardNo[$i];
            $skip = 0;
        }
    }
    return (($total % 10) == 0);
}

/* Example Usage */
if(luhnCheck($_GET['cc'])) {
    echo("Valid Number.");
}else{
    echo("Invalid Number.");
}





}





?>


<form name="confirm" method="post" action="">

<input type="text" name="cardNo">
 
                <input type="submit" name="pay" value="Pay Now">
                
  </form>

I know it could be a issue with this line if(luhnCheck($_GET['cc'])) { but im wondering where should and how put this cc in my form?

regards

Hello there fellow programmers,

I was just wondering if there was any difference between doing this:

Code: [Select]
echo "Say Something Here";
and this

Code: [Select]
echo "Say ";
echo "Something ";
echo "Here";
Thank you in advance.

Notice: I am aware of the fact that they will output the same thing, my question is regarding resources.

hello all I'm VERY new to php and I just have a simple question

how do I bold the output text of this string

echo $row['name']."<BR>";

Hello everyone! I am a new user and I have a simple question. How do I set a password for a user to log in to my site with PHP? I have no MySQL database just a iOS code/host app. I know this isn’t secure but only me and my friends are on the site. Any help is appreciated. 

if someone can help me out with this, its quite simple but I can't seem to get it to work..

Basically, this is the code I have for now, the issue is if I have 0 product or items, I don't want the sorting option to show up on the page,    from the code below, what line can I add tosay that if there is no products in a category, not to show the SORT feature.

thanks in advance if anyone can help.


{if isset($orderby) AND isset($orderway)}
<!-- Sort products -->
{if isset($smarty.get.id_category) && $smarty.get.id_category}
   {assign var='request' value=$link->getPaginationLink('category', $category, false, true)}
{elseif isset($smarty.get.id_manufacturer) && $smarty.get.id_manufacturer}
   {assign var='request' value=$link->getPaginationLink('manufacturer', $manufacturer, false, true)}
{elseif isset($smarty.get.id_supplier) && $smarty.get.id_supplier}
   {assign var='request' value=$link->getPaginationLink('supplier', $supplier, false, true)}
{else}
   {assign var='request' value=$link->getPaginationLink(false, false, false, true)}
{/if}
<form id="productsSortForm" action="{$request|escape:'htmlall':'UTF-8'}">
   <select id="selectPrductSort" onchange="document.location.href = $(this).val();">
      <option value="{$link->addSortDetails($request, $orderbydefault, $orderwaydefault)|escape:'htmlall':'UTF-8'}" {if $orderby eq $orderbydefault}selected="selected"{/if}>{l s='--'}</option>
      {if !$PS_CATALOG_MODE}
      <option value="{$link->addSortDetails($request, 'price', 'asc')|escape:'htmlall':'UTF-8'}" {if $orderby eq 'price' AND $orderway eq 'asc'}selected="selected"{/if}>{l s='Price: lowest first'}</option>
      <option value="{$link->addSortDetails($request, 'price', 'desc')|escape:'htmlall':'UTF-8'}" {if $orderby eq 'price' AND $orderway eq 'desc'}selected="selected"{/if}>{l s='Price: highest first'}</option>
      {/if}
      <option value="{$link->addSortDetails($request, 'name', 'asc')|escape:'htmlall':'UTF-8'}" {if $orderby eq 'name' AND $orderway eq 'asc'}selected="selected"{/if}>{l s='Product Name: A to Z'}</option>
      <option value="{$link->addSortDetails($request, 'name', 'desc')|escape:'htmlall':'UTF-8'}" {if $orderby eq 'name' AND $orderway eq 'desc'}selected="selected"{/if}>{l s='Product Name: Z to A'}</option>
      {if !$PS_CATALOG_MODE}
      <option value="{$link->addSortDetails($request, 'quantity', 'desc')|escape:'htmlall':'UTF-8'}" {if $orderby eq 'quantity' AND $orderway eq 'desc'}selected="selected"{/if}>{l s='In-stock first'}</option>
      {/if}
   </select>
   <label for="selectPrductSort">{l s='Sort by'}</label>
</form>
<!-- /Sort products -->
{/if}

Hi.  I have an ID in md5 format but in the database its not.  I pass the md5 ID to a page and then I am trying to load the correct record via a look up in the database of that ID.  Im wondering is this code possible?



<?php $query = mysql_query("SELECT * FROM table WHERE ".md5(tableID)." = $ID"); ?>



Thanks

Hello to everyone

I would like to ask for this simple question.. Im trying to put if and else condition on my php code. However this condition is not working..

Code: [Select]
if($file == #3#){
echo "No results found";
}else{ echo "results has been found"; }
This variable $file is the result after i used an API.. If the API does not see any results they would return #3# as the result. This means they returned a transaction code of 3 which you can see here http://developer.textapp.net/WebService/TransactionCodes.aspx means that there was nothing to return.

The condition does not function well even if i make 3 or #3# as part of the condition. Can you help me guys?

thanks

Hey! I have a drop down field for my "register" form, but this is clearly easy to edit, I just used tamperdata for firefox and yeah...pretty easy, is there any way that you could prevent tampering with the values when submitting this form!?

Hi, I'm working on a product page and I got it to list all the products in one column of a table, but when I add a second column it just duplicates the first column.  What do I need to change? 

Code: [Select]
<?php
require_once("functions.php"); 
?> 
<!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>Untitled Document</title>
<style type="text/css">
td {
border-top-style: solid;
border-right-style: solid;
border-bottom-style: solid;
border-left-style: solid;
border-top-color: #30C;
border-right-color: #30C;
border-bottom-color: #30C;
border-left-color: #30C;
}
</style>
</head>

<body>
<form action="" method="post" name="catalog">
<?php 

DatabaseConnection();  

  $query = "SELECT * FROM treats";
        $result_set = mysql_query($query) or die(mysql_error());

        $output = "<table>";
        while ($row = mysql_fetch_array($result_set))
        {
            $output .= (" 
<tr>
<td width=\"400px\">" . $row['product_title']."<br /> ".$row['product_Description']."<br />" .$row['price'] . "<br />  Quantity: <input name=\"quantity\" type=\"text\" size=\"2\" /> </td>  
<td width=\"400px\">" . $row['product_title']."<br /> ".$row['product_Description']."<br />" .$row['price'] . "<br />  Quantity: <input name=\"quantity\" type=\"text\" size=\"2\" /> </td>  
</tr>
");
        }
        $output .= "</table>";
        echo $output;
?>   
</form>
</body>
</html>

I've seen this,
Code: [Select]
<?php } ?>
in a lot of scripts at the very end of the script. What does this piece of code do?

I can't figure out why im getting an error with this code.

if ($notif = mysql_query("SELECT * FROM notifications_1 WHERE recieverid='". $_SESSION['id']."' ORDER BY read ASC, id DESC") or die (mysql_error())); {

Code: [Select]
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'read ASC, id DESC' at line 1

what does the # symbol do in php(e.x index.php?cat=1#privacy)? How can i use it? From what i 've seen you use it for changing a whole div without reloading the page like tabs..

Hi, I am trying to convert a php function into perl and need to understand the following line in red :        function pagination($query, $per_page = 10,$page = 1, $url = '?'){       
     $query = "SELECT COUNT(*) as `num` FROM {$query}";
     $row = mysql_fetch_array(mysql_query($query));
     $total = $row['num'];
        $adjacents = "2";      $page = ($page == 0 ? 1 : $page); 
     $start = ($page - 1) * $per_page;        
  
     $prev = $page - 1;       
     $next = $page + 1;
        $lastpage = ceil($total/$per_page);
     $lpm1 = $lastpage - 1;
     
     $pagination = "";
     if($lastpage > 1)
     {  .........................................     What will be the output of this line above in red.   Thank you very much. Regards. Tonya

Hello.

I have a newbie question regarding arrays:

How can I echo an element's subsequent arrays and elements?

For example

Code: [Select]
$pers = array("Steve" => array("eyes" => "green", "age" => "43", "race" => "caucasian"));    



and if I echo $pers["Steve"] to make it display: green 43 caucasian.

Thanks.