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 dencom on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by LuckySyringe

  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`...

Part and Inventory Search

Back
Top