RE: [PHP-DB] Anti-virus alarm! Sulfbnk var inget virus.

, piss the wrong person off with a scam like this and you could have a lawsuit on your hands. Sincerely, Craig Vincent -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] Wildcards

, NAME, ADDRESS FROM users WHERE Name LIKE 'A%'); Sincerely, Craig Vincent -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] Re: Wildcards

to suggest =) Sincerely, Craig Vincent -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] Exclude indentical values

| | | 110 | | - ? Perhaps an example would clear things up of what you would like =) Sincerely, Craig Vincent -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http

RE: [PHP-DB] IP Address?

How can I find out the IP address of the client requesting a given php file? I know that you can use $HTTP_SERVER_VARS[REMOTE_ADDR] in more recent versions of PHP. Unfortunately, we only have PHP3.0.14 and I don't think that this option is available in our ancient version. I also can't use

RE: [PHP-DB] Resource ID

note a separate function/class isn't really all that necessary to query a table in another database...based on the code you provided. $q = mysql_query(SELECT id FROM $db.words WHERE word = '$word'); would work just as easily if not faster and using less resources =) Sincerely, Craig Vincent

RE: [PHP-DB] 'replace' with 'where'

that key to determine where the REPLACE is done. The update command would probably work better for you if all you're wanting to do is change column values of a record already stored in the table. It's also much easier and versatile Sincerely, Craig Vincent -- PHP Database Mailing List (http

RE: [PHP-DB] INSERT Won't Insert

','$StateorProvince','$PostalCode','$Reg ion','$Country','$WebSite'; /snip If you're still missing it, you're missing a ) after '$WebSite' Sincerely, Craig Vincent -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL

RE: [PHP-DB] Problem importing large db to mysql in windows

the MySQL replication system (chap 11 in the manual if I remember correctly). You don't have to be constantly receiving updates however if setup correctly you can use the LOAD table FROM master command to grab the most recent copy of the table you want in a single command. Sincerely, Craig Vincent

RE: [PHP-DB] Problem with my first script

snip $myrow=mysql_fetch_array ($result); /snip Remove the space in the function call and it should work fine for you ie. $myrow=mysql_fetch_array($result); Sincerely, Craig Vincent -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional

RE: [PHP-DB] mssql_connect() function not found when I load the page...

snip mssql_connect( ) function not found. Could someone tell me how to solve this problem? /snip You need to recompile PHP to include MSSQL support Sincerely, Craig Vincent -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional

RE: [PHP-DB] mssql_fetch_array problem

for (untested) $country_sql = 'SELECT countryid FROM TBL_COUNTRY'; while ($myrow = mssql_fetch_row($country_query)) { echo option value=$myrow[0]; if ($country == $myrow[0]) { echo selected$myrow[0]/option; } else { echo $myrow[0]/option; } } Sincerely, Craig Vincent

RE: [PHP-DB] Deleting specific records from MySQL tables

Try putting the variable into single quotes mysql_db_query(phpads, DELETE FROM adviews WHERE bannerID='$banresult[bannerID]'); That should resolve the problem. Sincerely, Craig Vincent -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED