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...
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
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...
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...
...(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...
...($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...
...($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...
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...
...$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 =...
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
...$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 =...
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
...$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)) {...
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...
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...
...$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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.