[PHP-DB] RE: i am lost (php warning)

when it is live. die(mysql_error()); } $numRows = mysql_num_rows($sql_query); if (($numRows) 0){ $valid = $user; session_start(); session_register(valid); } } if (session_is_registered(reg)){ echo ok; }else{ echo sorry; } ? Jeremy Shovan -Original Message

[PHP-DB] RE: Import into mysql from csv-file

Mysql LOAD DATA INFILE '/tmp/jokes.txt' INTO TABLE jokes FIELDS TERMINATED BY '' http://dev.mysql.com/doc/mysql/en/mysqlimport.html http://dev.mysql.com/doc/mysql/en/LOAD_DATA.html Jeremy Shovan -Original Message- From: Ruprecht Helms [mailto:[EMAIL PROTECTED] Sent: Monday, January 17

[PHP-DB] Re: php-db Digest 30 Dec 2003 12:07:25 -0000 Issue 2191

Try this: select LastName from MyTable where left(LastName,1) = 'a' and left(LastName,1) 'f'; How about Select LastName from sometable where LastName = 'A' and LastName 'F' Hth Henrik Hornemann -Oprindelig meddelelse- Fra: Doug Parker [mailto:[EMAIL PROTECTED] Sendt: 29. december

[PHP-DB] RE: Changing case

Use the strtoupper() function $var = strtoupper($var); -Original Message- From: Robert Sossomon [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 12, 2003 8:29 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Changing case I have a form that allows for an item to be entered,

[PHP-DB] RE: Problem

I was able to get rid of the parse error, but what I saw causing the error was a little strange. All I did was delete the spaces between your if statement and the bracket that follows ie. if( not if ( The next thing that I did was rewrote the line that says 'echo tdOpen/td;' although I didn’t

[PHP-DB] RE: show data from 2 tables

Try rewriting your query. It looks to me that you probably have an error in your SQL statement and it only seems fine because you appended the @ to the beginning of the mysql_query() function. I would suggest using a join statement. If(!$result = mysql_query(SELECT orders.orderid,

[PHP-DB] RE: Query works but can't echo variable :'(

You are selecting it as date but trying to echo DateOfOrder Try this: $TheDate = mysql_query(select DATE_FORMAT(DateOfOrder, '%d, %m, %Y') as date from Orders Where Orders.ID = '$TransID'); while($OrderDate = mysql_fetch_array($TheDate)) { $Date = $OrderDate[date]; } -Original Message-

[PHP-DB] RE: mysql field comparison to multiple variables

Try this WHERE date_field != $date_1 OR date_field != $date_2 OR date_field != $date_3 -Original Message- From: Mike Baerwolf [mailto:[EMAIL PROTECTED] Sent: Friday, October 24, 2003 6:46 PM To: [EMAIL PROTECTED] Subject: mysql field comparison to multiple variables Hello, I trying to

[PHP-DB] RE: multiple WHERE's

Try this, I am assuming that emailerror is one of the fields in your database. $thisstart=$massmail[current]-1; [EMAIL PROTECTED](select first_name,last_name,email,.$mysql_prefix.users.username from .$mysql_prefix.users $leftjoinfirst $leftjoinsecond limit $thisstart,$massmail[stop] where

[PHP-DB] RE: Need help Get/send Variabel to another window

Is it a frame page? -Original Message- From: agus supriatna [mailto:[EMAIL PROTECTED] Sent: Friday, October 10, 2003 1:25 AM To: [EMAIL PROTECTED] Subject: Need help Get/send Variabel to another window Dear all I have two page one as main and secon as child, now I have problem how to

RE: [PHP-DB] RE: Need help Get/send Variabel to another window

window I'm guessing this is html? Parent.opener.formname.formfield.value = this.value; Michael Scappa -Original Message- From: Jeremy Shovan [mailto:[EMAIL PROTECTED] Sent: Friday, October 10, 2003 12:24 PM To: 'agus supriatna'; [EMAIL PROTECTED] Subject: [PHP-DB] RE: Need help Get

RE: [PHP-DB] mysql_error() (was Re: Getting last insert id?)

Use echo(mysql_error()); -Original Message- From: Ben Edwards [mailto:[EMAIL PROTECTED] Sent: Friday, October 10, 2003 5:43 AM To: pete M Cc: PHP DB List Subject: Re: [PHP-DB] mysql_error() (was Re: Getting last insert id?) On Thu, 2003-10-09 at 17:35, pete M wrote:

[PHP-DB] RE: REGEXP and Variables.

-Original Message- From: Shannon Doyle [mailto:[EMAIL PROTECTED] Sent: Thursday, October 09, 2003 1:19 AM To: [EMAIL PROTECTED] Subject: REGEXP and Variables. Hi People, Need a little assistance with the following MySQL query:- $query = SELECT employ_id,company FROM employers WHERE

[PHP-DB] pass by reference

How do you pass by reference? I tried $var = myFunction($var1, $var2); but it gave me a warning saying that pass by reference is depreciated

[PHP-DB] RE: Hyperlinks in MySQL dB

-Original Message- From: Gary H. Holabird [mailto:[EMAIL PROTECTED] Sent: Thursday, October 02, 2003 11:06 AM To: [EMAIL PROTECTED] Subject: Hyperlinks in MySQL dB This has got to be really simple I feel really stupid having to ask but... I'm a very green n00b writing my first php

RE: [PHP-DB] Re: Email Application

Try this function send_html_mail($myname, $myemail, $contactname, $contactemail, $subject, $message) { $headers = MIME-Version: 1.0\n; $headers .= Content-type: text/html; charset=iso-8859-1\n; $headers .= X-Priority: 3\n; $headers .= X-MSMail-Priority: Normal\n; $headers .= X-Mailer: