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