Search found 32 matches

by zed420
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...
by zed420
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 ...
by zed420
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...
by zed420
Mon Nov 24, 2008 9:04 am
Forum: PHP - Code
Topic: Duplicate output
Replies: 2
Views: 151

Re: Duplicate output

Thanks
Zed

aceconcepts wrote:I would imagine it's because you're querying two tables without using a JOIN.

Look up "sql join" in Google.
by zed420
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...
by zed420
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. ...
by zed420
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['...
by zed420
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
by zed420
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
by zed420
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...
by zed420
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_...
by zed420
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 &nbsp;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...
by zed420
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...
by zed420
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
by zed420
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...