On 28 August 2003 17:25, mike karthauser wrote:
> on 28/8/03 5:00 pm, CPT John W. Holmes at
> [EMAIL PROTECTED] wrote:
>
> > > Thanks for this - I ended up rehashing my query to this:
> > >
> > > > > $result = mysql_query("SELECT * FROM dates WHERE bookcode =
> > > '$bookcode' ORDER BY date1",$
on 28/8/03 5:00 pm, CPT John W. Holmes at [EMAIL PROTECTED] wrote:
>> Thanks for this - I ended up rehashing my query to this:
>>
>> > $result = mysql_query("SELECT * FROM dates WHERE bookcode = '$bookcode'
>> ORDER BY date1",$db);
>>
>>
>> // loop to populate array
>>
>> $myrow = mysql_fetch_
From: "mike karthauser" <[EMAIL PROTECTED]>
> Thanks for this - I ended up rehashing my query to this:
>
> $result = mysql_query("SELECT * FROM dates WHERE bookcode = '$bookcode'
> ORDER BY date1",$db);
>
>
> // loop to populate array
>
> $myrow = mysql_fetch_array($result);
>
> $i = 1;
> while (
on 28/8/03 1:09 pm, [EMAIL PROTECTED] at [EMAIL PROTECTED]
wrote:
>
> I'd worry about the empty dates after. and use something like.
>
> $qry = "select date1, date2 from table";
> $result = mysql_query($qry) or die(mysql_error());
> while ($rs = mysql_fetch_row($result)) {
> //this array could b
From: "mike karthauser" <[EMAIL PROTECTED]>
> I have a course booking system that allows the client to add courses and
> then specify how long they run for. The admin system I have built allows
the
> client to add up to 30 dates for each instance of the course and these are
> adding to a database
m.co.uk> cc:
Subject: [PHP-DB] Populating an array
from mysql db
I have a course booking system that allows the client to add courses and
then specify how long they run for. The admin system I have built allows the
client to add up to 30 dates for each instance of the course and these are
adding to a database row in the form date1, date2, date3, daten etc.
What
