Re: mysql result display with php

On Mon, 15 Oct 2001 13:19, sc wrote: > This is the line that we have selecting what we want: > > $test = mysql_db_query("Syd-01", "SELECT * FROM Port1 WHERE date > > 2001-10-04 AND date < 2001-10-11"); > > And we are having trouble displaying that data in php with rows & > columns etc. > > basically its just showing the result from the mysql query above... > > thx for your help. > > -sc > > In article <01101513062300.08842@www>, "David Robley" > > <huntsman@www.nisu.flinders.edu.au> wrote: > > On Mon, 15 Oct 2001 13:03, sc wrote: > >> Hey guys, > >> > >> I have a script that searches between dates but i cant get the > >> specific data in the rows etc. to display at all... > >> > >> Can anyone help me with displaying this data? > >> > >> Thx. > >> > >> -sc > > > > It would help if you could describe your problem a litle more > > specifically - or even a snippet of code that causes the problem. > > > > Ah, I see my sigmonster is selecting relevant quotes. But what code are you using to display the results? Have you looked at the mysql section of the manual, especially mysql_fetch_array which has an example of how to loop through a result set? -- David Robley Techno-JoaT, Web Maintainer, Mail List Admin, etc CENTRE FOR INJURY STUDIES Flinders University, SOUTH AUSTRALIA Useless Invention: Tire chains for motorcycles.