Re: [PHP-DB] Result is not empty

2001-11-20 Thread phpnet

the lack of proper close html code will cause a no show in Netscape, but will show in 
Ie

|
|
|
|CO:
|$co
|
|
|
|IRC NICK<<<---
|$nick
|
|
|
|<<<---
|
|
|";

[EMAIL PROTECTED]

SeaPortNetHosting: Reliable Web Hosting
Plans from $17.95 www.yourname.com
http://www.SeaPortNet.com/
1(209)551-7028 

-- 
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] (int)mysql_result?

2001-11-20 Thread phpnet

What does adding the (int) do to this statement:
$poll_sum = (int)mysql_result($poll_result, 0, "SUM");
I  do not find anything about the "SUM" either.
Thanks
Dave 


-- 
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] get field content

2001-10-29 Thread phpnet

Help!
I have drawn a blank..
I want to get the content of a field in a table where I know the 
databaseName,tableName and columnName and the rowNumber.
Like:
$answer =  mysqlCommand("select ColumnName from tableName WHERE rowNumber = 
$rowNumber,$db)


-- 
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] Please help!

2001-08-22 Thread phpnet

you do not need a counter, just use a 2 column table


| Thats my code!
| 
| What I want to be able to do is have it so instead of one column there are 
| two columns of pictures:
| 
| 
| pic1  | pic2
| pic3  | pic4
| 
| etc..
| 
| 
| How can I do this?
| 
| Thanks in advance!
| 
| 
| 
| 
| http://www.charmed-guide.com/pictures/$row[2].jpg\"; 
| target=_blank>\n");
| printf("http://www.charmed-guide.com/pictures/$row[2]_th.jpg\"; 
| border=0>\n");
| printf("\n");
| 
| $counter++;
| }
| 
| }
| ?>
| 
| _
| Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
| 
| 
| -- 
| 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]
| 
| 

[EMAIL PROTECTED]

SeaPortNetHosting: Reliable Web Hosting
Plans from $17.95 www.yourname.com
http://www.SeaPortNet.com/
1(209)551-7028 

-- 
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] using is_uploaded_file($userfile1)??

2001-08-15 Thread phpnet

Can someone tell me why this works in PHP4.0.3pl1 on one server and not in PHP4.0.6 on 
a different server?

I am using is_uploaded_file($userfile1)

LOAD DATA LOCAL INFILE '/var/tmp//phpAP3729' INTO TABLE spcdata FIELDS TERMINATED BY 
',' OPTIONALLY ENCLOSED BY '\"'
ESCAPED BY '\\' 
(id,username,fname,mname,lname,suffix,title,org,address,city,state,zip,phone,fax,email,specialty)

-- 
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] Re: function ?? SOLVED

2001-07-28 Thread phpnet

SOLVED
Wrong varable!
Is that as bad as spelling errors?
Dave



| In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED] 
| wrote:
| 
| > are INSERT INTO statements forbiden inside a function??
| 
| Assuming that you're referring to a PHP function and not a function of the 
| RDBMS, no it's not forbidden.  Show the relevant snip of code and any error 
| messages being reported.  Most likely, you've got a typo or syntactical 
| problem that's causing the insert to fail (ex. forgetting to bring a global 
| var into the function's local scope, an extra curly brace, missing quote, 
| etc.).
| 
| -- 
| CC
| 
| -- 
| 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]
| 
| 

[EMAIL PROTECTED]

SeaPortNetHosting: Reliable Web Hosting
Plans from $17.95 www.yourname.com
http://www.SeaPortNet.com/
1(209)551-7028 

-- 
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] function ??

2001-07-27 Thread phpnet

are INSERT INTO statements forbiden inside a function??
Dave

-- 
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] results testing

2001-07-27 Thread phpnet

I have had no success finding a thread on the subject of how to test results of a 
query.
I know it can be positive without finding any rows.
What are the ways to test.
Dave

-- 
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] (preg_match ?

2001-07-26 Thread phpnet

What's wrong with this use of preg_match?

$search = "TheName"
$data = "TheName,TheAddress,ThePhone"

if (preg_match('"/\b'.$search.'\b/i"', $data)) 
{
echo "True";
}
else
{
echo "False";
}
I am trying to see if the search name matches exactly a name in the $data.
Thanks
Dave

-- 
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] WHERE field = str

2001-07-25 Thread phpnet

Thanks Chris
I searched everything I could think of. Where should I have found this is the manual?
Dave


| > I am trying to find a str within a field using a select statement like
| > SELECT * FROM tablename WHERE fieldname has the string within it
| > Is there a way to do this?
| 
| WHERE fieldname LIKE "%$string%"
| 
| Chris
| 

[EMAIL PROTECTED]

SeaPortNetHosting: Reliable Web Hosting
Plans from $17.95 www.yourname.com
http://www.SeaPortNet.com/
1(209)551-7028 

-- 
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] WHERE field = str

2001-07-25 Thread phpnet

I am trying to find a str within a field using a select statement like
SELECT * FROM tablename WHERE fieldname has the string within it

Is there a way to do this?
Dave


-- 
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]