LOSING CONNECTION

[SOFTWARE]

If I do a the following using mysql_query

SELECT * FROM cine_ticket_tra nsaction WHERE performance_day ='2004-10-28'
AND film_name='Les miserable'

If the record does not exist, I lose the connection with the mysql server.

Any help appreciated.

Maurice Breault
software@omnite rm.com

[Sal Young]

Re: LOSING CONNECTION

How do you know the connection is open if the query has a result?

As far as I know, every query statement you execute opens a connection and
it closes the connection once it finishes execution.

"SOFTWARE" <maubreault@hot mail.com> wrote in message
news:8KCdndvctv xzphDcRVn-jw@look.ca...[color=blue]
> If I do a the following using mysql_query
>
> SELECT * FROM cine_ticket_tra nsaction WHERE performance_day ='2004-10-28'
> AND film_name='Les miserable'
>
> If the record does not exist, I lose the connection with the mysql server.
>
> Any help appreciated.
>
> Maurice Breault
> software@omnite rm.com
>[/color]

[cc0356490]

Re: LOSING CONNECTION

SOFTWARE wrote:[color=blue]
> If I do a the following using mysql_query
>
> SELECT * FROM cine_ticket_tra nsaction WHERE performance_day ='2004-10-28'
> AND film_name='Les miserable'
>
> If the record does not exist, I lose the connection with the mysql server.
>
> Any help appreciated.
>
> Maurice Breault
> software@omnite rm.com
>
>[/color]
Are your logfile options turned on and showing any useful information?
If your logfiles are on, and not showing anything, you might need to
turn up the output to see exactly what is going on......