Search results for query: *

Hi, I need to display the number of guitar tabs, drum tabs, bass tabs, lyrics for each band. I understand that query below gets the information but I don't know how to display it for each band. Here's the code so you can see what I'm on about: $query = mysql_query(" SELECT b.id...

Hi, Basically I have a loop which does the following: $query = mysql_query("SELECT * FROM bands"); while($band = mysql_fetch_array($query)) { $tabs = tablinks($band['id']); echo $tabs; } As it goes through the loop the tablinks function is done which contains 5 additional queries...

Hi, I know this sounds easy from the topic but what I'm wondering is how to delete just one record even if the criteria matches more than once. For example say you have the table member_items: uid | iid 1 | 2 1 | 2 Where uid is the members uid and iid is the items id. I want to be able...

Hi I wish to access my files at http://www.domain.ext/forum/threads/165 instead of http://www.domain.ext/forum/viewthread.php?tid=165 So I created a .htaccess file (and put it in the forum directory) with the following content: RewriteEngine on RewriteRule ^forums/([0-9]+)/([0-9]+)...

Hi, I've got a problem I expect you guys'll solve in 5 seconds but has been troubling all day. Right here it is. I've got the following code: <script language="JavaScript"> function updateCurrency() { var totamount = document.newItem.payment.value writeLayer("totalAmount", totamount); }...

Hi I have the following script which should generate 3 unique random numbers and store them in the corresponding text boxes when run but it returns an error. <script> function addLuckyDip(lineNumber) { var randomnumber[0] = Math.floor(Math.random() * maxValue) + 1; var randomnumber[1] =...

Hi, I need to create a script that calculates lottery numbers. I have done this but the hard part is when the draw is done. Say I have the following variables: $lastdraw - unix timestamp for the last draw date $day - the day of the draw (ie 1= Monday, 2 = Tuesday...) $hour - the hour of the...

Hi, I know this may sound amatureish (I've tried searching for a solution but have not found anything). Well I went to php.net and found the function is_int to check if a variable is an integer. I have a simple form ie with one of the test boxes: <input type="text" name="v2"> Then on the...

Hi, I've got an text box: <input type="text" name="drawGameBoards[0].numbersChosen[0]" class="text"> If I pass this variable across using a php script then what would it be called. My instincts were that it would be $drawGameBoards[0].numbersChosen[0] but that returns a parse error. I'd be...

Hey does anyone know what the problem is with http://www.flixon.com/lottery.htm I had everything working fine earlier but then I added a validation check to see that the numbers are not the same for each text box on each line. I'd be greatful if you could help because it's been troubling me...

Hi. I'm trying to configure a home network using the windows xp network setup wizard. Both computer are using windows xp and have ran the network setup wizard on both computers but on the server computer it has got to the bit "please wait while the wizard configures this computer..." and has...

Hi, I know this is off on another tangent but I was wondering if anyone knew the answer to the following. It is highly likely that this question will be asked in my exam tomorrow and I can't find the answer to it. I'd be very very very greatful if anyone could help. Thanks What security...

This is my last problem. What's the vba code to have a command buttom open a report but with the filter being the one currently on the form that the command button is on. This code below is what I would normally use but I need to set the variable stLinkCriteria equal to the filter for the form...

When I run the command DoCmd.OpenReport... (in vba) it starts to print the report. Why won't it just open the report normally? I'd be greatful if anyone can help. Cheers

Hi, I have a form called frmHouses which displays the records from the Houses table. One of the fields is called outbuild. This field can take the value -1 or 0. -1 = yes, 0 = "" (blank). This is where I ge stuck because there is another table called Lookups which has 2 columns called...

Hi, I need todo a filter form to filter out specific records. I originally did it with using vba on the on click event inside the filter form but it now seems that I have to open the form using macros. I simply did an onclick event to run the specific macro to open the form. Then this has an...

Hi, sorry to bring this back up but I felt due to the high number of replies the post was getting ignored. Here's my problem. The code below is what I use to filter a form. A quick scan over makes it pretty simple to understand what's going on. When it filters the form it runs the command...

Hi, I'm new to filter forms. I thought I had enough to get me along with Access but then I came across the problem of having to filter a field between a specific range. Here's an example: Say I wish to create a filter form filtering the house price range (minimum house value < price < maximum...

Hi I was wonder what is the correct way of selecting the number of comments from a post and selecting who made the original post (this is for a news script): news_posts structure - id - uid $query = mysql_query("SELECT * FROM news_posts ORDER BY dateline DESC"); while($post =...

Hi, I wasn't sure what area of this website to post it on, but to settle a debate with a client I have been asked to select the 10 most important interface design issues that are relevant today. I would be very greatful for your opinions and references on this issue. Thanx