[PHP] new to php/mysql

2003-01-31 Thread Sam
hi, 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 MySQL result resource in C:\cn\test.php on line 24 is this an error from my php page or do

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 val

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

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

2002-08-26 Thread Ray Healy \(Data Net Services\)
Thanks for everyones help yesterday but nI have come up against a problem (as I am new). I have created my document as detailed below with notes. I can see from the form that I have connected to the server, accessed the correct database, created the statment and executed it. The problem is how to

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]

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

2002-03-20 Thread ROBERT MCPEAK
Can somebody help me with this? The following code gets me document contains no data. I have done a successfull select from mysql db, but not an insertion. I don't know how to troubleshoot this. Any help is much appreciated. Thanks! ?php $id = addslashes($id); $visitdate =

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