Re: [PHP-DB] php-notepad
Visit http://php.weblogs.com/editors for a list of editors. "Sharmad Naik" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Please tell me an editor for Linux -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] php-notepad
Quanta Plus http://quanta.soundforge.net Web Developement Enviroment My choice. On Saturday 19 May 2001 03:55, John Lim wrote: > Visit http://php.weblogs.com/editors for a list of editors. > > "Sharmad Naik" <[EMAIL PROTECTED]> wrote in message > [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > > > Please tell me an editor for Linux -- Paul Campbell http://www.cmm.uklinux.net/ mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] connecting sybase ASE 11.9.2 via ct-lib
I get Fatal error: Call to undefined function: sybase_connect() in c:\programmi\apache\apache\htdocs\hello_dati_syb.php this my php.ini ;extension=php_oracle.dll ;extension=php_pdf.dll ;extension=php_pgsql.dll ;extension=php_printer.dll ;extension=php_sablot.dll ;extension=php_snmp.dll extension=php_sybase_ct.dll ;extension=php_yaz.dll ;extension=php_zlib.dll ... .. [Sybase] ; Allow or prevent persistent links. sybase.allow_persistent = On ; Maximum number of persistent links. -1 means no limit. sybase.max_persistent = -1 ; Maximum number of links (persistent + non-persistent). -1 means no limit. sybase.max_links = -1 sybase.interface_file = "c:\sybase\ini\sql.ini" ; Minimum error severity to display. sybase.min_error_severity = 10 ; Minimum message severity to display. sybase.min_message_severity = 10 ; Compatability mode with old versions of PHP 3.0. ; If on, this will cause PHP to automatically assign types to results according ; to their Sybase type, instead of treating them all as strings. This ; compatability mode will probably not stay around forever, so try applying ; whatever necessary changes to your code, and turn it off. sybase.compatability_mode = Off [Sybase-CT] ;sybct.interface_file = "c:\sybase\ini\sql.ini" ; Allow or prevent persistent links. sybct.allow_persistent = On ; Maximum number of persistent links. -1 means no limit. sybct.max_persistent = -1 ; Maximum number of links (persistent + non-persistent). -1 means no limit. sybct.max_links = -1 ; Minimum server message severity to display. sybct.min_server_severity = 10 ; Minimum client message severity to display. sybct.min_client_severity = 10 [bcmath] ; Number of decimal digits for all bcmath functions. bcmath.scale = 0 TIA -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] adodb 1.10 released
http://php.weblogs.com/adodb
Database wrapper library 1.10. Now supports cached recordsets.
Example below:
include('adodb.inc.php');
include('tohtml.inc.php');
$ADODB_CACHE_DIR = '/usr/local/adodbcache';
$conn = &ADONewConnection('oracle');/* Oracle 8, use 'oci8' */
$conn->PConnect('','scott','tiger');
$rs = $conn->CacheExecute(15,'select * from table');
rs2html($rs); /* recordset to html table */
The 15 in CacheExecute() indicates that the recordset will be cached
for 15 seconds. Subsequent calls with this SQL statement will use the
cached results until the 15 seconds expires.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] php -> MSSQL
> > As someone else has noted, the ODBC functions are one way. > > Another way, particularly if you prefer to talk to the database directly > rather than through a translation layer, is to install the FreeTDS > libraries (http://www.freetds.org/) on your Linux machine and then build > PHP with the --with-sybase configuration parameter. This will enable > the mssql_* functions. > > Hello, Please tell me : Does it work with MS SQL server 2000. How build freetds (--what ?) ? snpe -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Looking for a script
Can someone point me towards a down & dirty (and, of course, free) classified ads script? doesn't have to be fancy, but I have to get it in this weekend... TIA -BD- http://www.bustdustr.net Home of Radio Free Bd -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] newbie MySQL question
hi, i'm building a website right now with a shows page on it which will scroll horizontally in a window. i have each show listed in a table called shows (db is called almavale_board) with the following fields: id - bandplaying - venue - date - time - cover - description what i need to do is have the shows listed by date, having the latest date listed first. here's the code i have presently: $row->bandplaying$row->venue$row->date$row->time$row- >cover$row->description "; } mysql_close($link); ?> oh and the date is in this format : Month-Day-,Year (ex. May 19, 2001) if anyone can help me out on this at all (or has any questions about my problem), please reply to this post, i'd be very appreciative. Thanks, Matt -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] newbie MySQL question
> $result = mysql_query("select * from shows");
Change to
> $result = mysql_query("select * from shows ORDER BY date DESC");
On Saturday 19 May 2001 21:45, Matt Nigh wrote:
> hi, i'm building a website right now with a shows page on it which will
> scroll horizontally in a window. i have each show listed in a table called
> shows (db is called almavale_board) with the following fields:
>
> id - bandplaying - venue - date - time - cover - description
>
>
> what i need to do is have the shows listed by date, having the latest date
> listed first. here's the code i have presently:
>
>
>
> $link = mysql_connect("localhost","almavale","violet");
> if(!$link) die ("Could not connect to MySQL!");
> mysql_select_db("almavale_board",$link);
> $result = mysql_query("select * from shows");
> $num = mysql_numrows($result);
> for($x=0;$x<$num;$x++) {
> $row = mysql_fetch_object($result);
> print " cellspacing=4 border=0> size=1>
> $row->bandplaying$row->venue$row->date$row->time$row
>-
>
> >cover$row->description
>
>
> ";
> }
> mysql_close($link);
> ?>
>
>
>
>
> oh and the date is in this format : Month-Day-,Year (ex. May 19, 2001)
>
> if anyone can help me out on this at all (or has any questions about my
> problem), please reply to this post, i'd be very appreciative.
>
>
>
>
> Thanks,
>
> Matt
--
Paul Campbell
http://www.cmm.uklinux.net/
mailto:[EMAIL PROTECTED]
[EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] newbie MySQL question
this would work, and does for the day, but for the month it doesn't. also,
is there code to have:
$result = mysql_query("select * from shows ORDER BY date DESC"); (or
whatever code works)
and
$result = mysql_query("select * from shows where id >= $show order by id
limit 8");
combined together to make it so that there's only 8 rows per page and yet it
displays the date (ex, May 19, 2001) in descending format ?
Also, is there a way to have the PHP figure out when to go the next page
after 8 rows, or to not put a link if there's 7 or less rows? like
http://www.thesite.com/shows/main.php?show=1 when it has 8 rows, it displays
a link to http://www.thesite.com/shows/main.php?show=12, but when there's 7
or less rows, it displays no link? There's probably some if/else statement
to run, but I have no idea what it would be.
If I sound confusing, I'm really sorry, I'm pretty bad at explaining things
well, so ask if you don't understand what i mean by something.
Thanks again,
Matt
> > $result = mysql_query("select * from shows");
> Change to
> > $result = mysql_query("select * from shows ORDER BY date DESC");
>
>
> On Saturday 19 May 2001 21:45, Matt Nigh wrote:
> > hi, i'm building a website right now with a shows page on it which will
> > scroll horizontally in a window. i have each show listed in a table
called
> > shows (db is called almavale_board) with the following fields:
> >
> > id - bandplaying - venue - date - time - cover - description
> >
> >
> > what i need to do is have the shows listed by date, having the latest
date
> > listed first. here's the code i have presently:
> >
> >
> >
> > > $link = mysql_connect("localhost","almavale","violet");
> > if(!$link) die ("Could not connect to MySQL!");
> > mysql_select_db("almavale_board",$link);
> > $result = mysql_query("select * from shows");
> > $num = mysql_numrows($result);
> > for($x=0;$x<$num;$x++) {
> > $row = mysql_fetch_object($result);
> > print " > cellspacing=4 border=0> > size=1>
> >
$row->bandplaying$row->venue$row->date$row->time$row
> >-
> >
> > >cover$row->description
> >
> >
> > ";
> > }
> > mysql_close($link);
> > ?>
> >
> >
> >
> >
> > oh and the date is in this format : Month-Day-,Year (ex. May 19, 2001)
> >
> > if anyone can help me out on this at all (or has any questions about my
> > problem), please reply to this post, i'd be very appreciative.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] newbie MySQL question
On Sat, 19 May 2001, Matt Nigh wrote: > hi, i'm building a website right now with a shows page on it which will > scroll horizontally in a window. i have each show listed in a table called > shows (db is called almavale_board) with the following fields: > > id - bandplaying - venue - date - time - cover - description you could put the band info in another table and reference them by bandid or something. this would make it easier to expand, like if you ever wanted to collect stats on each band (like members, genre, etc.). i only mention this because i did a calendar of events page a while back and eventually went to such a format. it is much easier this way because each event was only listed in the database once. just a thought... > what i need to do is have the shows listed by date, having the latest date > listed first. here's the code i have presently: > > [ code snip ] > > oh and the date is in this format : Month-Day-,Year (ex. May 19, 2001) > > if anyone can help me out on this at all (or has any questions about my > problem), please reply to this post, i'd be very appreciative. how is the date column defined in mysql... is it a DATE type? ... if so the date would look something like 2001-05-19 in mysql, and you could use something like: SELECT DATE_FORMAT(date, '%M %d, %Y'), ... FROM shows ORDER BY date DESC and mysql would sort and format the date as necessary. like this: mysql> select DATE_FORMAT(date, '%M %d, %Y') from dates order by date desc; +--+ | DATE_FORMAT(date, '%M %d, %Y') | +--+ | March 31, 2001 | | March 29, 2001 | | March 28, 2001 | | March 28, 2001 | | March 27, 2001 | | March 24, 2001 | ... hope this helps... :) -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Unable to Load Modules (php_oci8.dll)
I am trying to run oracle, mysql, and mssql with php using Apache on Windows 2000. Apache would not start when I tried to load certain extensions in php.ini. Some extensions work and others do not. Mssql and oracle both would not work. I read somewhere that putting libsasl.dll in the winnt\system32 directory might work so I did that and it fixed php_mssql.dll, but neither of the oracle dlls will work. I suspected that apache might be the problem so I tried BadBlue and it still does not work. Everytime I try to load a php script it gives me a popup error box that says "Could not find module d:\php\extensions\php_oci8.dll" when I know for a fact that it is in that directory as well as many others. Is there another file I need to add to system32 that php_oci8.dll requires? I never ran into this problem installing oracle and php on win98 and PWS. - Doug
