The query should look similar to this:
SELECT table1.col as [column_a],
table2.col as [column_b]
FROMtable1
LEFT JOIN (or LEFT OUTER JOIN) table2
ON table2.some_key_col = table1.some_key_col ... for all required keys
WHERE
--
PHP Database Mailing List (http://www.php.net/)
To
The query should look similar to this:
SELECT table1.col as [column_a],
table2.col as [column_b]
FROM table1
LEFT JOIN (or LEFT OUTER JOIN) table2
ON table2.some_key_col = table1.some_key_col ... for all required keysWHERE
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visi
Maybe if you ran the delete query, then the optimize table query immed
after, it wouldn't take such a long time.. I would imagine if you had quite
large tables though, it could still take some time.. And if users are
connecting over the internet, you don't want too may delays..
If the user doesn'
I'm not sure how to change DELETE statements in this fashion, but is there a
way maybe to run an OPTIMIZE TABLE query every so often in your PHP script..
I don't imagine you'd want it running too often since it locks the table you
run it on, but maybe on the reload of $PHP_SELF or something.. It c
Hey, couldn't you just send the text as HTML and it would retain any
formatting?
Bob
"Jeff Oien" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> I have a form where someone enters the body of an email message
> into a part of a form to be sent out to a list.
On the wrap= option, I have an HTML reference that mentions that IE4 used
wrap=" off | physical | virtual".. i don't know if it supports it still but
you might try it..
Bob
"Jeff Oien" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> I tried wrap=hard already. I
You need a wrap= within your textarea.. You may need a couple if the
browsers haven't come together on it yet.. But you can check it out here:
http://www.blooberry.com/indexdot/html/tagpages/t/textarea.htm
Just scroll down to wrap and check it out..
BTW, this seems like HTML help rather than PH
$link = mysql_connect ( "db.localhost.org", $user , $pass ) or die (
"Couldn't Connect to Mysql Server" );
$db = mysql_select_db( $dbname, $link );
$query = "SELECT * FROM users WHERE screen_name = '$screen_name' AND ...
That should work..
Bob
"Luke Kearney" <[EMAIL PROTECTED]> wrote in message
I ran into the same problem on a script yesterday.. It turns out that one of
the vars in my mysql_connect() command wasn't assigned.. It gave me no
indication of this so I hadn't thought to look there.. I just happened to be
reading back through the whole page to see what I could find and noticed
Hey, if the databases contain the same data, why don't you just have them
use one database. Just set up MySQL with a user on the internet server that
the intranet system uses to connect to it with.. Do it over SSL and it would
be secure then. Wouldn't that be somewhat simpler and less time consumi
Maybe change mysql_fetch_array($ret) to mysql_fetch_row($ret)? Not sure but
I've used that before to do what appears to be similar while loops..
Wouldn't the data still get retrieved in array form with that? If I'm wrong,
feel free to publicly ridicule me..
Later,
Bob Weaver
"Jennifer Downey"
The above post may be unclear.. What he did was used if() statements to
compare whatever and generate the query differently based on what he found..
$lotsOdata = $database->result( "SELECT * FROM someTable" );
$count = mysql_num_rows( $lotsOdata );
while( $count > 0 ) {
if( $lotsOdata[city] !
I don't know that I could help much with your statement.. But you mentioned
doing if() statements in SQL queries.. Well, my programmer always writes
them into PHP scripts then just runs them from there.. Then he can include
if() conditions, or whatever else he needs.. Just a quick little
cust_impo
These guys probably have one for you.. "If you give a man a fish..." (as was
stated earlier in the week)
http://www.mysql.com/doc/I/N/INSERT.html
Later,
Bob Weaver
"Marc S. Bragg" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Hi there:
>
> Can canyone give
This is whole main() function.. I'm sure you didn't need all this but I
wasn't sure what to send without possibly leaving out something important..
So here it is:
function main( $category = "" )
{
global $database, $PHP_SELF, $settings, $secure, $PHPSESSID, $items,
$cartId;
$inventory = $dat
This is what I have.. I think it's along the same lines as what you are
asking.. If not, just ignore my drunken ramblings.. It isn't with oci stuff
but if it's similar to what you need then you should be able to convert it
over..
$result = $database->query( "SELECT * FROM contacts WHERE cartId='$
Are you talking about something that will display a list of products like
this page:
http://survivalherbs.com:8080/order/index.php?command=viewCategory&category=
Herbal+Remedies
These are all gathered from the database with one SELECT statement then put
together in the table with a while loop..
I've always done it like this:
$count = mysql_num_rows( $result );
if( $count == 0 ) then doomething();
But there may be a better way..
In yours it appears you are testing for anything in mysql_num_rows($result)
and a value of 0 in mysql_num_rows($ret). I may be misundertanding you. Do
you mean
18 matches
Mail list logo
