Re: [PHP-DB] How to make it case sensitive?

2001-09-21 Thread Jason Stechschulte
) binary -- Jason Stechschulte [EMAIL PROTECTED] -- I think it's a new feature. Don't tell anyone it was an accident. :-) -- Larry Wall on s/foo/bar/eieio in [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional

Re: [PHP-DB] Renaming a database name...

2001-09-19 Thread Jason Stechschulte
the old database to the new database. -- Jason Stechschulte [EMAIL PROTECTED] -- Beauty? What's that? -- Larry Wall in [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED

Re: [PHP-DB] Modify Query, or sift through results?

2001-06-28 Thread Jason Stechschulte
will be returned. -- Jason Stechschulte [EMAIL PROTECTED] -- If you're going to define a shortcut, then make it the base [sic] darn shortcut you can. -- Larry Wall in [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED

Re: [PHP-DB] MySQL Error???

2001-06-28 Thread Jason Stechschulte
negative numbers in the column. This can be done easily from the mysql client: alter table your_table modify your_column smallint unsigned; -- Jason Stechschulte [EMAIL PROTECTED] -- /* This bit of chicanery makes a unary function followed by a parenthesis into a function with one argument, highest

Re: [PHP-DB] Extracting enum/set values from database

2001-06-27 Thread Jason Stechschulte
, , $table[Type])); } elseif($table[Field] == $column $columnType == set) { return explode(,, preg_replace(/^set\(|'|\)/i, , $table[Type])); } } } ? -- Jason

Re: [PHP-DB] Variable Variables in PHP

2001-06-27 Thread Jason Stechschulte
. -- Jason Stechschulte [EMAIL PROTECTED] -- It's the Magic that counts. -- Larry Wall on Perl's apparent ugliness -- 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

Re: [PHP-DB] Sql result loop problem !

2001-05-18 Thread Jason Stechschulte
= mysql_fetch_array($result)) { if($p[s_bereich_name] != $oldBereichName) { echo $p[s_bereich_name].br\n; $oldBereichName = $p[s_bereich_name]; } echo $p[s_news_text]. - .$p[s_users_real_name].br\n; } ? -- Jason Stechschulte [EMAIL PROTECTED] -- If I allowed next $label then I'd also have

Re: [PHP-DB] php - MSSQL

2001-05-14 Thread Jason Stechschulte
On Mon, May 14, 2001 at 12:11:17PM +0200, Dragan Dinic wrote: Hi there. Hi. Is there any possible way to connect PHP (running on apache 1.3.12 on Red Hat Linux 7) with Microsoft SQL server (running on Windows 2000) ? Yes -- Jason Stechschulte [EMAIL PROTECTED] -- Perl itself is usually

Re: [PHP-DB] Backup Database

2001-05-11 Thread Jason Stechschulte
On Fri, May 11, 2001 at 10:02:41AM +0800, Jennifer Arcino Demeterio wrote: what will i do to have a realtime backup of my database? It would help to know which database you are using. -- Jason Stechschulte [EMAIL PROTECTED] -- Your csh still thinks true is false. Write to your vendor today

Re: [PHP-DB] mp3 upload????

2001-05-04 Thread Jason Stechschulte
is not the format type What should I do? Please help. I will be very appreciate. Print out $imgfile_type to see what it is. -- Jason Stechschulte [EMAIL PROTECTED] -- No, I'm not going to explain it. If you can't figure it out, you didn't want to know anyway... :-) -- Larry Wall

Re: [PHP-DB] newbie: showing records from SQL

2001-05-01 Thread Jason Stechschulte
of information, and refer to the other website for more information... Have you even tried looking yourself?? The page below has many links to examples, tutorials, and many other useful things. http://www.php.net/links.php -- Jason Stechschulte [EMAIL PROTECTED] -- The way these things go

Re: [PHP-DB] MySQL Question

2001-04-18 Thread Jason Stechschulte
searched the archives @ http://www.mysql.com/documentation/searchlists.html As well as simply looking on the site @ http://www.mysql.com -- Jason Stechschulte [EMAIL PROTECTED] -- Randal said it would be tough to do in sed. He didn't say he didn't understand sed. Randal understands sed quite well

Re: [PHP-DB] How to back up database..... ?

2001-04-16 Thread Jason Stechschulte
On Mon, Apr 16, 2001 at 12:40:05AM +0800, E K L wrote: Hi all, Is there anyone can tell me how to back up Mysql database from one server to other server? Please advisethanks backup to zip: mysqldump --add-drop-table -u root -ppass database | gzip /dir/database.gz -- Jason

Re: [PHP-DB] ALTER TABLE - code not working.

2001-03-29 Thread Jason Stechschulte
mysql is returning. This has helped me find something strange with what I was doing when I could have sworn there was nothing wrong with my code. -- Jason Stechschulte [EMAIL PROTECTED] -- As someone pointed out, you could have an attribute that says "optimize the heck out of this routine&

Re: [PHP-DB] ALTER TABLE - code not working.

2001-03-29 Thread Jason Stechschulte
be happening. -- Jason Stechschulte [EMAIL PROTECTED] -- But you have to allow a little for the desire to evangelize when you think you have good news. -- Larry Wall in [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED

Re: [PHP-DB] SQL Select?

2001-03-27 Thread Jason Stechschulte
t = mysql_query($sql, $db) or die("$sqlbr".mysql_error($db)); ? This allows you to see the sql that is actually being executed, and you also get to see the actual mysql error. -- Jason Stechschulte [EMAIL PROTECTED] -- It is, of course, written in Perl. Translation to C is left

Re: [PHP-DB] mysql grant problem?

2001-03-26 Thread Jason Stechschulte
a question that should have been posted to a Mysql list. [EMAIL PROTECTED] -- Jason Stechschulte [EMAIL PROTECTED] -- OOPS! You naughty creature! You didn't run Configure with sh! I will attempt to remedy the situation by running sh for you... -- Larry Wall in Configure from the perl di

Re: [PHP-DB] How do I test on number of fields ?

2001-03-20 Thread Jason Stechschulte
ysql_link); It will show you your error in your query. -- Jason Stechschulte [EMAIL PROTECTED] -- There are still some other things to do, so don't think if I didn't fix your favorite bug that your bug report is in the bit bucket. (It may be, but don't think it. :-) Larry Wall in [EMAIL P

Re: [PHP-DB] What is the life time of mysql connection if I use pconnect()

2001-03-15 Thread Jason Stechschulte
of that apache process. -- Jason Stechschulte [EMAIL PROTECTED] -- 'Course, I haven't weighed in yet. :-) -- Larry Wall in [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL

Re: [PHP-DB] php/mysql

2001-02-22 Thread Jason Stechschulte
, you can use the keywords IF NOT EXISTS so that an error does not occur if the table already exists. http://www.mysql.com/doc/C/R/CREATE_TABLE.html -- Jason Stechschulte [EMAIL PROTECTED] -- The way these things go, there are probably 6 or 8 kludgey ways to do it, and a better way that involves