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 Mike Lewis 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. LuckySyringe

    Handling MySQL data

    This is really wierd, it prints out exactly that SELECT content, mime_type FROM new_table WHERE id=1 ...and when I change the code around to: echo stripslashes($data['mime_type'])."\n\n"; echo stripslashes($data['content']); ...i get: application/x-shockwave-flash CWS?È... (a lot of...
  2. LuckySyringe

    update blob with a url

    Ok, I will look through the functions in the PHP/MySQL APIs -> LuckySyringe
  3. LuckySyringe

    Handling MySQL data

    Yes, I get exactly what I asked for: (in phpMyAdmin) SQL query: SELECT content, mime_type FROM new_table WHERE id =1 I get: content mime_type [BLOB - 227.9 KB] application/x-shockwave-flash -> LuckySyringe
  4. LuckySyringe

    update blob with a url

    I'm using PHP to run a loop of MySQL queries that should update the blobs with small image files, but it doesn't work. I am thinking its because I am running the queries remotely, because the MySQL documentation seems to only upload the files locally, is there any difference? $fileURL is in the...
  5. LuckySyringe

    Handling MySQL data

    yes, display_errors is on -> LuckySyringe
  6. LuckySyringe

    Handling MySQL data

    This script I had displayed a flash file, but now it needs to be able to accept other MIME types as well -- I made a few changes, but it just returns blank... <?php error_reporting(E_ALL); require 'config.php'; $id = $_GET['id']; $dbTable = $_GET['tb']; dbConnect(); $query = "SELECT content...
  7. LuckySyringe

    counting number of same strings in array

    I edited the code, but now it returns: Table Name: 2003 --Count from 2003: Resource id #5 Table Name: 2004 --Count from 2004: Resource id #7 Table Name: 2005 --Count from 2005: Resource id #9 Table Name: 2006 --Count from 2006: Resource id #11 Total Count: 32 ...when before it returned: Table...
  8. LuckySyringe

    counting number of same strings in array

    I'm trying to count how many times the same name shows up in a database with different tables for different times (the tables are still formatted the same way). IE: Array ( [0] => John Doe [1] => Jane Doe [2] => John Doe [3] => Bob Smith [4] => Bob Smith [5] => Jane Doe...
  9. LuckySyringe

    breaking SQL results into pages

    repost from splitting search results into pages. I just recently stumbled upon this script and decided to implement it into my site. However, it shows the first ten results on the first page (without &page=1 in the url) and when you click next, it skips 10 items and lists from 21-30 and from...
  10. LuckySyringe

    splitting search results into pages

    I just recently stumbled upon this script and decided to implement it into my site. However, it shows the first ten results on the first page (without &page=1 in the url) and when you click next, it skips 10 items and lists from 21-30 and from there on works perfectly. //db settings...
  11. LuckySyringe

    weird IE bug

    After a little modification of the rounded corners example at http://www.webreference.com/programming/css_borders/index.html I ran into a problem, I wanted an image floated to the left of the content - which is going to vary in length. The background fitted to the content and not the floated...
  12. LuckySyringe

    PHP with MySQL return query

    Thank you again. It works perfectly. -> LuckySyringe
  13. LuckySyringe

    PHP with MySQL return query

    Thanks for clarifying - I'm kinda self-taught (as you may have already noticed), but theres still one problem... My error log reads: 13 times (per page load), and line 16 reads: $array["added_".uniqid()]= $row[2]; from $query = "SHOW TABLES FROM $dbDatabase"; $result = mysql_query($query) or...
  14. LuckySyringe

    Send referer with header

    You could have a link on the first page that sends the user to somewhere.yourdomain.com (where somewhere is the subdomain that counts), and in the somewhere.yourdomain.com page use $_GET or $_POST to get the affiliate's name, and use header("Location: ..."); as needed. -> LuckySyringe
  15. LuckySyringe

    PHP with MySQL return query

    alright, so far from what you gave me, I have this: // database connect $query = "SHOW TABLES FROM ".$dbDatabase; $result = mysql_query($query) or die (mysql_error()); while ($row = mysql_fetch_row($result)) { $tableName = $row[0]; $query_2 = "SELECT * FROM $tableName ORDER BY `added`...
  16. LuckySyringe

    Browser behaviour, why?

    the reason it looks like that is because you have all the divs positioned, change the numbers around and it'll go wherever you want it to. -> LuckySyringe
  17. LuckySyringe

    PHP with MySQL return query

    I tried your code, but it only returns one line and when I check my error log, I have 13 lines of where the numbers in blue are different by each line. And last night I tried adding the rows to an array and this is how far I got...$cItem = 0; $query = "SHOW TABLES FROM ".$dbDatabase; $result...
  18. LuckySyringe

    HTML - using ......... to fill an empty area

    I've got an option, but its a pain to update... You put the description and price in two table cells on one row, sperated by a blank cell with the repeated period image. Then you put that into a table that is inside another table, with the product name in a seperate row above it. ie: <table...
  19. LuckySyringe

    PHP treeview, file folder browser selector

    I got this script from the readdir() function documentation, it was user contributed... <?php // show directory content function showDir($dir, $i, $maxDepth){ $i++; if($checkDir = opendir($dir)){ $cDir = 0; $cFile = 0; // check all files in $dir, add to array listDir...
  20. LuckySyringe

    PHP with MySQL return query

    I ran into a problem... I'm trying to print out the last six of the most recent additions of all tables, but with that code (slightly modified) I get the last 6 from each table. I apologize if I did not made it clear in the beginning. <?php include 'include/dbconnect.php'; dbconnect(); $query =...

Part and Inventory Search

Back
Top