----- Original Message -----
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, August 09, 2001 13:09
Subject: php call to mysql
Modify your code as given below and see. It should work.
DT
> I know this isn't a PHP mailing list, but maybe someone out there can
help.
> This is my first mysql/php project, and I can't seem to get this call to
> mysql to work. I have other queries working, but it seems as though any
> time I try to make a call to one of my auto_increment "IDs," either PHP or
> MySQL doesn't like the way I am querying it. Below is he part of the PHP
> script that is supposed to call the fields from my Cat table in my
database.
> I am sure there are no problems with authentication to get the table or
> problems with which table it is selecting.
>
> <?php
> $result = mysql_query("select * from $table2");
> if ($result){
> while ($row = mysql_fetch_array($result))
> {
$CatID=$row["Cat_ID"];
$CatName=$row["CatName"];
and so on. assuming your fields are CatName.
> print "Cat ID: $row[\"Cat_ID\"]";
> print "Cat Name: $row[\"CatName\"]";
> print "Cat Description: $row[\"CatDescribe\"]";
> print "<B>Delete?</b>";
> print "<input type=checkbox name=\"Cat_ID[]\"
> value=\"\".$row["Cat_ID"].\"\"> Yes, delete entry #".$row[\"Cat_ID\"].\"";
> print " <BR><BR>\n\n";
> }
> mysql_free_result($result);
> }
> ?>
>
> I also tried the above code, but I escaped out the underscores.
>
> Thanks a lot for your help.
>
> Sorry for the indirect mysql question. (PHP question)
>
> -Christian Evans
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
