Jump to content

MYSQL Returning empty result sets!!!


willl

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

Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

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.