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

Sql Code and show utility

Thread began 7/15/2013 5:17 pm by Jon Cunningham | Last modified 7/18/2013 12:23 pm by Jason Byrnes | 1031 views | 26 replies |

Jon CunninghamBeta Tester

Sql Code and show utility

Hi Guys,

Could someone with Sql experience check my code please.

This is what I am trying to do.

I have a DetailProductID column in my database that has either a 1 or 2 written to it.

and I want an image / link to show if its a 1 and a different image / link if its 2.

This is what i have so far.

My Sql for DetailProductID with 1

SELECT users.UserID, orders.OrderUserID, orders.OrderID, orderdetails.DetailOrderID, orderdetails.DetailProductID
FROM users, orders, orderdetails
WHERE orders.OrderID = orderdetails.DetailOrderID AND orderdetails.DetailOrderID = orders.OrderID AND orderdetails.DetailProductID = 1 AND users.UserID = paramUserID

paramUserID Varibles with $_GET['UserID']

My php code

<?php if ($row_rsCourse1['DetailProductID'] == 1) { // Show if column... ?>
<span> <a href="users_ST_update.php?UserID=<?php echo($row_WADAusers["UserID"]); ?>"><img src="images/ST500DetailButton.png" alt="" width="200" height="38" /></a></span>
<?php } // Show if column... ?>

My Sql for DetailProductID with 2

SELECT users.UserID, orders.OrderUserID, orders.OrderID, orderdetails.DetailOrderID, orderdetails.DetailProductID
FROM users, orders, orderdetails
WHERE orders.OrderID = orderdetails.DetailOrderID AND orderdetails.DetailOrderID = orders.OrderID AND orderdetails.DetailProductID = 2 AND users.UserID = paramUserID

paramUserID Varibles with $_GET['UserID']

My php code

<?php if ($row_rsCourse2['DetailProductID'] == 2) { // Show if column... ?>
<span> <a href="users_ST_update.php?UserID=<?php echo($row_WADAusers["UserID"]); ?>"><img src="images/ST500DetailButton.png" alt="" width="200" height="38" /></a></span>
<?php } // Show if column... ?>

At the moment all I am getting is the image and link for DetailProductID 1 for both


Am I over thinking this?

I have added my page code to the attachments.

Any help would be greatly appreciated.

Kind regards

Jonathon

Attached Files
users_detail.zip
Sign in to reply to this post

Jason ByrnesWebAssist

the code inside of each if statement is the same.

this will give the same results for each if statement.

Sign in to reply to this post

Jon CunninghamBeta Tester

Hi Jason, Good Morning to you.

The link is the same for both show regions (Temp). But the code is different inside the if statement

['DetailProductID'] == 1)

and

['DetailProductID'] == 2)

the code in the attached page does not have my typo for the image file being the same.
For clarity, DetailProductID is set to 1 in the DB so in theory both should not show on the page Please see attached image

Sign in to reply to this post

Jason ByrnesWebAssist

but you are using 2 diferant recordsets.

in the first recordset, you are retunring records where the DetailProductID is equal to 1, so the first if statement is true.

in the second recordset, you are returning records where the DetailProductID is equal to 2, so again, the if statement is true.

Sign in to reply to this post

Jon CunninghamBeta Tester

so if i had say 1 record set with a SQL statement of

SELECT users.UserID, orders.OrderUserID, orders.OrderID, orderdetails.DetailOrderID, orderdetails.DetailProductID
FROM users, orders, orderdetails
WHERE orders.OrderID = orderdetails.DetailOrderID AND orderdetails.DetailOrderID = orders.OrderID AND users.UserID = paramUserID

paramUserID Varibles with $_GET['UserID']

then the following should work in theory.

<?php if ($row_rsCourse['DetailProductID'] == 1) { // Show if column... ?>
<span> <a href="users_ST_update.php?UserID=<?php echo($row_WADAusers["UserID"]); ?>"><img src="images/ST500DetailButton.png" alt="" width="200" height="38" /></a></span>
<?php } // Show if column... ?>

and

<?php if ($row_rsCourse['DetailProductID'] == 2) { // Show if column... ?>
<span> <a href="users_ST_update.php?UserID=<?php echo($row_WADAusers["UserID"]); ?>"><img src="images/DetailButton.png" alt="" width="200" height="38" /></a></span>
<?php } // Show if column... ?>

So if customer purchases course 1 all that will show is button for course 1 and if they purchase course 2 the just button 2 will show.

Therefore if they purchase both courses both buttons will show?

Regards

Jonathon

Sign in to reply to this post

Jason ByrnesWebAssist

you would need a repeat region to loop through the recordset to show all courses purchased.

Sign in to reply to this post

Jon CunninghamBeta Tester

Ok I am with you so far but each course has its own DetailProductID and should only show the link when a course has been purchased. Each link has its own landing page which are different for each course

Hence I was going for a show if statement as I can then list all courses and ones that are purchased under orderdetails.DetailProductID will show with there own unique link.

Sign in to reply to this post

Jason ByrnesWebAssist

thats all well and good, but you still the repeat region to loop through the recordset.

Sign in to reply to this post

Jon CunninghamBeta Tester

Ok So using the above code can you tell me how I go about using the repeat region to loop through the record set.

Many thanks for the advice.

Kind regards

Jonathon

Sign in to reply to this post

Jason ByrnesWebAssist

simply add a repeat region around the code.

Sign in to reply to this post
loading

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...