Search found 32 matches
- Sun Nov 30, 2008 2:48 pm
- Forum: PHP - Code
- Topic: Deleting from three tables at once
- Replies: 2
- Views: 130
Re: Deleting from three tables at once
Thanks I'll have to delete them seperatley Zed Can someone tell me if this is possible or do I need to wake up. I'm trying to delete some records from three different tables at once via check boxes, tabls don't have any join. This doesn't give me any error but not working either. It does work with O...
- Sun Nov 30, 2008 2:13 pm
- Forum: PHP - Code
- Topic: Deleting from three tables at once
- Replies: 2
- Views: 130
Deleting from three tables at once
Hi All Can someone tell me if this is possible or do I need to wake up. I'm trying to delete some records from three different tables at once via check boxes, tabls don't have any join. This doesn't give me any error but not working either. It does work with ONE table at a time thou. some help will ...
- Wed Nov 26, 2008 11:25 am
- Forum: PHP - Code
- Topic: Duplicate Results
- Replies: 3
- Views: 274
Duplicate Results
Hi All Can some please tell me what is wrong with this query it’s bringing out the Duplicate results according to $pagesize . As it is now it’s bringing out same result three times. Why??? I have inserted the query into phpMyAdmin its working fine bringing out one result. Some help will be greatly a...
- Mon Nov 24, 2008 9:04 am
- Forum: PHP - Code
- Topic: Duplicate output
- Replies: 2
- Views: 151
Re: Duplicate output
Thanks
Zed
Zed
aceconcepts wrote:I would imagine it's because you're querying two tables without using a JOIN.
Look up "sql join" in Google.
- Mon Nov 24, 2008 7:51 am
- Forum: PHP - Code
- Topic: Duplicate output
- Replies: 2
- Views: 151
Duplicate output
Hi All Can someone please point out what am I doing wrong here, the query should display one set of results but its showing me THREE same results even thou there is only ONE set of results in the databse so the insert query is fine it hasn't inserted the duplicate data. Some help will appreciated. T...
- Tue Nov 18, 2008 2:57 pm
- Forum: PHP - Code
- Topic: Two functions together
- Replies: 1
- Views: 163
Two functions together
Hi All I like to create two functions on a same file and run them. I've got a file where I've run a select query so there are list of results. I would like to create two functions Delete and Edit on a same page, I have been trying but failing miserably, could anyone guide to right direction please. ...
- Tue Nov 18, 2008 6:33 am
- Forum: PHP - Code
- Topic: Duplicate Data
- Replies: 1
- Views: 129
Duplicate Data
Hi All Can someone please point out to me what is wrong with this code? Each time I refresh the page it inserts duplicate data in database. Other than that it doesn't give out any errors. Some help will be greatly appreciated. <? include("config.php"); function insert(){ $id = $_POST['...
- Mon Nov 03, 2008 12:22 pm
- Forum: PHP - Code
- Topic: Problem with Update
- Replies: 6
- Views: 292
Re: Problem with Update
Its funny you've said that about spliting the queries theboyholty, that's exactly what I have just done and it seems to be ok now all tables are updating fine. I'm fairly sure I could've done this in one query but its just wasting so time. Thanks for repying
Zed
Zed
- Mon Nov 03, 2008 3:44 am
- Forum: PHP - Code
- Topic: Problem with Update
- Replies: 6
- Views: 292
Re: Problem with Update
Sorry I should've made it clear, it basiclly is not updating I have added the commas now it's not giving me any errors message but at the same time its NOT Updating.
Thank you for your reply
Zed
Thank you for your reply
Zed
- Sun Nov 02, 2008 8:16 pm
- Forum: PHP - Code
- Topic: Problem with Update
- Replies: 6
- Views: 292
Problem with Update
Hi ALL Can anyone help me on this query please, all I'm trying to do is Update three tables in a same query. if($_POST['submit']) { foreach($_POST as $job_id) { mysql_query("UPDATE job_tb,blockbook,blockbook2 SET job_tb.cust_address = 'Cancel' blockbook.cust_addr...
- Sat Nov 01, 2008 1:13 am
- Forum: PHP - Code
- Topic: help with code
- Replies: 2
- Views: 332
help with code
Hi All Can someone please help me with this query, there are two MySQL tables ‘user_tb’ and ‘job_tb’ id is the primary key in user_tb and user_id is the foreign key in job_tb. A user populates the user_id by form as his Acc no. All I’m trying to do is to prevent him inserting the wrong Acc no (user_...
- Tue Oct 21, 2008 3:43 pm
- Forum: PHP - Code
- Topic: Select query not working????
- Replies: 2
- Views: 285
Re: Select query not working????
but its bringing out all the records even those are NOT user_id = id. $query2 = "SELECT * FROM blockbook, user WHERE blockbook.user_id = user.id "; I don't see any user_id = id in there, just a relationship between two tables. Thanks tasairis I've managed to sort it. The query s...
- Tue Oct 21, 2008 3:19 pm
- Forum: PHP - Code
- Topic: Select query not working????
- Replies: 2
- Views: 285
Select query not working????
Hi ALL Can someone please tell me why isn't my select query working properly, there are NO errors but its bringing out all the records even those are NOT user_id = id. Same query I'm checking it with phpMyAdmin and it works like charm.Its been three whole days can some take me out of this misery. Th...
- Mon Jun 16, 2008 1:29 pm
- Forum: PHP - Code
- Topic: Full-text search
- Replies: 5
- Views: 552
Re: Full-text search
MyISAM
thanks for looking at my post
Zed
thanks for looking at my post
Zed
- Mon Jun 16, 2008 1:25 pm
- Forum: PHP - Code
- Topic: Full-text search
- Replies: 5
- Views: 552
Full-text search
Hi All I wonder if you could help me I'm trying to write a programm for Full-text search but I can not seem to get the query right. error says it can not connect to databse. Here is my code <?php $database = "sampledb"; $user = "xxxxxxxx"; $pass = "xx...