[PHP-DB] extra lines

2001-02-01 Thread Michael Gerholdt
Why would this code produce the desired list of records in a table row, and then add an equal amount of blank lines ( = num of records) before producing the next set of records? while ($row = mysql_fetch_array ($result)) { $num = count ($row); for ($c=0; $c<$num; $c++) { echo $row[$c].""; } } T

[PHP-DB] php-mySQL and an SQL query

2001-03-08 Thread Michael Gerholdt
Hi, folks, Can someone insight me regarding this? I have a datetime field in mySQL (-mm-dd hh:mm:ss) called event_time I want to pull records hitting against this field with the idea: where the abbreviated month from this field LIKE '$month' and here's the SQL string I've been playing wit

[PHP-DB] php-mySQL and an SQL query

2001-03-08 Thread Michael Gerholdt
Hi, folks, Can someone insight me regarding this? I have a datetime field in mySQL (-mm-dd hh:mm:ss) called event_time I want to pull records hitting against this field with the idea: where the abbreviated month from this field LIKE '$month' and here's the SQL string I've been playing wit

[PHP-DB] Whence Cometh Line Break?

2001-03-09 Thread Michael Gerholdt
I've discovered that this little bit of code is introducing a line break into my SQL string and it is causing it to break. the month comes through as '[linebreak here]Mar'   (these are two unbroken lines in original code.) Where does a line break come from in value="" ?? I'm mystified! Than

[PHP-DB] if () and () - newbie Q

2001-03-17 Thread Michael Gerholdt
s and something like: if (($rectype == 'events') and ($action == 'add') and ($manage == 'some')) Also - what about something like 'isNull' ? I don't see any documentation in the PHP online manual nor is 'null' even mentioned in the index of m

Re: [PHP-DB] Renaming a Table in a database

2001-03-31 Thread Michael Gerholdt
>From the mySQL manual: G.1 Things that must done in the real near future RENAME table as table, table as table [,...] Regards, Michael Gerholdt > Greetings! > > Can anyone tell me the SQL sintax to rename a Table in a MySql > database