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!

  • Congratulations bkrike 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: *

  1. luckyblackcat

    Repeating regions

    Hi, I have a property db with fields refno, country ,area, town, description, pic1 etc. You get the pic ... course you do ... I want to show 3 properties on a page each in nested html tables for layout reasons. I've used .. $row = mysql_fetch_assoc($result); The only idea I have is to use...
  2. luckyblackcat

    Hi I'm trying to query a MySQL d

    Hi I'm trying to query a MySQL db and dynamically create webpages from the result. Up to say 5 result a page with |<< < > >>| next/prev style navigation or better. I've seen this on lots of sites but I'm a PHP novice with limited MySQL experience, so a ready made script that I can easily...
  3. luckyblackcat

    Search db display results in sets of 5 with next/prev ...

    Hi I need to write an application which searches a MySQL db and dispays the results much like a search engine. I have a number of fields to output in a 3x2 table 1st row ... A ref no, title 2nd Row A thumnail jpg (blob), main description 3rd Row Tel:, e-mail I would like to control the...
  4. luckyblackcat

    Application tutorial Trio-PHP repeated field problem

    Hi, I've been doing the tutorial Trio-php using IIS MySQL PHP All is set up OK I think. Problems start when I add the repeated region. I highlight all the bottom row of the table ... click to add the repeated region and it adds the region arounfd the last 3 cols but not the FIRST NAME col...
  5. luckyblackcat

    Heres an easy one?

    I have a table cart. Using PHP .... I want to DELETE a row where username = $username AND item_no = $item_no I have the code .. $query = &quot;DELETE FROM cart WHERE username = $username AND item_no = $item_no LIMIT 1&quot;; mysql_query($query); It doesn't work, anyone know why??? Thanks...
  6. luckyblackcat

    php/MySQL Shopping Cart query

    Hi, I'm writing a shopping cart using Flash-php-MySQL $username & $itemsincart are passed from Flash to this script. I wish to echo back to Flash the four arrays at the bottom. I am not happy that the 2 SELECT queries are correct/efficient. It doesn't work and I've been messing with it for so...
  7. luckyblackcat

    help needed using mail()

    Hi, I need a script to send an email. I can send ok if I keep it simple .... mail($to, $subject, $message); as soon as I try to add $from or $headers the mail never arrives. I need to have at least .. FROM on the email as it doesn't look good having my host servers _root in that field! I...
  8. luckyblackcat

    How can I find the number of rows in a table d

    Hi, I need to find the total number of rows in a table and then send this number using POST to a Flash movieclip. Thanks for your time.
  9. luckyblackcat

    Help needed with SELECT and CONCAT_WS please

    Hi I have a table with 7 fields I need to SELECT 5 of these fields and output all ROWS into one huge string with fields seperated by .. say '|' Alternatively I need help with fuctions which return the total nuber of rows in a table. And then how I could access the table row at a time SELECT...

Part and Inventory Search

Back
Top