Insert multiple tables error

[thachp]

Below is my current php script. I was able to use it to insert the first data, but i'm receiving query2 error when i try to add more data. Why? Got altenative suggestions?

<?php
include 'global.php';

    $category   = $_POST['category'];
    $keyword = $_POST['keyword'];
    $zone = $_POST['zone'];
    $link = $_POST['link'];
    $advertiser = $_POST['advertiser'];
    
    if(!get_magic_quotes_gpc())
    {
        $category   = addslashes($category);
        $keyword = addslashes($keyword);
        $zone = addslashes($zone);
        $link = addslashes($link);
        $advertiser = addslashes($advertiser);
    }
        
    $query = "INSERT INTO tbl_cats(category) VALUES ('$category')";
    $query2 = "INSERT INTO tbl_keyword(category,keyword) VALUES ('$category', '$keyword')";
    $query3 = "INSERT INTO tbl_zone(keyword,zone,links,advertiser) VALUES ('$keyword', '$zone', '$link', '$advertiser')";
    
    mysql_query($query) or die('Uh oh! Query failed');
    mysql_query($query2) or die('Uh oh! Query 2 failed');
    mysql_query($query3) or die('Uh oh! Query 3 failed');
?>

Thank a head.

[r937]

your mysql looks fine(*)

moving to php forum


* other than treating what are undoubtedly numeric columns as character (don't put single quotes around values intended to be inserted into numeric columns)