PHP - Mysql Fetch All Rows Into Array Using Column As Key

Please help me. I'm fairly new to php and have been looking for answers on Goog for about two weeks or so with not an answer. This is my first post on a forum of any type.

I have a form on a php page that when submitted sends a value to a confirm php page

Code: [Select]
      <form action='buyconfirmorder.php' method='post'>
      Purchase: <input type='text' name='ask_shares'><br /><br />
      You Will Pay: &nbsp<input type='text' name='ask'><br /><br />
      <input type='hidden' name='postcardname' value='$postcardname'>
      <input type='submit' name='submit' value='Order'>
      </form>
I need to take the users input from the form and subtract each row from a mysql DB one at a time until the users input is down to a remainder and then I need the remainder (I'll be working with the remainder as well).

Code: [Select]
$query = mysql_query("
SELECT * FROM ask, search
WHERE search.id = ask.card_search_id
AND search.card_name = '$postcardname'
ORDER BY ask_price ASC");

The array will be numbers only.

So an example would be:

User input from the form is 100.00

Code: [Select]
   while($rows = mysql_fetch_array($query))
   {
   $ask_price = $rows['ask_price'];
   }
Let's say the array is 50.50, 40.50, 35.00

I need some code to do:

100.00 - 50.50 = 49.50
49.50 - 40.50 = 9.00
9.00 - 35.00 = <0 does not do anything
so remainder = 9.00

would it be something like
Code: [Select]
$new_ask_shares = $_POST['ask_shares'];
//some sort of a loop or array or combo of both
($new_ask_shares - $ask_price);
the numbers are just an example as the actual numbers will be different each time I query my DB.

Thanks in advance

Hi,

I'm wondering if theres a shortcut to a potential problem I have.
I'm currently running a query on my website to pull all the fields from a table in my database, for the data to be used on various parts of the page.

Usually I would do something as follows

Code: [Select]
$result = mysql_query("SELECT * FROM table WHERE page='1'");

while ($row=mysql_fetch_array($result))
 {
 $title = $row["title"];
 $data = $row["data"];
 }

And so on and so forth. I would then call the appropriate data by echoing $data for example.
However, my table contains a lot more rows than i've mentioned (Around 25 or so). Rather than assigning each to a variable and having a large portion of variable assignments at the top of the page, is there any clever way of putting all of these values inside of an array.
So for example, I could call $array_data["title"] or $array_data["data"]??
So it keeps the same key, but puts it inside of an array that I don't have to loop through each time?

Hope that makes sense!

Thanks,
Edd

Hi,   Does anyone have a clue how I might solve this little issue:   I have a MySQL query, for example:

<?php
// Make a MySQL Connection
$query = "SELECT * FROM staff";
    
$result = mysql_query($query) or die(mysql_error());


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

    if($row['clock'] < time()) {
    echo "<b>"$row['name']. " - ". $row['age']"</b>";
    echo "<br />";

    } else {

    echo $row['name']. " - ". $row['age'];
    echo "<br />";

    }
}
?>

Taking data from the following table setup:   name - age - clock Timmy Mellowman - 23 - 09:00:00
Sandy Smith - 21 - 12:00:00
Bobby Wallace - 15 - 14:00:00   What im trying to achieve is compare the current time to the time in the clock column and depending if it's earlier or later, change the styling of the results.   The above code does appear to work somewhat however it seems to change the styling of all results in one go, rather than individually when it passes the time in the cell, which is what im looking for.   Thanks

Warning: mysql_fetch_array() expects parameter 1 to be resource, string given...


im tryin to put class inside code if $dayNumber and $dan are equal

i tried few ways but all are complicated since i have to call some functions this end up as "simple" solution but i dont know where did i get wrong PS that should be possible?

Code: [Select]
else {
                  echo "<td width='40'";
  $moj_id = $_SESSION['id'];
  $query_event = mysql_query("SELECT * FROM events WHERE id_user='$moj_id' GROUP BY 'event_date'") ;
  $test = mysql_fetch_array('$query_event');
  $date_event = $test['event_date'];
  sscanf($date_event, "%d-%d-%d", $godina, $mjesec, $dan);
  if ($dan==$dayNumber && $mjesec==$month && godina==$year)
  {

  echo " class='radni'";
  }
 
 
  echo"><a href='day_info.php?dan=",$dayNumber,"&mj=",$month,"&gd=",$year,"'>" . $dayNumber . " </a></td>\n";
                  $dayNumber++;                           
              }

Okay, this is getting on my nerves now, my head is throbbing probably just need a break from it all now.

I'm currently getting the following message;

Warning: mysql_fetch_array() expects parameter 1 to be resource, null given in C:\xampp\htdocs\duff3\test3.php on line 25

Can anyone figure out and explain why this isn't working for me, I believe I am calling the function correctly and then putting the result into a while loop.

Code: [Select]
<?php
    function getPageContent($selectedPage)
    {
        $sql =  "SELECT * ";
        $sql .= "FROM  tbl_pages ";
        $sql .= "WHERE tbl_pages.pageCategoryId = ".$selectedPage." ";
        $sql .= "AND active = 1 ";
        $sql .= "LIMIT 1";
        $result = mysql_query($sql) or die ("Error in page sql query:". $sql);
        
        return $pageSet;
        
    }
    
?>




Code: [Select]
<?php require_once ''.$_SERVER['DOCUMENT_ROOT'].'/duff3/commonResources/dbConnection/dbQueryClass.php'; 

?>
<?php
        #FUNCTIONS IS A TEMP FILE UNTIL OO PHP COMES INTO PLAY 
        require_once ("commonResources/includes/functions.php");
        # if page isn't set then set it to default.
        if(isset($_GET["page"]))
        {
            $selectedPage = $_GET["page"];
        }
        else
        {
            $selectedPage = 1; 
        }
        #call function to select all page 
        $pageSet = getPageContent($selectedPage);
?>
<!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>

<title>
    <?php
                 while ($row = mysql_fetch_array($pageSet)) 
                { # Start while loop
                    echo $row["pageTitle"]; 
                ?>
    </title>
   
            <link rel="shortcut icon" href="commonResources/images/container/favicon.ico" />
            <link rel="stylesheet" type="text/css" href="<?php $_SERVER["DOCUMENT_ROOT"] ?>/duff3/commonResources/css/style.css" />
   
            <meta http-equiv="Content-Type" content="text/html; charset=windows-1252" />
           
            <!-- PUT COMMON JAVASCRIPT FILES IN AN INCLUDE 05/05/2011 -->
            <script type="text/javascript" src="commonResources/javaScript/jQuery.js"></script>
            <script type="text/javascript" src="commonResources/javaScript/jQueryTest/menu.js"></script>
        <?php
            require_once ("".$_SERVER["DOCUMENT_ROOT"]."/duff3/commonResources/includes/tinymce.php");
        ?>
   
</head>
<body>
        <div id="viewContainer"><!--OPEN DIV FOR VIEW CONTAINER -->
       
            <div id="headerContent"><!--OPEN DIV FOR HEADER CONTENT -->
           
                <div class="logoContent"><!--OPEN DIV FOR LOGO CONTAINER -->
               
                    <a href="index.html"><img src="<?php  $_SERVER["DOCUMENT_ROOT"] ?>/duff3/commonResources/images/container/logo.png" alt="Hannah Jane Duff" longdesc="Hannah Jane Duff Home Link" /></a>
                   
                </div><!--CLOSE DIV FOR LOGO CONTAINER -->
               
            </div><!--CLOSE DIV FOR HEADER CONTENT -->
           
           
           
           
        <!-- TEMP TAKE OUT AND PUT INTO HEADER AREA -->   
           
           
           
<div id="mainContent"><!--OPEN DIV FOR MAIN CONTENT-->
                <div class="centreContent"><!--OPEN DIV FOR CENTRE CONTENT-->
               
                    <div id="menuContent"><!--OPEN DIV FOR MENU CONTENT-->

                        <div id="menu">
                            <ul class="menu">
                                <li><a href="index.html" class="main"><span>Home</span></a></li>
                                <li><a href="" class="main"><span>bio</span></a>
                                    <div><ul>
                                        <li><a href=""><span>violin</span></a></li>
                                        <li><a href=""><span>piano</span></a></li>
                                        <li><a href=""><span>singing</span></a></li>
                                        <li><a href="" class="parent"><span>teaching</span></a>
                                            <div><ul>
                                                <li><a href="" class="parent"><span>aberdeen</span></a>
                                                    <div><ul>
                                                        <li><a href="#"><span>aberdeen 1</span></a></li>
                                                    </ul></div>
                                                </li>
                                                <li><a href=""  class="parent"><span>bradford</span></a>
                                                    <div><ul>
                                                        <li><a href=""><span>bradford 1</span></a></li>
                                                    </ul></div>
                                                </li>
                                                <li><a href=""  class="parent"><span>leeds</span></a>
                                                    <div><ul>
                                                        <li><a href=""><span>leeds 1</span></a></li>
                                                    </ul></div>                       
                                                </li>
                                              </ul></div>
                                        </li>
                                        <li><a href="" class="parent"><span>influences</span></a>
                                            <div><ul>
                                                <li><a href=""><span>classical</span></a></li>
                                                <li><a href=""><span>folk</span></a></li>
                                             </ul></div>
                                       </li>
                                       <li><a href="" class="parent"><span>other</span></a>
                                            <div><ul>
                                                    <li><a href=""><span>folk&prime;d</span></a></li>
                                                <li><a href=""><span>string quaret</span></a></li>
                                             </ul></div>
                                        </li>               
                                    </ul></div>     
                                </li>
                                <li><a href="" class="main"><span>publicity</span></a>
                                   <div><ul>
                                        <li><a href="" class="parent"><span>news</span></a>
                                            <div><ul>
                                                <li><a href=""><span>may 2011</span></a></li>
                                                <li><a href=""><span>march 2011</span></a></li>
                                            </ul></div>
                                        </li>
                                        <li><a href=""><span>gallery</span></a></li>
                                        <li><a href=""><span>other</span></a></li>
                                   </ul></div>
                                </li>
                                <li><a href="" class="main"><span>recordings</span></a>
                                    <div><ul>
                                        <li><a href=""><span>all</span></a></li>
                                        <li><a href=""><span>new york dolls</span></a></li>
                                        <li><a href=""><span>classical</span></a></li>
                                    </ul></div>       
                                </li>
                                <li><a href="" class="main"><span>contact</span></a></li>
                            </ul></div>     
                    </div><!--CLOSE DIV FOR MENU CONTENT-->
                   
                    <div class="paraBlock"><!--OPEN DIV FOR PARA BLOCK -->
                        <p><?php echo $row["pageContent"]; ?></p>
                    </div><!--CLOSE DIV FOR PARA BLOCK-->
                   
<div class="clearArea"><!--OPEN DIV FOR CLEAR AREA-->
                   
                    </div><!--CLOSE DIV FOR CLEAR AREA-->
                   
                </div><!-- CLOSE DIV FOR CENTRE CONTENT-->
               
            </div><!--CLOSE DIV FOR MAIN CONTENT-->
           
            <div id="footerContent"><!--OPEN DIV FOR FOOTER CONTENT-->
           
                <div class="leftFooter"><!--OPEN DIV FOR LEFT FOOTER-->
               
                    &copy;&nbsp;&nbsp;<?php echo date(Y); ?> All Rights Reserved &nbsp;|&nbsp; Design by <a href="http://www.innovationation.co.uk/">Innovationation UK</a>
                   
                </div><!--CLOSE DIV FOR LEFT FOOTER-->
               
                <div class="rightFooter"><!--OPEN DIV FOR RIGHT FOOTER-->
               
                    <a href="">Copyright | </a>
                    <a href="">Disclaimer | </a>
                    <a href="">Privacy Policy  </a>
                    <a href="">Terms of Use | </a>
                    <a href="">Site Map | </a>
                    <a href="loginArea/login.php">Admin</a>
                   
                </div><!--CLOSE DIV FOR RIGHT FOOTER-->
               
            </div><!--CLOSE DIV FOR FOOTER CONTENT-->
            <?php } ?>
        </div><!--CLOSE DIV FOR VIEW CONTAINER-->
       
</body>
</html>