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 Chriss Miller 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

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

    Hi, I did the DW tutorial as it seemed similar to the website I need to do. I am in a hurry as I am moving house/country and will have to use a mobile phone to connect until a landline is connected and ISP sorted. OK? luckyblackcat
  3. luckyblackcat

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

    Hi, I've tried the Trio motors PHP tutorial. I have MySQL PHP IIS set up and tested as working as the tutorial says but when I get to add the repeated region and test live data I get errors. The repeated are misses the 1st coin the row and I get errors on the page. I have given up on the...
  4. luckyblackcat

    Hi I'm trying to query a MySQL d

    Hi I need to work out (visualise) what is happening with the query so that I can make use of this feature, I am using Dreamweaver and another post in another forum said I could get Dreamweaver to do this without coding. It's been a while since I used MySQL and I have forgoten more than I...
  5. luckyblackcat

    Hi I'm trying to query a MySQL d

    Wow Well slap my face with a wet kipper. This is a good and useful reply ... not quite sure about the link back to the script <a href=&quot;/yourscript.php?page=2&quot;>Next 10</a> I didn't realise it did this? I need to think this through as I am still not sure how to implement this. Thanks...
  6. 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...
  7. luckyblackcat

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

    Thanks, I guess it does ... cheers for the help luckyblackcat
  8. 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...
  9. luckyblackcat

    Application tutorial Trio-PHP repeated field problem

    Hi I'm selecting the <tr> tag, the row is selected but when I add the repeat region it misses the first col in the row. Thanks for replying lbc
  10. luckyblackcat

    Application tutorial Trio-PHP repeated field problem

    Hi Lebisol Thanks for your reply. In my post I said .. &quot;I highlight all the bottom row of the table ... click to add the repeated region &quot; The problem is that the row I wish to repeat has 4 cols and only 3 are being shown as a repeating region although the whole row is selected...
  11. 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...
  12. 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...
  13. luckyblackcat

    How many fields in table MYSQL

    Thanks for your help. It works fine now $i=1; while($row=mysql_fetch_array($result)){ echo &quot;&title[&quot;.$i.&quot;]=&quot;.$row[0]; echo &quot;&price[&quot;.$i.&quot;]=&quot;.$row[2]; echo &quot;&item_no[&quot;.$i.&quot;]=&quot;.$row[4]; echo...
  14. 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...
  15. 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...
  16. luckyblackcat

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

    Thanks so much, my script now works!!! your help is much appreciated esp on a Sunday!! Cheers lbc (Ramsgate)
  17. luckyblackcat

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

    Hi Thanks for your help much appreciated. Your suggestion works on phpMyAdmin. But in a php script I get &quot;Resource id #2&quot; returned instead of the number ... any ideas why? Thanks luckyblackcat
  18. 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.
  19. 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