php limitations

[tsiwu]

Hey guys thank you for the help you have been giving me it is much appreciated! Now can someone help with some code, im developing a website using php and mysql and id like to know how do you limit the amount of data that the php script takes from the database? And another problem i have is that it repeates the data that is contained in the table! How do i stop that? Im really a novice when it comes to this!:(

[enigma1]

If by limit data you mean rows, then use the "limit xx" at the end of the query where xx is the number of rows to retrieve. For the distinct rows you could use "select distinct column-name...." or "...group by column-name....". Best thing to do is to read the mysql online documentation.

[dreamcatcher]

If you have database specific questions, you may want to try posting in the database forum:

[webmasterworld.com...]

dc