Blank?

DizzyD

This is a super simple script and looks correct, yet i get a blank screen. Does anything look incorrect?

<?php

include 'dbconfig.php';
include 'opendb.php';

$string = $_POST['search'];

$sql = "SELECT * FROM dealers WHERE zip LIKE '$string'";
$query = mysql_query($sql) or die(mysql_error());
$row_sql = mysql_fetch_assoc($query);
$total = mysql_num_rows($query);


if($total>0) {
    while ($row_sql = mysql_fetch_assoc($query)) {//echo out the results
    echo "Search Successfull. Blah Blah Blah";
    }
} else
    {
    echo "No results to display";
}


?>

I have a simple database with dealer info such as business name, phone, web, city, state, zip. And i just wanted to be able to do a zip search to pull up the listing. No dice . Any ideas?

btw, when I perform a search with a zip that isn't in the db I get the "No Results to display". but when i search with zip that is in the db, the output is blank.

NogDog

There are no syntax errors in the code you've shown, though of course there could be something in either of the two include files. Assuming there aren't any, you could add the following to the start of your script (before the include calls) to ensure any errors are being displayed:

<?php
ini_set('display_errors', 1);
error_reporting(E_ALL);

DizzyD

Thanks for the prompt reply. Unfortunately, even adding that, there were no errors displayed... IS it possible some of the functions i'm using may not be supported in my version of php or something?

DizzyD

dbconfig.php

<?php
$dbhost = 'localhost';
$dbuser = 'xyz';
$dbpass = 'xyz';

$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die                      ('Error connecting to mysql');

$dbname = 'franchises';
mysql_select_db($dbname);
?>

opendb.php

<?php

$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die                      ('Error connecting to mysql');
mysql_select_db($dbname);
?>

just for the record ^ 🙂

NogDog

All things are possible. 🙂

If something is not parsing, if your PHP system configuration has the "display_errors" setting set to "off", then you will not see any output if a parse error is encountered. If this is the case, you will either need to locate the PHP error log and see what interesting information it might have, or else change you configuration to turn on error display. This can be done globally via the php.ini file, or on a per directory basis via a .htaccess file (assuming an Apache web server).

DizzyD

mkay.. I don't have access to the php.ini atm but do you have the code for the htaccess? As i don't recall it off hand 🙂

NogDog

.htaccess

php_flag display_errors on
php_value error_reporting E_ALL

DizzyD

SOB!!! even adding that to my .htaccess i still get no dice

DizzyD

anyone have any script suggestions? something that would produce the same results? well, not the results i'm getting right now 😉

NogDog

Silly question, but just to cover all bases: are you sure PHP is installed/enabled on this server? Does the following script work?

<?php
phpinfo();
?>

DizzyD

lol. Yes i do have php on the server. All pages of the site are in php. i just get a blank for some reason on this specific script...

DizzyD

and just for the record. I'm running php5 however i just switched to php4 and tried and still same response.

DizzyD

UPDATE
ok, i removed

while ($row_sql = mysql_fetch_assoc($query))

and the script worked. however i obviously cant keep looping as i will only get 1 result this way. I don't know if it was because the db only had 1 result? I dunno. But for some reason the second i put "WHILE" back in there i get blank screen. So for the time being i can only display 1 result... Any Ideas?

NogDog

DizzyD wrote:
UPDATE
ok, i removed
while ($row_sql = mysql_fetch_assoc($query))
and the script worked. however i obviously cant keep looping as i will only get 1 result this way. I don't know if it was because the db only had 1 result? I dunno. But for some reason the second i put "WHILE" back in there i get blank screen. So for the time being i can only display 1 result... Any Ideas?

Remove the mysql_fetch_assoc() right after you execute the query. (It's reading the first result row but doing nothing with it, but it does move the result row pointer to the next row, so if there was only one result, then the while loop won't have any results.)