marwaa's Profile User Rating: -----

Reputation: -3 Dishonored
Group:
Members
Active Posts:
28 (0.02 per day)
Joined:
29-November 10
Profile Views:
1,953
Last Active:
User is offline Aug 13 2014 08:57 PM
Currently:
Offline

Previous Fields

Country:
US
OS Preference:
Windows
Favorite Browser:
Internet Explorer
Favorite Processor:
Intel
Favorite Gaming Platform:
PC
Your Car:
Infiniti
Dream Kudos:
0

Latest Visitors

Icon   marwaa cs

Posts I've Made

  1. In Topic: i cant solve this problem .. mysql_fetch_array() expects parameter 1

    Posted 13 Aug 2014

    I doo that also
    But still not working. :(
  2. In Topic: i cant solve this problem .. mysql_fetch_array() expects parameter 1

    Posted 13 Aug 2014

    i do what you say
    but its still not working




    i cahnge my code from mysql_fetch_assoc to _fetch_array
    i put date between $from_date and $to_date
    i put if (!$result1)


    what i can do more?


    <head>  <title >   report
    </title> </head> 
    
    <?php 
    session_start();
    $tbl_name="test_mysql"; // Table name 
    
    $db=mysql_connect('localhost','root','');
    if (!$db)die ("failed connection");
    mysql_select_db("test",$db);
    extract($_POST);
      
     $subject=$_POST['subject'];
     $orderr=$_POST['orderr'];
     $send_to=$_POST['send_to'];  
     $distribution=$_POST['distribution'];   
      $distribution2=$_POST['distribution2'];    
     $order_status=$_POST['order_status'];    
     $from_date=$_POST['from_date'];       
      $to_date=$_POST['to_date'];     
             
     
       
    
       $result1 = mysql_query("SELECT * FROM $tbl_name WHERE subject=$subject and orderr=$orderr and send_to=$send_to and distribution=$distribution and distribution2=$distribution2 and order_status=$order_status and datee BETWEEN $from_date and $to_date"); 
     
     ?>
     
     <table  align="center" border='1'  width="90%" height="30%" style=" font-size:18px;"  >
     <br> <br> <br>
     <caption> <font size="5"> reports  </caption>
     <?php
    while($row = mysql_fetch_array($result1))
    {
    echo "<tr><td >" . $row['notes']. "</td> <td>" .$row['order_id'] ."</td> <td>" .$row['order_note'] . "</td> <td>" .$row['order_status'] . "</td> <td>" .$row['distribution2'] . "</td><td>"
    .$row['distribution'] . "</td><td>" . $row['send_to'] . "</td> <td>" . $row['orderr'] . "</td> <td>" . $row['subject'] ."</td> <td>" . $row['book_no'] .
     "</td> <td>" . $row['datee'] . "</td><td> " . $row['order_id '].  "</td></tr>";
    
    
    }
    if (!$result1)
    {echo"errorrr";
    }
    
    ?>
    </table>   
    
    
      
    
    
    
    
    
    
    
    

My Information

Member Title:
New D.I.C Head
Age:
23 years old
Birthday:
November 24, 1991
Gender:

Contact Information

E-mail:
Private

Comments

marwaa has no profile comments yet. Why not say hello?