ahhh, so for every record that exists in acts you are needing an update

my advice would be to use a sql 'for each' loop, you can use a cursor and iterate through each row and execute the update...

are you sure you are needing to do 34 updates, 9 records only need 9 updates

if the update isn't working properly, can you give us a little more of the schema and also what the distinct column is?

What is the result of the show full columns statement i sent you, if its latin1_bin thats why

also try this statement also


select * FROM assign2 WHERE UPPER(CONVERT(keyword1 USING latin1)) LIKE '%MICROSOFT%';

What type of collation is this?

run this


SHOW FULL COLUMNS FROM assign2;

as long as the dns can resolve the hostname you can use the name in place of 'localhost' as well, this way if the ip ever changes it will still resolve to the correct address

this doesn't have error handling, but here is how you do it following your line


$result = $mysqli->query($queryStr);

$row_count = $result->num_rows;

$result->close();

no, i don't believe the replace has that exact logic

show us your complete update statement or select whatever that may be, and lets go from there

add a where clause for
where str = 'jon' or str like ('jon %')

notice the space after jon

take a look at this line


rs.Fields("CITA") = Val(Me.TextBox14.Text)


change to


rs.Fields("CITA").value = Val(Me.TextBox14.Text)

Great working together everyone

As far as speed goes, I think its more in the indexes and proper keys and relational set up and the actual query rather than using the join alone

Just a simple...

look at my previous post with a subquery just for you javamedia :-)

i'm not against them at all, just meaning don't shy away from the joins, get a understanding of them and use them in combination...

sorry bout that, was a late night and didn't think twice about it

this will work

select
(select count(*) from posts p1 where p1.user_id = u.user_id) as post_count,
u.user_id
from users u...

you are trying to do an inner join on something that isn't there, all users don't have posts

unlike javamedia, i would suggest trying to use inner or outer joins, at least to me it makes life much...

terminate the first with a semicolon if that is what you are meaning, to compare two queries you use Query -> split tab and execute

right, sql express is ms sql not mysql, just trying to keep things in the correct forum

ok now theres a start, still in mysql forum, but we can work with this

close this thread, start one in mssql forum, then we can continue from there

you have an excel sheet or mysql database? this is the mysql forum

first we have to figure out where the problem is at

is the data stored with the cr lf's and not outputting correctly?
or not stored with formatting (incorrectly) and therefore outputting properly?

you gotta remember formatted text is specific to the application, i'm assuming from a text file it is CR LF, but in html you will need to use <P>, when you are running the select, what are you...

lol easiest way to explain it is be specific


from table1, table2 join table3 on id = table3.id


who knows what that means

now this

here i found an article on the suggestion i gave you earlier

its because order of precedence, also always try to do joins this way, makes much cleaner code
...

just a normal insert will work

what are you inserting from?

sure thing man, finally got up to veteran poster now along the way :-)

glad it all works for you, and i'm sure you understand relational databases much better

TORONTO here i come!!!

actually no need to check the uas table at all, just delete, then insert

you are correct, check user table i guess from a login or whatever that is, then no need to check anything against uas...

no need to do a check, just run the delete, it won't matter if there is a match or isn't

then just run inserts

constraints will do what you are meaning, delete from the user table then it will propagate to other tables that reference that user

lol did i put delete *, just use delete from without the *

well it doesn't make sense as far as the user won't have any services, from the database side it just means there is a user, just no services saved yet

yes users -> uas 1..x

it means a user has...

should be the opposite, user_id can't exist in the uas table without being in the user_table

delete from the uas table only, not user table

try to run the command without php and see if you get...

noooo, not the user table

this is what i was meaning, i think you are using $u_id

delete * from useraccessservices where user_id = $u_id


maintain the user table, how do you get to the...

ahhhh, well we have no deletes here

i don't really like this option, but would you want to delete all the rows for that user_id prior to doing updates and inserts?


(edit: stupid me, there...

you can specify sql user accounts and ip addresses if need be

print the query right before its executed once values are subbed in, need to see what is happening here

i don't think speed is necessarily going to be an issue, just be sure to make fk and primary keys, and indexes where necessary and you should be good using a single db

on top of that, it would be...

there will be an entry in the array for each service for that user, the part i'm not sure about is how are you having duplicate id's?
40
40
40?

42
42
42?

you can also use mysql_num_rows to the same effect
http://us.php.net/mysql_num_rows

thats it man

the reason why you have to query all three for the uas, is because user_id has multiple airports and multiple services for each, without a uas_id then you need to query against all...

sorry about that, all you need to do see if there is a result or not

here's a link if you are ever interested
http://pear.activeventure.com/package/package.database.db.db-common.getone.html

you sure you mean $aid instead of $a_id

also your update statement needs to be based on uas_id, otherwise , you will have multiple rows for each user in the update

see this database stuff isn't so hard now is it :-)