I really need some help. I'm trying to use an IF statement in a multi-table
left join. I'm joining four tables (customers, contents, courses
locations).
IF can only be used in the select part or the where part, it can't be
used in the join part of a query.
In the contents table I have two
u can use array
put all your data into array.. example below
while($tmp=mysql_fetch_array($res)){
$myData[$tmp[0]]=$tmp[1];
}
ksort($myData);
foreach($myData as $nm=$val){
//put your script here..
}
- Original Message -
From: Bryan [EMAIL PROTECTED]
To: php-db@lists.php.net
UNION appeared in MySQL 4.0.0
Mayhap your provider has not yet upgraded.
There is no such thing as disabling/ granting UNION.
HTH
Ignatius
_
- Original Message -
From: John Ryan [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, August 31, 2003 8:58 PM
Subject:
Jennifer,
Wondering do I have to have the WHERE clause in a select query?
$b=mysql_query( SELECT * FROM my_table) -can I use something like
this
or do I have to put WHERE in the statement?
Hate to answer a question with a question, but what happened when you
tried typing this query into
MySQL is very well documented as well. www.mysql.com, click on
documentation.
Dl Neil [EMAIL PROTECTED] wrote in message
160001c1c356$2f629c40$c200a8c0@jrbrown..">news:160001c1c356$2f629c40$c200a8c0@jrbrown..;
Jennifer,
Wondering do I have to have the WHERE clause in a select query?
On Sun, 3 Mar 2002, Jennifer Downey wrote:
Wondering do I have to have the WHERE clause in a select query?
$b=mysql_query( SELECT * FROM my_table) -can I use something like this
or do I have to put WHERE in the statement?
The where clause is optional
--