Forums :: Query Manager and Recordset Wizard

DwZone Forum
Welcome to the DwZone-it Forum

FAQ

Memberlist

Usergroups

Query Manager and Recordset Wizard

DwZone Forum Index -> Query Manager and Recordset Wizard

Moderators: Administrators, Moderators

Mark all topics read

Hint: For improved responsiveness, use Internet Explorer 4 (or above) with Javascript enabled, choose 'Dynamic' from the View dropdown and hit 'Set Options' to save your changes.

	Search for
View Per page Messages Since

Messages 1 to 10 of 31 (Total: 17)

First | Prev | Next | Last

Subject

Author

Date

PHP Professional Query Getting No Errors but Blank Results Page

JarrellHill

8:44 17 Mar 2018

Just started using your PHP Professional Query Tool for MySqli method. I see that the tool is pulling
data from my "MySqli 5.7 database and PhP 5.6" WAMP server on my laptop. Using the test connection
inside of the wizard it pulls the data correctly.

However, its not showing the rows of data when I open a php page in mybrowser. Do I still need to use
the "Bind" feature to an appropriate table row that is a repeat region or does your code automatically bind
without me having to open the bind panel?

Here's my code. I went ahead and tried to bind it using drag and d_r_o_p in dreamweaver cs6 but it only showed
the name of my recordset and table field I was actually trying to display on the screen no results.

Appreciate any guidance on this. Thanks.

<table width="100%" border="0" cellspacing="5" cellpadding="0">
<tr>
<td>
<?php
//*****************************
// ProfRecWiz
// Repeat Region
// Before Selection Instance
//*****************************
$dwz_loop = 0;
$dwzLoopName = "Repeat1";
$dwzMaxRec = "-1";
do{
$dwz_loop += 1;
//End Repeat region
?>

<?php
//*****************************
// ProfRecWiz
// Repeat Region
// After Selection Instance
//*****************************
$dwzLoopName = "Repeat1";
if($dwzMaxRec != "" && $dwzMaxRec != "-1"){
if(intval($dwz_loop) >= intval($dwzMaxRec)){
break;
}
}
}while($row_Recordset1 = mysqli_fetch_assoc($Recordset1));
//End Repeat region
?>
<td> <?php echo dwzGetRecValue('Recordset1','Product'); ?></td>
<td><?php echo dwzGetRecValue('Recordset1','ShortDescription'); ?></td>
<td> </td>
<td><?php echo dwzGetRecValue('Recordset1','LongDescription'); ?></td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>