DaniWeb Forum Index > Web Development > PHP

select

Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Mar 2008

Posts: 29

Reputation: stalk is an unknown quantity at this point

Solved Threads: 0

stalk

Offline

Light Poster

Re: select

#11

Mar 10th, 2008

SELECT kuzy FROM ciste_media WHERE medium='CD' AND typ='R' AND kusy= AND obal='rolka' AND znacka like '%vyraz%' ORDER BY kusy ASC

•

Join Date: Mar 2008

Posts: 38

Reputation: LeBurt is an unknown quantity at this point

Solved Threads: 1

LeBurt

Offline

Light Poster

Re: select

#12

Mar 10th, 2008

Oops, $kuzy should be $kusy, my mistake.

Also, %vyraz% should be %$vyraz%, my mistake again... I apologize, I don't know these words...

Last edited by LeBurt; Mar 10th, 2008 at 7:03 pm.

•

Join Date: Mar 2008

Posts: 38

Reputation: LeBurt is an unknown quantity at this point

Solved Threads: 1

LeBurt

Offline

Light Poster

Re: select

#13

Mar 10th, 2008

So...

$query = "SELECT kusy FROM ciste_media WHERE medium='$medium' AND typ='$typ' AND kusy=$kusy AND obal='$obal' AND znacka like '%$vyraz%' ORDER BY kusy ASC";
die ($query);

•

Join Date: Mar 2008

Posts: 29

Reputation: stalk is an unknown quantity at this point

Solved Threads: 0

stalk

Offline

Light Poster

Re: select

#14

Mar 10th, 2008

oh thank you wery much. Its good just now.

•

Join Date: Mar 2008

Posts: 38

Reputation: LeBurt is an unknown quantity at this point

Solved Threads: 1

LeBurt

Offline

Light Poster

Re: select

#15

Mar 10th, 2008

You're welcome!

•

Join Date: Mar 2008

Posts: 70

Reputation: forzadraco is an unknown quantity at this point

Solved Threads: 1

forzadraco forzadraco is offline

Offline

Junior Poster in Training

Re: select

#16

Mar 10th, 2008

$query = "SELECT kuzy FROM ciste_media WHERE medium='$medium' AND typ='$typ' AND kusy='$kuzy' AND obal='$obal' AND znacka like '%$vyraz%' ORDER BY kusy ASC";