<br><div><span class="gmail_quote">On 12/14/05, <b class="gmail_sendername">Russ Schneider</b> <<a href="mailto:russ@sugapablo.com">russ@sugapablo.com</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Semi-Off-Topic, since it MAY be a server config issue:<br><br>I have a small test script connecting to a MySQL database. It seems to<br>work, unless I try to use the resource link identifier returned by<br>mysql_connect();
<br><br>This does NOT work and returns no rows:<br><br><?php<br>include("../config.php");<br><br>$dbi = mysql_connect($dbhost,$dbuname,$dbpass);<br>mysql_select_db($dbname);<br><br>$res = mysql_query("SELECT * FROM temp_stories",$dbi);
<br><br>if($dbi)<br> echo "PASS<BR>";<br>else<br> echo "FAIL<BR>";<br><br>while($row = mysql_fetch_array($res)) {<br> echo $row['title']."<br/>";<br>}<br>
?></blockquote><div><br><br>Try putting "or die('Query failed: ' . mysql_error());" at the end of your query statement. ...<br>$res = mysql_query("SELECT * FROM temp_stories",$dbi) or die('Query failed: ' .mysql_error());
<br><br>That will print any errors from mysql.<br><br>Chris <br></div><br></div><br>