Could someone have a look at this syntax and give me some guidance what I
may be overlooking?
SELECT * from $TableName WHERE machinename != 'FIND_ME' OR machinename !=
'OPEN'
I can make the statement work individually, but when I try to add the 'OR'
statement it fails to 'remove' the designated
Well, I know you stated that you do not find M$ Access all that good, but
you could use Access as a GUI Front end to the MySQL backend. Just a
thought.
If you are looking at doing that, I suggest you read up on MyODBC since that
is what is needed to get the two to talk to each other. I have done
With what little info you presented allow me to try and answer this one:
$db_server: I am assuming that the script you are using is a premade one
that can handle different types of database backends, if this is the case,
you will need to look at the documentation that came with the script to see
w
OK, Have another small issue that maybe someone could help me out with.
When using a JOIN I can pull records from a second table without a problem
(now).
I am wanting to display two fields ( id and notes) however I only want the
id field to display once and all the notes to be displayed.
Here is
Original Message-
> From: Hunter, Jess [SMTP:[EMAIL PROTECTED]
> Sent: Sunday, December 14, 2003 11:34 AM
> To: [EMAIL PROTECTED]
> Subject: Help with "JOIN" and Record Display
>
> This being the first time I have tried to do a JOIN statement (and still
>
This being the first time I have tried to do a JOIN statement (and still not
yet fully understanding it). If someone could take a look at the below code
and see what I may be doing wrong.
I have the actual code working and it displays the information from
$TableName2.notes, however in this table t
I keep getting the following error when I try to run an "if" statement
Warning: 2 is not a valid MySQL-Link resource in then give the filename
Here is what I am trying to do.
if ($bumpnumber<4) {
print ("display this");
}else {
print ("display that");
}
mysql_close ($Link);
Anyone have any idea
Jeff,
The first example worked perfectly, Thanks for the quick response
Jess
> -Original Message-
> From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]
> Sent: Friday, December 12, 2003 10:02 AM
> To: Hunter, Jess
> Subject: Re: How to keep multiple instances of the s
Using PHP as the front end I am creating a form with a dropdown box that
displays information from one table to be inserted into another table.
That's PHP and I have gotten that part down with no issue.
However, in the table a person could be listed multiple times and I only
want a user to be list
Being real new to MySQL I am having difficulty finding information on how to
retrieve data from the last record in a database.
I have tried using the SELECT LAST_INSERT_ID() statement but that only works
on a per connection basis and doesn't help all the times.
Basically I want to goto the end of
10 matches
Mail list logo