Jump to content

Archived

This topic is now archived and is closed to further replies.

willl

MYSQL Returning empty result sets!!!

Recommended Posts

Hello,

 

I hope someone knows what this problem might be;

 

I have designed and built a website and tested the php/mysql code using phpdev which simulates an apache/mysql/php server using the localhost on my pc.

 

All the queries work perfectly, however I have just uploaded my site to the actual webserver and most of the queries are returning empty result sets!

 

It's like they are there because for instance; a while ($row = mysql_fetch_array.... does return the correct amount of rows! One while loop I have wrapped each result in a div and u can just see empty divs for the right amount of rows!!

 

Another example: I have a database of keywords, a while loop prints each keyword seperated by a comma - the right amount of commas are there!

 

 

This is an example of a code that is returning empty sets:

 

 

 

$query = "SELECT * from company_ins, company_log WHERE company_ins.ins_id = '$typeid' AND company_log.Id = company_ins.company_Id order by company_log.name"; 

$result = mysql_query($query, $conn);     

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

if ($row['type_featured'] != 'f') { 
     
?> 
<div class="linkbox"> 

<a href="<?php echo $row['link']; ?>" class="link" target="_blank"><strong><?php echo $row['name']; ?></strong></a> 

<p><?php echo $row['description']; ?></p> 

<p><a href="<?php echo $row['link']; ?>" target="_blank"><?php echo $row['link2']; ?></a></p> 

</div> 
<?php 
    } 
} 
?>  

 

 

 

I just thought - do you think I need to be using an INNER JOIN select query here?

 

Any thoughts?

 

Thanks!

 

Will

Share this post


Link to post
Share on other sites

I was using incorrect mysql_fetch_array syntax.

 

(Should not have included $conn)

 

 

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.