Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: rahulpatel
  • Order by date
  1. rahulpatel

    Better coding...?

    ...= "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\stock.mdb" cn5.Open Set rs5 = New ADODB.Recordset sSQL5 = "SELECT * FROM Stores WHERE barcodeout = '" & (txtSearch.Text) & "'" rs5.Open sSQL5, cn5, adOpenKeyset, adLockOptimistic, adCmdText txtItemNo.Text =...
  2. rahulpatel

    Adding 2 fields with SQL

    Thanks JoeAtWork, I checked my fields and barcodein was indeed an integer. Changed it to text and the SQL works like a charm. How did you know from the code I posted that the 'barcodein' field had to be text as opposed to an int?
  3. rahulpatel

    Adding 2 fields with SQL

    I'm trying to add 2 fields from a database using SQL. They are both numbers and once added together and stored in another field, the result will be displayed in a text box. However, I have tried every permutation of fields and adding I can think of (apart from the correct one obviously) and I...
  4. rahulpatel

    Which Frontend?

    Thanks for that. Basically everyone would use the same db and inventory and it would only be available on one PC. I was thinking of a web based front end but that would mean having some sort of server and I don't think that would be a go. There might be a spare PC lying around that could be used...
  5. rahulpatel

    Which Frontend?

    I'm trying to build an app for work. It's going to use access as the db as it's the easiest for me. I need to have a simple front end. So here's my dilemma. I am not, and no-one in work is, an administrator and so unable to install apps onto work PCs. I want to be able to copy and paste the app...
  6. rahulpatel

    php, xml and gallery (dynamic).

    tsuji, Too easy wasn't it. I've been staring at this problem for the best part of this evening. I managed to get where I got to, and then hit the wall. It sometimes takes a fresh pair of eyes. That is exactly what I wanted. However, I've spent another hour still trying to get it to work. This...
  7. rahulpatel

    php, xml and gallery (dynamic).

    Not sure if this is a PHP question or a XML question, so I'll ask it here first. I have a database in mysql and I am making a gallery from it. I found a 'flash' gallery that works from a xml file. I don't want to keep amending my files as and when I add an image, so I'm trying to make it...
  8. rahulpatel

    php gallery with lightbox 2.0

    Thanks for replying. I think everyone else hasn't stopped laughing at such an easy answer. Anyway, as with most times I post on here I eventually figure it. I changed this: <a href="<?php echo $_SERVER['PHP_SELF']; ?> to: <a href="../images/<?php echo $row['filename']; ?>" and it works like I...
  9. rahulpatel

    php gallery with lightbox 2.0

    I hope some of you out there can shed some light on a problem for me. Hopefully this won't be as stupidly easy as my last 'problem'. So, I have a dynamically created gallery and I decided to incorporate lightbox 2.0 into it. This is the section that creates the gallery. <td><a href="<?php echo...
  10. rahulpatel

    Display last article on page

    I've been following a tutorial and adapting it to my own needs. I want to display the last article I entered but knowing the code is a bit confusing. Here's what I have at the moment. // connect to the database $conn = dbConnect('admin'); // check for article_id in query string if...
  11. rahulpatel

    implementing captcha?

    ...$userId = $_POST['txtUserId']; // check if the user id and password combination exist in database $sql = "SELECT * FROM member WHERE member = '$userId' "; $result = mysql_query($sql) or die('Query failed. ' . mysql_error()); if (mysql_num_rows($result) == 1) {...
  12. rahulpatel

    implementing captcha?

    Mmmmmm, that red line of code is returning this error Fatal error: Can't use function return value in write context
  13. rahulpatel

    implementing captcha?

    Thanks for that. I added my captcha generation page to my form: <div id="search"> <form> <p> <input type="text" id="txtCustomerId" value="" /> <input type="text" name="captcha" id="captcha"><img src="randomImage.php"> <input type="button" value="Search"...
  14. rahulpatel

    implementing captcha?

    ...information"; $sDBServer = "localhost"; $sDBName = "XXXX"; $sDBUsername = "######"; $sDBPassword = "######"; $sQuery = "select * from number where number = ".$sID; $oLink = mysql_connect($sDBServer,$sDBUsername,$sDBPassword); @mysql_select_db($sDBName) or $sInfo="Unable...
  15. rahulpatel

    New to PHP - Installation questions

    I'll add my experience. I downloaded all the bits and pieces to run php (php, apache and mysql) and gave up when I couldn't get them all to run. I since discovered easyphp and it runs like a dream. So, if like me, you don't want wasted time and headaches look at easyphp.
  16. rahulpatel

    One form, two insert buttons.

    <?php if (isset($_POST['submit'])){ if ($_POST['submit'] === "save & continue"){ savedata(); header('Location:members.php'); } else { savedata(); //redisplay the current page header('Location:untitled.php'); } } function savedata(){ // set your infomation...
  17. rahulpatel

    One form, two insert buttons.

    Thanks both. I'll try the examples tomorrow as it's far too late here and let you know how I get on.
  18. rahulpatel

    One form, two insert buttons.

    I have a form on my page which has a button. The button inserts values from textboxes into the db. Easy peasy. I would like to have 2 buttons. One that inserts the values and simply returns to the same page so the user can add more values. The second button adds the values and moves to the next...
  19. rahulpatel

    if/else after search.

    had a bit of a play and got it working. if($sInfo == '') { if($oResult = mysql_query($sQuery) and ysql_num_rows($oResult) > 0) { $aValues = ysql_fetch_array($oResult,MYSQL_ASSOC); $sInfo = "Member registered"; } else { $sInfo = "Member not registered."; }...
  20. rahulpatel

    if/else after search.

    I have a club site that has a membership system. I would like guests to search for usernames to see if they are registered.(Only to say username is registered or not, no other details) It uses ajax (hence why this post is in this thread) to say whether or not username is regsitered. It all...

Part and Inventory Search

Back
Top