I need insights sa SQL data accessing using PHP. it displays nothing.

[Lorenzo]

---

Hi istoryans please tabangi ko and akong code kay dili sya mo display sa $row['product_name'] wala man unta koy problem nga na encounter completely blank jud sya, anyways seperate sila ug tables mao duha ka parameters ug pag query akong gigamit please help me!

I'm having trouble displaying the $row[product_name] it says blank while the $row2['index'] seems to be doing fine all the data is being display, what seems to be the problem here? or it is illegal to put two parameters in while statement , any insights?

heres my code.

    

    $sql = mysql_query("SELECT * FROM product_detail LIMIT 5") or die(mysql_error());
    $sql2 = mysql_query("SELECT * FROM product LIMIT 5") or die(mysql_error());
    

    if($sql && $sql2){
        
    while($row = mysql_fetch_array($sql) && $row2 = mysql_fetch_array($sql2)){
        
     $product_name = $row["product_name"]; echo $row["product_name"] ;
     $product_id = $row2["product_id"];
     $product_qty = $row2["balance_qty"];
     $product_price = $row2["unit_price"];    
    
                            
                        echo '    <tr>
                                <td>'.$product_id.'</td>
                                <td>'.$product_name.'</td>
                                <td>'.$product_price.'</td>
                                <td>'.$product_qty.'</td>
                                </tr><br/>';
                          
     
     
        }

[salbahis]

two queries? i havent tried it yet, but i think dili na siya pwede, you need to use UNION then GROUP BY...

[ondoy]

dlini madala ug JOIN? refer ani bro SQL Joins

[stealthghost]

SQL Join nalang bro.. mas sure pa ka nga sakto ang data sa product and product detail..

[nohj]

try ni bro, Joining Tables in MySQL - Techotopia

[alexboi]

gamit ug JOIN TS...

[CodeZero]

use inner join bro.

[Klave]

Determine first if the while statement was used.
One way of doing it is place an echo statement after the while.
If that echo statement shows up, that means the loop was used.
Example: echo 'Loop starts here';

If it doesn't enter the loop there is a problem with your resultsets

If it does enter the loop.
Determine the values of $row and $row2.
One way is to use print_r($value) on both $row and $row2 to determine actual values.
Case sensitive baya na ang associative array sa PHP.
And sometimes, some SQL Servers return the columns in UPPERCASE

[MarkCuering]

Hi istoryans please tabangi ko and akong code kay dili sya mo display sa $row['product_name'] wala man unta koy problem nga na encounter completely blank jud sya, anyways seperate sila ug tables mao duha ka parameters ug pag query akong gigamit please help me!

I'm having trouble displaying the $row[product_name] it says blank while the $row2['index'] seems to be doing fine all the data is being display, what seems to be the problem here? or it is illegal to put two parameters in while statement , any insights?

heres my code.

    

    $sql = mysql_query("SELECT * FROM product_detail LIMIT 5") or die(mysql_error());
    $sql2 = mysql_query("SELECT * FROM product LIMIT 5") or die(mysql_error());
    

    if($sql && $sql2){
        
    while($row = mysql_fetch_array($sql) && $row2 = mysql_fetch_array($sql2)){
        
     $product_name = $row["product_name"]; echo $row["product_name"] ;
     $product_id = $row2["product_id"];
     $product_qty = $row2["balance_qty"];
     $product_price = $row2["unit_price"];    
    
                            
                        echo '    <tr>
                                <td>'.$product_id.'</td>
                                <td>'.$product_name.'</td>
                                <td>'.$product_price.'</td>
                                <td>'.$product_qty.'</td>
                                </tr><br/>';
                          
     
     
        }

i dont have php and mysql knowledge but is it ur query returns boolean? does it enters ur if statemen why not use LEFT JOIN? on product id? are you trying to create a master-detail view? i hope u have similar to datagridview. d

[Lorenzo]

This case is solved na istoryans, I used inner join to combine two tables and then, loop them using one variable.

Salamat sa help istoryans more power!