how to reCREATE THE VIEW ? PRIVILEGES ?

Und alles was mit phpMyAdmin seine Verwandtschaft findet hat hier seinen Platz.

how to reCREATE THE VIEW ? PRIVILEGES ?

Postby lse123 » 15. November 2008 14:28

I do a MYSQL VIEW I think via running a php file with below...

but I delete it from phpMyAdmin by error, well now I return to php file but VIEW does not get recreated, what to do ? how to CREATE THE VIEW ? PRIVILEGES (I do not change anything) ?

in php file appears:

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/content/p/o/l/polisch123/html/administration/bookings10nov2008.php on line 213 [ this line contains : mysql_free_result($result); ]

Code: Select all
<? $active = 'active'; 
$query_view2 = "CREATE VIEW admin_bookings2 (name,mob,fixed,cstatus,email,bookingid,dateplaced,status,datep,dated,Locationp,Locationd,days,mostdaysrate,vat,off,total,cat,discount2) AS 
SELECT $CustomersTable.name,$CustomersTable.mob,$CustomersTable.fixed,$CustomersTable.status,$CustomersTable.email,$BookingsTable.bookingid,$BookingsTable.dateplaced,$BookingsTable.status,$BookingsTable.datep,$BookingsTable.dated,$BookingsTable.Locationp,$BookingsTable.Locationd,$BookingsTable.days,$BookingsTable.mostdaysrate,$BookingsTable.vat,$BookingsTable.off,$BookingsTable.total,$BookingsTable.cat,$BookingsTable.discount2 
FROM $CustomersTable, $BookingsTable 
WHERE $CustomersTable.email = $BookingsTable.email AND cstatus='active'"; //$CustomersTable.status = $active 
// ---------- 
$result_view = @mysql_query($query_view2,$linkid); 
$query = "SELECT * FROM admin_bookings2 WHERE dated>='$today' ORDER BY $orderby "; // dateplaced dated AND dated>='$today'"; email='$email6' AND status!='canceled' // appear bookings dated>=time() AND time()<='$dated'canceled 
$result = @mysql_query($query,$linkid); 
$count = @mysql_num_rows($result); 
echo " ( Your query returned " . $count . " items. )"; 
?>
Leonidas Euripide Savvides
lse123
 
Posts: 109
Joined: 15. November 2008 13:49
Location: Polis, Paphos
XAMPP Version: 1.8.3-3
Operating System: vista 64 ultimate

Return to phpMyAdmin

Who is online

Users browsing this forum: No registered users and 3 guests