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!

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

    ...(mysql_error()); while ($row = mysql_fetch_row($result)) { $tableName = $row[0]; print "Table Name: ".$tableName."\n"; $query_2 = "SELECT * FROM ".$tableName." ORDER BY `name`"; $result_2 = mysql_query($query_2) or die (mysql_error()); $query_3 = "SELECT name, COUNT(*) AS...
  8. LuckySyringe

    counting number of same strings in array

    ...(mysql_error()); while ($row = mysql_fetch_row($result)) { $tableName = $row[0]; print "Table Name: ".$tableName."\n"; $query_2 = "SELECT * FROM ".$tableName." ORDER BY `name`"; $result_2 = mysql_query($query_2) or die (mysql_error()); $query_3 = "SELECT name FROM ".$tableName...
  9. LuckySyringe

    breaking SQL results into pages

    ...($mysql_host, $mysql_user, $mysql_pass); mysql_select_db ($mysql_db); //find out how many records are in the table $count_query = "SELECT count(*) from ".$mysql_table; $rh = mysql_query($count_query); list ($record_count) = mysql_fetch_array($rh); //calculate the maximum "page" that can be...
  10. LuckySyringe

    splitting search results into pages

    ...($mysql_host, $mysql_user, $mysql_pass); mysql_select_db ($mysql_db); //find out how many records are in the table $count_query = "SELECT count(*) from ".$mysql_table; $rh = mysql_query($count_query); list ($record_count) = mysql_fetch_array($rh); //calculate the maximum "page" that can be...
  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

    ...$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` DESC LIMIT 6"; $result_2 = mysql_query($query_2) or die (mysql_error()); while ($row_2 =...
  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

    ...$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` DESC LIMIT 6"; $result_2 = mysql_query($query_2) or die (mysql_error()); while ($row_2 =...
  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

    ...$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`"; $result_2 = mysql_query($query_2) or die (mysql_error()); while ($row_2 = mysql_fetch_assoc($result_2)) {...
  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

    ...$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`"; $result_2 = mysql_query($query_2) or die (mysql_error()); while ($row_2 = mysql_fetch_assoc($result_2)) { echo...

Part and Inventory Search

Back
Top