found the answer!
the problem was with a norton pop up blocker. Using a grisoft AV instead and code works fine now.
Diz
Last Activity: Dec 17 '06, 08:59 PM
Joined: Feb 21 '06
Location: Liverpool UK
-
-
php sript wont run properly when inside a tbale cell
Hi,
Can anybody tell me why my php script wont run properly unless i put it in a page all on its own? Is it antisocial? Does it want to be alone? I have put it in a page with background and links to other pages, but it wont generate a large version of a thumbnail unless it has a page all to itself. here is the php coding i've used:
<td colspan="2" rowspan="3" width="760" >
<?php
... -
i fixed this problem by saving the www and database table files files from the server to another location, then uninstalling and reinstalling the server, then putting the files back. Had to do all of the queries again tho..... :rolleyes:Leave a comment:
-
displaying images from a database
ok..so I can get all of the other information from my database, but when i try to get images, it displays as a code i dont recognise. here is the query:
<?php
// Connecting, selecting database
$link = mysql_connect(' localhost', 'username', 'password')
or die('Could not connect: ' . mysql_error());
echo 'Connected successfully';
mysql_select_db ('webimages') or die('Could not select database');
... -
thanks Banfa. I will those changes to the code. but i think i have to use php as what I'm working on is a website, mostly html, but a backend database to store the images in. i've created a few queries using phpmyadmin and mysql, and I've run a similar query directly on the database, but thought i would try and use the example code as i've just linked to the database but haven't managed to pull a query through yet!Leave a comment:
-
grabbing table data with php
Hi,
I modified the code on the following page:
http://www.thescripts.com/serverside...ses/index.html
this is my code:
<?
/* declare some relevant variables */
$DBhost = "localhost" ;
$DBuser = "myusername ";
$DBpass = "password";
$DBName = "webimages" ;
$table = "artwork";... -
that could be it, i'm using mysql in phpmyadmin, and i've added all of the other fields automatically, but had to type in 'type' myself. I'll have a good look at the keyboard and see if i can find a match for the other character. Thanks.Leave a comment:
-
locked myself out of my database
I've locked myself out of my database. I was trying to connect to mysql and decided to create a new user with full privs, then remove privileges from root, as i know the db server shouldn't be running at root ( a tutor set it up for me). the server is still runnning as root and i cant fix it! :( I'm using phpmyadmin on a uniserver. Please can anyone help me get back in? i can open the phpmyadmin page but cant do anything as it says 'no privileges'... -
query problem
Can anyone please help with this?
when i run the following query, using SELECT*,
SELECT *
FROM tbl_artwork, tbl_artworkmedi um, tbl_medium
WHERE tbl_artwork.art workID = tbl_artworkmedi um.artworkID
AND tbl_artworkmedi um.mediumID = tbl_medium.medi umID
AND `dateCreated` =2002
I get more info than i need, (lots of IDs displaying) and type displays oil or watercolour etc. but when i try... -
YEAH ANNO! ha ha :DLeave a comment:
-
Hi Banfa,
about 7 pages of html. The instructions to run tidy were too complicated, and i also had problems using the zip file to open it! html would just need closing tags i think, and the headings changed too. Looks like i better get busy then! Thanks,
DizLeave a comment:
-
Converting html to xhtml
Hi,
Can anyone recommend a program which will convert html to xhtml? I've tried TIDY but couldn't get it to work. Any other suggestions please? :confused:
thanks,
Diz -
artworkmedium table is there solely to join the other two tables together. this is because each piece of artwork can be made up of more than one medium- eg pastels and oil on board. so i need to select three option from the medium table. Each piece of artwork is individually priced, so all works on canvas may be more expensive than works on paper, but the price will vary from painting to painting, hence the cost is in the artwork table...thanks so...Leave a comment:
-
thanks for replying so quickly. i used INT unsigned zerofill for PKs. (in all tables), but have named them exactly the same in each column. as following:
artwork
Field Type Null Default Links to Comments MIME
artworkID int(10) No
title varchar(25) No
dateCreated year(4) No 0000
category enum('Abstract' , 'Figurative', 'Landscape') No Abstract
cost...Leave a comment:
-
blob
:p ok, i realise my questions are probably very basic, but give us a break, i'm just starting out!
I will go with your suggestion to link to the images....would that be a varchar field? maybe called link???
i'm also having trouble trying to link my tables together. i am using phpmyadmin and mysql. There isn't an option when creating the tables to specify a foreign key. Any idea how to do it?
thanks...Leave a comment:
-
Blobs
Can anyone please tell me how to decide which blob field to use?
I'm creating a DB using phpmyadmin and mysql. choices are
Tinyblob - maximum length of 255 characters.
Blob- maximum length of 65535 characters.
Mediumblob - maximum length of 16777215 characters.
Longblob - maximum length of 4294967295 characters.
How do i tell how many characters are in the images i want to use? does it depend on the... -
thanks. I will try that.Leave a comment:
-
mysql tables
I'm using phpmyadmin(for the first time) to create a db, why doesn't it like my table? please help
SQL-query:
CREATE TABLE `artwork` (
`artworkID` INT( 10 ) UNSIGNED ZEROFILL NOT NULL AUTO_INCREMENT ,
`title` VARCHAR( 25 ) UNSIGNED NOT NULL ,
`category` VARCHAR( 25 ) UNSIGNED NOT NULL ,
`dateCreated` YEAR( 4 ) UNSIGNED ZEROFILL NOT NULL ,
`forSale` VARCHAR( 5 ) UNSIGNED NOT... -
on the same subject..why doesn't it like this table? I'm very new to this and have been seaching all day for field the definitions, not sure if i have used the right ones?
SQL-query:
CREATE TABLE `artwork` (
`artworkID` INT( 10 ) UNSIGNED ZEROFILL NOT NULL AUTO_INCREMENT ,
`title` VARCHAR( 25 ) UNSIGNED NOT NULL ,
`category` VARCHAR( 25 ) UNSIGNED NOT NULL ,
`dateCreated` YEAR( 4...Leave a comment:
No activity results to display
Leave a comment: