Re: insert failed!

bill_at_here.com
Date: 03/06/05


Date: Sun, 6 Mar 2005 15:19:05 -0000


> problem seems to be fixed. for the record i will say what i did.
>
> first after hours of trying i switched off pc and read magazine (closer).
>
> then came back to problem and changed the insert query from:
>
> mysql_query("INSERT INTO blisssession
>
(cust_id,customer,price,duration,bed,teammember,comments,date,day,month,minu
> te,hour) VALUES
>
('$cust_id','$customer','$price','$duration','$bed','$teammember','$comments
> ','$date2','$day','$month','$minute','$hour')") or die(" could not perform
> insert");
>
> to:
>
> mysql_query("INSERT INTO blisssession VALUES
>
('$cust_id','$customer','$price','$duration','$bed','$teammember','$comments
> ','$date2','$day','$month','$minute','$hour')") ;//or die(" could not
> perform insert");
>
>
> AND IT WORKED.
>
> but i dont know why... can any of you see why? or would you need table
> details?
>

NO IT DIDNT WORK. it just looked like it worked because i removed 'or
die("could not perform insert");'

so any help appreciated!



Relevant Pages

  • Re: multi table multi database join?
    ... dont i have some kind of filter? ... sybase runns on one machine mssql on another, ... the data from the aggregate db could be used in a query to ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: What to do with a Null Value that is returned from a Select. ??
    ... but I dont seem to be able catch it properly. ... > SqlConnection myConnection = new SqlConnection ... > //Run Query to compare the Email Address ... > The HTML is simple and just contains a text box. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Employee Emergency
    ... I dont want to be a burden but i have another problem but this time it has ... > listbox/combobox) the order ID to match to an employee, then the query ... > step, i.e. first just the tables and the orderID filter, then the group ...
    (microsoft.public.access.queries)
  • Re: 2.6.7-mm1 - 2.6.7-mm4 weird http behavior
    ... i remember when changing to 2.6.7-rc3, lkml.org didnt work.. ... i am not a expert, so i dont really know, but i didnt see anything ... >> there is a bug in FreeBSD? ... To unsubscribe from this list: send the line "unsubscribe linux-kernel" in the body of a message to majordomo@vger.kernel.org More majordomo info at http://vger.kernel.org/majordomo-info.html Please read the FAQ at http://www.tux.org/lkml/ ...
    (Linux-Kernel)
  • RE: returning multiple values in a MAX qry
    ... "DawnTreader" wrote: ... no i dont have 2 entries on the same date. ... and october 25 both show up in the second query when i run it. ... gather the data for the sub form is showing 2 records for one compressorID ...
    (microsoft.public.access.queries)