ODBC

[Anon]

Anyone has any idea how to best get amount of rows in a query, if odbc_num_rows does not work.
/Staffan

[Anon]

If $query is your executed query, try this.

$count = 0;
while(odbc_fetch_row($query)){
$count = $count +1;
}
echo $count;

I hope this helps, this is my first time answering a forum question.

[Anon]

Doesn't that take a lot of memory if it is a lot of rows ?...

---

Then I have to ask another thing.
I thougt the usage of sql querys would be simular to mySQl, but I get a syntax error on following query, which work just fine with mySql..

---

$conn = odbc_connect($server, $username, $password);
$query = "INSERT INTO mess (receiver,sender,topic,message,date) VALUES('$receiver','$username','$topic','$message','$date')";
odbc_do($conn, $query);
odbc_close_all();

---

The table has following fields
id, receiver, sender, topic, message, date, status, noreply.

And this is the errormessage I get;

Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement., SQL state 37000 in SQLExecDirect in c:\inetpub\wwwroot\cup\newMessage.php on line 51

/Staffan

[Anon]

The while(loop) may take up alot of memory.

As for the INSERT INTO, take a look at your tables in the design view of Access and see what format you have the $date column set to. If the date format doesn't match how you have been entering $date data this may be causing your problem.

Right click on the mess table and click design view. Click on the $date column and click input mask. I use 'Medium Date', it follows this pattern '15-jun-73' for input.

Give that a try, dates can cause alot of trouble.

[Anon]

Does odbc_num_rows() return -1? If so, then the driver can't supply that information ahead of time. As an alternative, especially if the count matters more than the data, just do a 'select count(*) from...' query using the exact same where-condition.

[Anon]

Ok, think that solved my problem.
Thanks !

/Staffan

[Anon]

I thought i had it right this time, but I still get that syntax error messages.

Bacause of me useing swedish time format, I have to format the date befor I put it into the database. So it is formated into a string.

Here's the query again...

"INSERT INTO mess(receiver,sender,topic,message,date) VALUES('$receiver','$username','$topic','$message','$date')";

/Staffan

[Anon]

I figured out that you are not allowed to
have a field in tha database named " date ".
So I just renamed it and made some changes in my code. Now it works just fine.

/Staffan