close ad
Install the LAtest Updates to Work with CC 2017 and CC 2018
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

mySQLi show if recordset empty / not empty not opening

Thread began 3/29/2015 9:17 am by Nathan69474 | Last modified 3/30/2015 2:46 pm by Jason Byrnes | 1137 views | 5 replies |

Nathan69474

mySQLi show if recordset empty / not empty not opening

Using mysql of the first time today, seems nice, but have a problem, when selecting show if recordset empty or recordset not empty the screen wizard hangs. I have uninstalled and re-installed but still be working

I'm in the middle of converting a site from mysql to mysqli and desparately need to know the coding format for show if empty and also show if not empty

could you please let me the coding so I can copy & paste / replace the old D/W coding

I've copied the normal dreamweaver coding that I need updating could you please update the syntax for me

<?php if ($totalRows_rsNav1 > 0) { // Show if recordset not empty ?>
navigation list / page content
<?php } // Show if recordset not empty ?>

<?php if ($totalRows_rsNav1 == 0) { // Show if recordset empty ?>
navigation list / page content
<?php } // Show if recordset empty ?>

None of the show regions tabs open, but the other function all seem to work

Thanks
Nathan

Sign in to reply to this post

Jason ByrnesWebAssist

the equivalent in MySQLi would be:
<?php if ($rsNav1->TotalRows == 0) { // Show if mysqli recordset empty ?>
Recordset is empty
<?php } // Show if mysqli recordset empty ?>

<?php if ($rsNav1->TotalRows > 0) { // Show if mysqli recordset not empty ?>
Recordset is NOT empty
<?php } // Show if mysqli recordset not empty ?>

Sign in to reply to this post

Nathan69474

Thanks Jason

so in essence myqli vs mysl swaps the ordering of the syntax
from: $Function_RecordsetName ... ie $totalRows_rsNav1
to: $RecordsetName ->Function .... ie $rsNav1->TotalRows

At some point, when convenient, can you look into whether there's a bug in the extension which is preventing me from opening all of the Show Region tabs

I'm using latest version of extension 1.03 on mac DW CC 2014.1 version all system fully upto date
... extension uninstalled and reinstalled.

Thanks
Nathan

Sign in to reply to this post

Jason ByrnesWebAssist

I'm not able to reproduce the blank window.


Please provide a Skype username or a US phone number and a good time to contact you when you will be in front of your computer and we will have an engineer contact you to resolve this issue over the phone.

We are available Monday - Friday from 9am - 4pm EST (except major U.S. holidays).

Sign in to reply to this post

Nathan69474

Turn it Off and On again !!!

Solved !

You know that age old IT help desk trick of turn it off and on again ... well that work !

Yesterday, I'd closed DW, uninstalled the extension, reinstalled it, and then re-opened DW ..the Show region tab didn't open

Today, having shutdown the computer completely overnight, I have just re-tried and it now opens the Show region tab

Why ..I have no idea, I'm sure there will be technical explanation for this, but next time I have a minor bug like this I will.. Turn it Off and On again !!!

Thanks
Nathan

PS and thanks for the Skype time offer ..as always you do as the name suggests.. by offering WebAssist(ance) !

Sign in to reply to this post

Jason ByrnesWebAssist

Glad to hear it is working.

Sign in to reply to this post

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...