to spam a list with an
advertisement I must say. Better be careful though, 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
condition at all =) But excellent advice
nonetheless...much better than what I was going to suggest =)
Sincerely,
Craig Vincent
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
ion.
So say if you wanted to find queries WHERE the name started with an A
$qid = db_query("SELECT ID, 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
| |
| 90 | |
| 110 | |
-
? Perhaps an example would clear things up of what you would like =)
Sincerely,
Craig Vincent
--
PHP Database Mailing List
> 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
ript to extract and update?
UPDATE table SET password_column = PASSWORD('password_column');
That 'should' work for youuntested code though. Back up your table data
first =)
Sincerely,
Craig Vincent
--
PHP Database Mailing List (http://www.php.net/)
To unsubsc
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 =)
e way replace works is it looks for a unique index key in your update
list, if it finds one it uses 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 tabl
I suggest you
setting up 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 singl
CompanyName','$Address','$City','$StateorProvince','$PostalCode','$Reg
ion','$Country','$WebSite'";
If you're still missing it, you're missing a ) after '$WebSite'
Sincerely,
Craig Vincent
--
PHP Datab
$myrow=mysql_fetch_array ($result);
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 commands
large number of records or will be doing a fair number of these queries on a
regular basis
Sincerely,
Craig Vincent
--
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]
y key not in numerical synchronization will not cause you
any performance problems.
Sincerely,
Craig Vincent
--
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
mssql_connect( ) function not found.
Could someone tell me how to solve this problem?
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 commands, e
untry_sql = 'SELECT countryid FROM TBL_COUNTRY';
while ($myrow = mssql_fetch_row($country_query)) {
echo "$myrow[0]"; }
else { echo ">$myrow[0]"; }
}
Sincerely,
Craig Vincent
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL
contain a WHERE clause as INSERT is used to create a new row,
not update a current row. The UPDATE command is more I think what you're
wanting.
UPDATE table SET column2 = '$x', column4 = '$y' WHERE column1 = '$z'
Try that and see what it does for you.
Sin
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,
17 matches
Mail list logo
