Re: [PHP-DB] Storing Images #2

-- I have my photos in /public_html/img/gid directory and with this path: img src='http://www.mydomain.com/img/{$gid}/{$photoFileName}' in getImage.php the server displays the photos. Now if I put my photos outside of the

[PHP-DB] Storing Images #2

On 3 February 2010 16:07, wrote: I currently have all my images referenced by url in my database and stored in a folder/s and I think I will keep it that way... .. If you put the images OUTSIDE of the webroot/docroot/public_html

[PHP-DB] LIMITiT

Hi all, The following code is created by Dreamweaver 8 , it shows 18 records per page. I want to limit the total number of records to 54 that means it should show only the first 3 pages, but as it is not a simple query I can not use LIMIT , it is already used in sprintf. Could

[PHP-DB] character set collation

Hi everybody, 1- I have created a database in the remote server and I have the same database in my local machine ,which is configured as IIS server. 2- MySQL server in my computer is configured as follows: Default-character-set=latin1 for CLIENT SECTION

[PHP-DB] Re: record pointer

If I understand that correctly, you only need to add the extra condition to the WHERE clause of the main query. So: SELECT id, name, cat FROM table WHERE cat = (SELECT cat FROM table WHERE id = $ID) AND id = $ID; This should display all rows, before and including the row with the same

[PHP-DB] Re: record pointer

Chris [EMAIL PROTECTED] wrote: Huh? You want before, after and including? So everything? Maybe give us an example of what you want to get out of the query rather than us guessing. I keep the path to my photos in this DB so it is a photo Gallery , when I click on a thumbnail I want to see

[PHP-DB] record pointer

Hi all, My DB has the following columns: id, name ,cat. I want to select a cat i.e. cat=zzz when the query is finished I should see a specific record within this cat which is defined by id, like id=yyy Any idea how to do this? Is there a function or something like record pointer

[PHP-DB] Re: record pointer

I am selecting by id Dan Shirah [EMAIL PROTECTED] wrote: Date: Thu, 5 Jul 2007 15:51:56 -0400 From: Dan Shirah [EMAIL PROTECTED] To: elk dolk [EMAIL PROTECTED] CC: php-db@lists.php.net Subject: Re: [PHP-DB] Re: record pointer Okay, in your first post you said you were selecting by category, now

[PHP-DB] Re: record pointer

Thank you Niel I am very close now have a look : mysql select id,cat from table where cat=(select cat from table where id=49); +-+--+ | id | cat | +-+--+ | 40 | FLK | | 41 | FLK | | 42 | FLK | | 44 | FLK | | 45 | FLK | | 46 | FLK |

[PHP-DB] MySQL Error 1366

Hi All, I want to load data from dump file to MySQL table using LOAD DATA INFILE but there is Error 1366 : mysql LOAD DATA - INFILE 'D:/SITE/SOMETABLE.SQL' - INTO TABLE SOMETABLE - FIELDS TERMINATED BY ',' - OPTIONALLY ENCLOSED BY '' - LINES TERMINATED BY ')'; ERROR 1366

[PHP-DB] Data Upload

Hi all, I am in the process of designing a web site with PHP_MySQL . Every week some data would be added to the database . The procedure of updating the database and uploading data is not clear for me 1 – Can I update MySQL table offline and then copy it to the server via fpt? 2 –

[PHP-DB] 20K photos

Hi all, Imagine that you want to put some 2 historical photos On display in your website , you use PHP and MySQL. Preparing a photo album with 200 photos is no problem but for 2 photos! would you do it in the same way? Please comment.

[PHP-DB] IE6 PHP

Hi all, I have a bunch of thumbnail images that link to larger versions of the images and want to line them up in rows across the screen , using CSS I put them into a separate DIV. To get them to line up horizontally across the window I use CSS to FLOAT each DIV to the left, CSS looks like

[PHP-DB] widthheight already solved!

thank you all this code solved it: ?php echo img src='/album/img/{$photoFileName[2]}' width='60' height='70' border='0' / ;? - Expecting? Get great news right away with email Auto-Check. Try the Yahoo! Mail Beta.

[PHP-DB] table

I think I should be something like this: table width=50% border=0 cellspacing=7 cellpadding=0 tr td?php echo img src='/album/img/.$photoFileName[2].'/ ; ?/td td?php echo img src='/album/img/.$photoFileName[3].'/ ; ?/td /tr tr tdnbsp;/td td?php echo img

[PHP-DB] tables

I think it should be something like this: table width=50% border=0 cellspacing=3 cellpadding=0 tr td?php echo img src='/album/img/.$photoFileName[2].'/ ; ?/td td?php echo img src='/album/img/.$photoFileName[3].'/ ; ?/td /tr tr tdnbsp;/td td?php echo img

[PHP-DB] tables

Olavi Ivask wrote: how many pictures do you have in database? dont u want to use for/while ? this is my index.php and I don't want to use for/while because I'll have only 6 photos to show in it, which will be chosen randomly from the Database! - Finding

[PHP-DB] width height

it might be a stupid question but I think it would be the last one! I am trying to define the height and width of picture in the following line: img src='/album/img/.$photoFileName[2]. / ; ?/td when I put it like this: table width=50% border=0 cellspacing=3 cellpadding=0 tr td width=90

[PHP-DB] widthheight

thank you bastien, those wrappers are confusing for me, could you tell me where can I find more info. about them and based on your suggestion re-write this line for me? td width=90 height=70?php echo img src='/album/img/.$photoFileName[2]. width=90 height=70 border='0' / ?/td bastien

[PHP-DB] widthheight(solved)

thank you all this code solved it: ?php echo img src='/album/img/{$photoFileName[2]}' width='60' height='70' border='0' / ;? - Food fight? Enjoy some healthy debate in the Yahoo! Answers Food Drink QA.

[PHP-DB] echo

thanks to Chris and Dimiter, I think I am close but still the problem is not solved, when I add echo img src='/album/img/.$row[photoFileName].' / to the code as it was sugested by Dimiter there is parse Error : PHP Parse error: syntax error, unexpected $end in

[PHP-DB] echo

thank you all, it did it! [EMAIL PROTECTED] You need a trailing you have echo img src='/album/img/.$row[photoFileName].' / it needs to be echo img src='/album/img/.$row[photoFileName].' /; - Bored stiff? Loosen up... Download and play hundreds of games

[PHP-DB] array

Hi all, I want to put result of query in a two dimensional array like this: title[0]=x description [0]=y title[1]=z description [1]=w . any idea would be appreciated $query = SELECT * FROM photo; $result=mysql_query($query); while ($row =

[PHP-DB] tables

Hi list, How can you show some pictures in separate tables in one page with echo? - Don't pick lemons. See all the new 2007 cars at Yahoo! Autos.

[PHP-DB] echo

Hi all, I am new to web programming. I have code to add pictures to a MYSQL database. Now I can't seem to figure out how to get them back out ! so we can see them. The MySQL doesn't seem to be a problem (yet), also I'm trying to learn PHP. What I usually do is to load the images in a

[PHP-DB] echo

I am storing just the name of photos in the database and the photos are in /img folder , and there is no permissions issue. My testing server is IIS And the path would be something like this : Inetpub\wwwroot\album\img as I am running out of time! could someone complete this code just with