| | |
Please Help!! PHP code renders in blank :(
Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
![]() |
•
•
Join Date: Aug 2008
Posts: 24
Reputation:
Solved Threads: 1
Guys i am going crazy here I dont know what I am doing wrong here, it renders in blank the page.
I apreciatte very much your help.
Oma
I apreciatte very much your help.
Oma
PHP Syntax (Toggle Plain Text)
<?php //include("functions.php"); //dbConnect(); //ADD YOUR OWN DB CONNECTION HERE ?> <html> <head> <meta http-equiv="content-type" content="text/html;charset=utf-8" /> <meta name="generator" content="Adobe GoLive" /> <title>cr1_search</title> </head> <body> <table border="0" cellspacing="0" cellpadding="10"> <tr> <FORM name="search" METHOD="POST" > <td align="left" valign="middle"><select name="application" size="1" onchange="this.form.submit()"> <option value="" <?php checkSelection($application,"");?>>- Select -</option><?php $sql = "SELECT * FROM application ORDER BY application_name"; $result = mysql_query($sql); while ($row = mysql_fetch_array($result)) { $sql1 = "SELECT count(*) AS num_results FROM model WHERE suspension_id LIKE '%$row[application_id]%' "; $result1 = mysql_query($sql1); $count = mysql_fetch_array($result1); $num_of_results = $count[num_results]; ?> <option value="<?=$row['application_id']?>" <?php checkSelection($_POST['application'],$row['application_id']);?>><?=$row['app lication_name'].' ('.$num_of_results.')';?></option><?php } ?> </select></td> <td align="left" valign="middle"><?PHP if ($_POST[application] != '') { ?><select name="manufacturer" size="1" onchange="this.form.submit()"> <option value="" <?php checkSelection($manufacturer,"");?>>- Select -</option><?php //$sql = "SELECT DISTINCT manufacturer.manufacturer_name,manufacturer.manufacturer_id FROM manufacturer,product WHERE manufacturer.manufacturer_id = product.manufacturer_id AND product.application_id LIKE '%$_POST[application]%' ORDER BY manufacturer_name"; $sql = "SELECT * FROM manufacturer ORDER BY manufacturer_name"; $result = mysql_query($sql); while ($row = mysql_fetch_array($result)) { $sql1 = "SELECT count(DISTINCT model_name) AS num_results FROM model WHERE manufacturer_id LIKE '%$row[manufacturer_id]%' AND suspension_id = '$_POST[application]' "; $result1 = mysql_query($sql1); $count = mysql_fetch_array($result1); $num_of_results = $count[num_results]; ?> <option value="<?=$row['manufacturer_id']?>" <?php checkSelection($_POST['manufacturer'],$row['manufacturer_id']);?>><?=$row['m anufacturer_name'].' ('.$num_of_results.')';?></option><?php } ?> </select><?PHP } ?></td> <td align="left" valign="middle"><?PHP if ($_POST[manufacturer] != '' AND $_POST[application] != '') { ?><select name="model" size="1" onchange="this.form.submit()"> <option value="" <?php checkSelection($model,"");?>>- Select -</option><?php $sql = "SELECT DISTINCT model_name FROM model WHERE manufacturer_id = '$_POST[manufacturer]' AND suspension_id = '$_POST[application]' ORDER BY model_name"; $result = mysql_query($sql); while ($row = mysql_fetch_array($result)) { //$sql1 = "SELECT count(*) AS num_results FROM product WHERE model_id LIKE '%$row[model_id]%' "; //$result1 = mysql_query($sql1); //$count = mysql_fetch_array($result1); //$num_of_results = $count[num_results]; ?> <option value="<?=$row['model_name']?>" <?php checkSelection($_POST['model'],$row['model_name']);?>><?=$row['model_name']; ?></option><?php } ?> </select><?PHP } ?></td> <td align="left" valign="middle"><?PHP if ($_POST[manufacturer] != '' AND $_POST[application] != ''AND $_POST[model] != '') { ?><select name="year" size="1" onchange="this.form.submit()"> <option value="" <?php checkSelection($year,"");?>>- Select -</option><?php $sql = "SELECT year_name,model_id FROM model WHERE model_name = '$_POST[model]' ORDER BY year_name"; $result = mysql_query($sql); while ($row = mysql_fetch_array($result)) { //$sql1 = "SELECT count(*) AS num_results FROM product WHERE year_id LIKE '%$row[year_id]%' "; //$result1 = mysql_query($sql1); //$count = mysql_fetch_array($result1); //$num_of_results = $count[num_results]; ?> <option value="<?=$row['model_id']?>" <?php checkSelection($_POST['year'],$row['model_id']);?>><?=$row['year_name'];?></ option><?php } ?> </select><?PHP } ?></td> </FORM></tr> </table> <?PHP if ($_POST[year] != '') { $sql2 = "SELECT * FROM product WHERE model_id LIKE '%$_POST[year]%' "; $result2 = mysql_query($sql2); if ($result2 == TRUE) { while ($info = mysql_fetch_array($result2)) { ?> <table width="180" border="1" cellspacing="2" cellpadding="0"> <tr> <td>Image</td> <td>Description</td> <td>Option</td> </tr> <tr> <td><a title="<?=$info['product_name']?>" href="<?=$info['large_pic']?>" target="_new"><img src="<?=$info['small_pic']?>" border="0"></a></td> <td><?=$info['product_name'];?></td> <td></td> </tr> </table> <?PHP } } if ($result2 == FALSE) { $search_error = "Sorry no products are currently available for your search."; } } ?><?=$search_error;?> </body> </html>
•
•
Join Date: Sep 2008
Posts: 8
Reputation:
Solved Threads: 1
Hi Oma,
There's a parse error in your code, you need to remove the extra '}'. I've split up your code so you can see where the error is.
You need to remove this '}'.
Hope this helps.
Adnan
There's a parse error in your code, you need to remove the extra '}'. I've split up your code so you can see where the error is.
•
•
•
•
Guys i am going crazy here I dont know what I am doing wrong here, it renders in blank the page.
PHP Syntax (Toggle Plain Text)
<?php //include("functions.php"); //dbConnect(); //ADD YOUR OWN DB CONNECTION HERE ?> <html> <head> <meta http-equiv="content-type" content="text/html;charset=utf-8" /> <meta name="generator" content="Adobe GoLive" /> <title>cr1_search</title> </head> <body> <table border="0" cellspacing="0" cellpadding="10"> <tr> <FORM name="search" METHOD="POST" > <td align="left" valign="middle"><select name="application" size="1" onchange="this.form.submit()"> <option value="" <?php checkSelection($application,"");?>>- Select -</option><?php $sql = "SELECT * FROM application ORDER BY application_name"; $result = mysql_query($sql); while ($row = mysql_fetch_array($result)) { $sql1 = "SELECT count(*) AS num_results FROM model WHERE suspension_id LIKE '%$row[application_id]%' "; $result1 = mysql_query($sql1); $count = mysql_fetch_array($result1); $num_of_results = $count[num_results]; ?> <option value="<?=$row['application_id']?>" <?php checkSelection($_POST['application'],$row['application_id']);?>><?=$row['app lication_name'].' ('.$num_of_results.')';?></option><?php } ?> </select></td> <td align="left" valign="middle"><?PHP if ($_POST[application] != '') { ?><select name="manufacturer" size="1" onchange="this.form.submit()"> <option value="" <?php checkSelection($manufacturer,"");?>>- Select -</option><?php //$sql = "SELECT DISTINCT manufacturer.manufacturer_name,manufacturer.manufacturer_id FROM manufacturer,product WHERE manufacturer.manufacturer_id = product.manufacturer_id AND product.application_id LIKE '%$_POST[application]%' ORDER BY manufacturer_name"; $sql = "SELECT * FROM manufacturer ORDER BY manufacturer_name"; $result = mysql_query($sql); while ($row = mysql_fetch_array($result)) { $sql1 = "SELECT count(DISTINCT model_name) AS num_results FROM model WHERE manufacturer_id LIKE '%$row[manufacturer_id]%' AND suspension_id = '$_POST[application]' "; $result1 = mysql_query($sql1); $count = mysql_fetch_array($result1); $num_of_results = $count[num_results]; ?> <option value="<?=$row['manufacturer_id']?>" <?php checkSelection($_POST['manufacturer'],$row['manufacturer_id']);?>><?=$row['m anufacturer_name'].' ('.$num_of_results.')';?></option><?php } ?> </select><?PHP
•
•
•
•
PHP Syntax (Toggle Plain Text)
?></td> <td align="left" valign="middle"><?PHP if ($_POST[manufacturer] != '' AND $_POST[application] != '') { ?><select name="model" size="1" onchange="this.form.submit()"> <option value="" <?php checkSelection($model,"");?>>- Select -</option><?php $sql = "SELECT DISTINCT model_name FROM model WHERE manufacturer_id = '$_POST[manufacturer]' AND suspension_id = '$_POST[application]' ORDER BY model_name"; $result = mysql_query($sql); while ($row = mysql_fetch_array($result)) { //$sql1 = "SELECT count(*) AS num_results FROM product WHERE model_id LIKE '%$row[model_id]%' "; //$result1 = mysql_query($sql1); //$count = mysql_fetch_array($result1); //$num_of_results = $count[num_results]; ?> <option value="<?=$row['model_name']?>" <?php checkSelection($_POST['model'],$row['model_name']);?>><?=$row['model_name']; ?></option><?php } ?> </select><?PHP } ?></td> <td align="left" valign="middle"><?PHP if ($_POST[manufacturer] != '' AND $_POST[application] != ''AND $_POST[model] != '') { ?><select name="year" size="1" onchange="this.form.submit()"> <option value="" <?php checkSelection($year,"");?>>- Select -</option><?php $sql = "SELECT year_name,model_id FROM model WHERE model_name = '$_POST[model]' ORDER BY year_name"; $result = mysql_query($sql); while ($row = mysql_fetch_array($result)) { //$sql1 = "SELECT count(*) AS num_results FROM product WHERE year_id LIKE '%$row[year_id]%' "; //$result1 = mysql_query($sql1); //$count = mysql_fetch_array($result1); //$num_of_results = $count[num_results]; ?> <option value="<?=$row['model_id']?>" <?php checkSelection($_POST['year'],$row['model_id']);?>><?=$row['year_name'];?></ option><?php } ?> </select><?PHP } ?></td> </FORM></tr> </table> <?PHP if ($_POST[year] != '') { $sql2 = "SELECT * FROM product WHERE model_id LIKE '%$_POST[year]%' "; $result2 = mysql_query($sql2); if ($result2 == TRUE) { while ($info = mysql_fetch_array($result2)) { ?> <table width="180" border="1" cellspacing="2" cellpadding="0"> <tr> <td>Image</td> <td>Description</td> <td>Option</td> </tr> <tr> <td><a title="<?=$info['product_name']?>" href="<?=$info['large_pic']?>" target="_new"><img src="<?=$info['small_pic']?>" border="0"></a></td> <td><?=$info['product_name'];?></td> <td></td> </tr> </table> <?PHP } } if ($result2 == FALSE) { $search_error = "Sorry no products are currently available for your search."; } } ?><?=$search_error;?> </body> </html>
Adnan
Last edited by tgbyhn; Sep 10th, 2008 at 12:48 am.
•
•
Join Date: Sep 2008
Posts: 8
Reputation:
Solved Threads: 1
Also you could alter your php.ini file, and change these values to:
error_reporting = E_ALL
display_errors = On
This will show you where the errors are. Although note that "display_errors = On" isn't recommended for production systems and should be Off.
If you prefer not to enable "display_errors" you could look for your web server's error log, as it should be in there too.
Adnan
error_reporting = E_ALL
display_errors = On
This will show you where the errors are. Although note that "display_errors = On" isn't recommended for production systems and should be Off.
If you prefer not to enable "display_errors" you could look for your web server's error log, as it should be in there too.
Adnan
•
•
Join Date: Aug 2008
Posts: 24
Reputation:
Solved Threads: 1
OK guys I am about to scream, damn so here is my entire CODE, i dont have any functions.php file.
The code was given to me, i am trying to have a list/menu and then pass the result to another list/menu dynamically HONESTLY I DONT KNOW what i am doing wrong here. HELP! Thank you very much
The code was given to me, i am trying to have a list/menu and then pass the result to another list/menu dynamically HONESTLY I DONT KNOW what i am doing wrong here. HELP! Thank you very much
PHP Syntax (Toggle Plain Text)
<?php $dbserver = "MYSERVER.com"; $user = "USERME"; $db = "DB2008"; $pwd = "MYPASS"; global $link; $link = mysql_connect($dbserver,$user,$pwd); mysql_select_db($db, $link); ?> <html> <head> <meta http-equiv="content-type" content="text/html;charset=utf-8" /> <meta name="generator" content="Adobe GoLive" /> <title>cr1_search</title> </head> <body> <table border="1" cellspacing="0" cellpadding="10"> <tr> <FORM name="search" METHOD="POST" > <td align="left" valign="middle"><select name="application" size="1" onchange="this.form.submit()"> <option value="" <?php checkSelection($application,"");?>>- Select -</option><?php $sql = "SELECT * FROM application ORDER BY application_name"; $result = mysql_query($sql); while ($row = mysql_fetch_array($result)) { $sql1 = "SELECT count(*) AS num_results FROM model WHERE suspension_id LIKE '%$row[application_id]%' "; $result1 = mysql_query($sql1); $count = mysql_fetch_array($result1); $num_of_results = $count[num_results]; ?> <option value="<?=$row['application_id']?>" <?php checkSelection($_POST['application'],$row['application_id']);?>><?=$row['app lication_name'].' ('.$num_of_results.')';?></option><?php } ?> </select> <br> <br> <br> <br></td> <td align="left" valign="middle"><?PHP if ($_POST[application] != '') { ?><select name="manufacturer" size="1" onChange="this.form.submit()"> <option value="" <?php checkSelection($manufacturer,"");?>>- Select -</option><?php //$sql = "SELECT DISTINCT manufacturer.manufacturer_name,manufacturer.manufacturer_id FROM manufacturer,product WHERE manufacturer.manufacturer_id = product.manufacturer_id AND product.application_id LIKE '%$_POST[application]%' ORDER BY manufacturer_name"; $sql = "SELECT * FROM manufacturer ORDER BY manufacturer_name"; $result = mysql_query($sql); while ($row = mysql_fetch_array($result)) { $sql1 = "SELECT count(DISTINCT model_name) AS num_results FROM model WHERE manufacturer_id LIKE '%$row[manufacturer_id]%' AND suspension_id = '$_POST[application]' "; $result1 = mysql_query($sql1); $count = mysql_fetch_array($result1); $num_of_results = $count[num_results]; ?> <option value="<?=$row['manufacturer_id']?>" <?php checkSelection($_POST['manufacturer'],$row['manufacturer_id']);?>><?=$row['m anufacturer_name'].' ('.$num_of_results.')';?></option><?php } ?> </select><?PHP ?></td> <td align="left" valign="middle"><?PHP if ($_POST[manufacturer] != '' AND $_POST[application] != '') { ?><select name="model" size="1" onChange="this.form.submit()"> <option value="" <?php checkSelection($model,"");?>>- Select -</option><?php $sql = "SELECT DISTINCT model_name FROM model WHERE manufacturer_id = '$_POST[manufacturer]' AND suspension_id = '$_POST[application]' ORDER BY model_name"; $result = mysql_query($sql); while ($row = mysql_fetch_array($result)) { //$sql1 = "SELECT count(*) AS num_results FROM product WHERE model_id LIKE '%$row[model_id]%' "; //$result1 = mysql_query($sql1); //$count = mysql_fetch_array($result1); //$num_of_results = $count[num_results]; ?> <option value="<?=$row['model_name']?>" <?php checkSelection($_POST['model'],$row['model_name']);?>><?=$row['model_name']; ?></option><?php } ?> </select><?PHP } ?></td> <td align="left" valign="middle"><?PHP if ($_POST[manufacturer] != '' AND $_POST[application] != ''AND $_POST[model] != '') { ?><select name="year" size="1" onChange="this.form.submit()"> <option value="" <?php checkSelection($year,"");?>>- Select -</option><?php $sql = "SELECT year_name,model_id FROM model WHERE model_name = '$_POST[model]' ORDER BY year_name"; $result = mysql_query($sql); while ($row = mysql_fetch_array($result)) { //$sql1 = "SELECT count(*) AS num_results FROM product WHERE year_id LIKE '%$row[year_id]%' "; //$result1 = mysql_query($sql1); //$count = mysql_fetch_array($result1); //$num_of_results = $count[num_results]; ?> <option value="<?=$row['model_id']?>" <?php checkSelection($_POST['year'],$row['model_id']);?>><?=$row['year_name'];?></ option><?php } ?> </select><?PHP } ?></td> </FORM></tr> </table> <?PHP if ($_POST[year] != '') { $sql2 = "SELECT * FROM product WHERE model_id LIKE '%$_POST[year]%' "; $result2 = mysql_query($sql2); if ($result2 == TRUE) { while ($info = mysql_fetch_array($result2)) { ?> <table width="180" border="1" cellspacing="2" cellpadding="0"> <tr> <td>Image</td> <td>Description</td> <td>Option</td> </tr> <tr> <td><a title="<?=$info['product_name']?>" href="<?=$info['large_pic']?>" target="_new"><img src="<?=$info['small_pic']?>" border="0"></a></td> <td><?=$info['product_name'];?></td> <td></td> </tr> </table> <?PHP } } if ($result2 == FALSE) { $search_error = "Sorry no products are currently available for your search."; } } ?><?=$search_error;?> </body> </html>
Well, if you can, try and obtain a copy of functions.php from whomever gave you the code. Apparently there's a function you need and it's missing.
Also, a group of dynamic drop downs like that would be much easier to do with just Javascript that's generated by PHP. Something described in this thread.
Also, a group of dynamic drop downs like that would be much easier to do with just Javascript that's generated by PHP. Something described in this thread.
Last edited by MVied; Sep 10th, 2008 at 4:35 pm.
![]() |
Similar Threads
- LogicWeb / CSS Question (HTML and CSS)
Other Threads in the PHP Forum
- Previous Thread: problem with include files...
- Next Thread: Distributing an HTML email to a mailing list
| Thread Tools | Search this Thread |
ajax apache api array basics beginner binary broken cakephp checkbox class cms code codingproblem combobox cron curl database date display domain dynamic echo email error file files folder form format forms function functions google href htaccess html image include insert interactive ip java javascript joomla js limit link load login mail malfunctioning menu mlm mobile multiple mysql nodes oop outofmemmory paging parse paypal pdf php problem procedure query radio ram random recursion reference remote return script search server sessions sms source space sql syntax system table tutorial unset up-to-date update upload url validation validator variable video web webapplications websitecontactform youtube





