Forum Moderators: coopster

Message Too Old, No Replies

Button to call a query

         

ScriptJnr

11:43 pm on Mar 28, 2008 (gmt 0)

10+ Year Member



Is it possible to write a button or a link whose purpose it is to call a particular query?

e.g

$query = "SELECT basket.userID, account.balance, basket.barCode, item.description, item.price, item.stockLeft, basket.quantityOrdered FROM basket, account, item WHERE basket.userID = account.userID ORDER BY basket.userID";

Help.

jatar_k

1:21 pm on Mar 29, 2008 (gmt 0)

WebmasterWorld Administrator 10+ Year Member



you could have a button that calls a script that executes that query

I am not sure that is much of an answer to your question, maybe try and explain more about what you are wanting to do.

bilenkyj

3:08 pm on Mar 31, 2008 (gmt 0)

10+ Year Member



use a form with a hidden field
name - trigger
value - go
Have an if statement saying - if trigger==go then execute your query!