I'm just wondering if anyone can point out anything thats wrong with this php code. the weird thing is it works on my localhost (with correct database info) but doesn't work on my hosting (with correct database info aswell) no errors no text nothing. the page only loads up to this statement then stops.
PHP Code:
<?php
require_once('../mysqli_connect.php');
$q = "SELECT * FROM products WHERE type='indoor' ORDER BY price ASC LIMIT 6";
$r = @mysqli_query ($dbc, $q);
if ($r) {
while ($row = mysqli_fetch_array($r, MYSQLI_ASSOC)) {
Does the host have mysqli installed? You might have it locally, but your host doesn't which could be causing the problem, as they may just have the mysql extension installed. (The two are slightly different)
Try removing the @ sign from mysqli_query, as the @ suppresses error messages which may tell you what the problem is.
however limiting by 7 produces 6 results, but with my mysqli one limiting by 6 produces 6 results. I am new to php and i learned using the mysqli functions, this is gonna be difficult. ;(
The problem with this is that you first use mysql_fetch_array () to get the first record returned, which you store in $row.
However, next you use a while loop while mysql_fetch_array() is true. When the code execution gets to this point, it calls mysql_fetch_array() again for the first test to see if its true. This then overwrites the first record stored in $row before its printed to the screen, so for 7 results it would show 6 records.
Remove the line:
PHP Code:
$row = mysql_fetch_array( $result );
And it should work as intended, as the loop will start from the first record rather than the second.
ahh i see, thankyou for explaining tbp you truely know your stuff. I was stuck for 3 hours trying to figure out why the mysqli functions would not work.
It was in my php book,
PHP 6 and MYSQL 5 which i used to learn it all, seems like my hosting company is using mysql 4 and php 4 without as you said mysqli installed.
Yes, PHP 6 isn't actually available as a release version yet The principles are the same though so won't make much difference.
You can get inconsistencies between hosts though, as there are so many versions of PHP and ways to configure it. You do sometimes have to adapt your code round the host, which is why I don't develop locally anymore and test on the host instead. As you've seen code can work on one server and not another, and it does make it frustrating trying to track the issue down.
Theres no excuse for the host to be using PHP 4 though. I know some do, but they definately aren't good ones.
The principles are the same though so won't make much difference.
Linear Mode
