Re: [PHP] new to php/mysql

2003-01-31 Thread Janos Rusiczki
Most probably you have an error in your MySQL query or you are trying to fetch rows from the connection identifier. But why don't you post the code which generated this error? How can we guess what's wrong in it elseway? Sam wrote: Warning: mysql_fetch_row(): supplied argument is not a valid

Re: [PHP] new to php/mysql

2003-01-31 Thread Matt
"Sam" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > i'm new to this php/mysql thing - i've defected microsoft. > when trying to pull data from a table in mysql, i get the following error: > > Warning: mysql_fetch_row(): supplied argument is not a valid MyS

Re: [PHP] New to PHP/mySQL - Help on script

2002-08-26 Thread Adam Williams
you need $query = SELECT COUNT(*) as count FROM bookings WHERE ('2002-04-04') BETWEEN booking_start AND booking_end OR ('2002-04-10')BETWEEN booking_start AND booking_end AND villa_id = ('3') $villa = mysql_query($query); while ($result = mysqul_result($villa)) { echo "We have $result[count] vi

Re: [PHP] new to php/mysql - insert not working

2002-03-20 Thread Michael Egan
Robert, I still feel fairly new to this myself but if I find that I'm having problems writing to the database I generally try to echo the query to the page and then test this out directly with the command line prompt directly to the database. At least that way you can test out the query in isola