Click here to Skip to main content
14,661,500 members
Rate this:
Please Sign up or sign in to vote.
See more:
Doing the query on the database it gets the correct results, but the table is empty. Any suggestion?
<TABLE>

<?php

$userid=$_SESSION['userid'];

$result=mysql_query("SELECT * FROM companies WHERE company='$_GET[company]' and car_moto='$_GET[car_moto]' and packet='$_GET[packet]' and userid='$userid'");
$num=mysql_num_rows($result);

$i=0;

while ($i < $num) {
        $f0=mysql_result($result,$i,"id");
        $f1=mysql_result($result,$i,"company");
        $f2=mysql_result($result,$i,"car_moto");
        $f3=mysql_result($result,$i,"packet");
        $f4=mysql_result($result,$i,"protect");
        $f5=mysql_result($result,$i,"price_protect");
        $f6=mysql_result($result,$i,"clear_protect");

        echo "<tr><td align='center'><span>$f1</span></td><td align='center'><span>$f2</span></td><td align='center'><span>$f3</span></td><td align='center'><span>$f4</span></td><td align='center'><span>$f5</span></td><td align='center'><span>$f6</span></td></tr>";
$i++;

}

?>

</TABLE>
Posted
Updated 6-Sep-13 2:01am
v3
Comments
ArunRajendra 6-Sep-13 7:31am
   
Can you check if its entering while loop. Else I don't see the reason for the table to be empty.

Rate this:
Please Sign up or sign in to vote.

Solution 1

Try adding the following :
...
echo $result;
$num=mysql_num_rows($result);
echo $num; 
echo $result;
...

and see what $num is and what happens to $result.
   
Comments
bmaglar 6-Sep-13 7:38am
   
Resource id #30Resource id #3
bmaglar 6-Sep-13 7:48am
   
the query works perfect at the database, not echo $result;
Rate this:
Please Sign up or sign in to vote.

Solution 2

I have to add

<pre>mysql_query("set character set 'utf8'");


before

$result=mysql_query("SELECT * FROM companies WHERE company='$_GET[company]' and car_moto='$_GET[car_moto]' and packet='$_GET[packet]' and userid='$userid'");


and the table is ok
   

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month



CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100