[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 f

[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 one

[PHP-DB] echo

thanks to Chris and Dimiter, I think I am close but still the problem is not solved, when I add echo " to the code as it was sugested by Dimiter there is parse Error : PHP Parse error: syntax error, unexpected $end in C:\Inetpub\wwwroot\album\show.php on line 44 line 44 is end of the code jus

[PHP-DB] echo

thank you all, it did it! >[EMAIL PROTECTED] >You need a trailing " >you have echo " >it needs to be >echo ""; - Bored stiff? Loosen up... Download and play hundreds of games for free on Yahoo! 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 = mysql_fetch_array($re

[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] table

I think I should be something like this: "; ?> "; ?>   "; ?> - Looking for earth-friendly autos? Browse Top Cars by "Green Rating" at Yahoo! Autos' Green Center.

[PHP-DB] tables

I think it should be something like this: "; ?> "; ?>   "; ?> - TV dinner still cooling? Check out "Tonight's Picks" on Yahoo! TV.

[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: ""; ?>       I have this error: PHP Parse error: syntax error, unexpected T_LNUMBER, expecting ',' or ';' in C:\Inetpub\wwwroo

php-db@lists.php.net

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? "?> >bastien wrote: >you need to escape double quotes in an echo if you use double quotes as the wrapper. ---

php-db@lists.php.net

thank you all this code solved it: ";?> - Food fight? Enjoy some healthy debate in the Yahoo! Answers Food & Drink Q&A.

[PHP-DB] width&height already solved!

thank you all this code solved it: ";?> - Expecting? Get great news right away with email Auto-Check. Try the Yahoo! Mail Beta.

[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 this

[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] 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 – Wha

[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 136

[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 i

[PHP-DB] Re: record pointer

O.K. the id column is primary key and it is auto_incerment .I think my explanation was not clear enough : this is my query : SELECT * FROM table WHERE ID=$ID this will find the record with the specified ID and I will be able to see it, now I want to be able to scroll up and down to all the

[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 fir

[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] 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 'c

[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 t

php-db@lists.php.net

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 De

[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 someon

[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

Re: [PHP-DB] Storing Images #2

> -- > > I have my photos in /public_html/img/gid directory and > with this path: > > getImage.php the server displays the photos. > > > > Now if I put my photos outside of the public_html like > this: > > /hidden_images/img/gid > > > > wh